/usr/sbin/mysqld: Table 'plugin' is read only. Cant start my Mysql
Could anybody tell me how can i solve it?
[COLOR="silver">- - - Updated - - - Update still no luck
140719 01:22:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140719 1:22:46 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
140719 1:22:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140719 1:22:46 InnoDB: The InnoDB memory heap is disabled
140719 1:22:46 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140719 1:22:46 InnoDB: Compressed tables use zlib 1.2.3
140719 1:22:46 InnoDB: Using Linux native AIO
/usr/sbin/mysqld: Can't create/write to file '/tmp/ibOTiTeV' (Errcode: 13)
140719 1:22:46 InnoDB: Error: unable to create temporary file; errno: 13
140719 1:22:46 [ERROR] Plugin 'InnoDB' init function returned error.
140719 1:22:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140719 1:22:46 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140719 1:22:46 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140719 1:22:46 [Note] Server socket created on IP: '0.0.0.0'.
140719 1:22:46 [ERROR] Can't start server : Bind on unix socket: Permission denied
140719 1:22:46 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
140719 1:22:46 [ERROR] Aborting
140719 1:22:46 [Note] /usr/sbin/mysqld: Shutdown complete[COLOR="silver">- - - Updated - - - Update still no luck
140719 01:31:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140719 1:31:07 [Warning] ignore-builtin-innodb is deprecated and will be removed in future releases.
140719 1:31:07 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'plugin' is read only
140719 1:31:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140719 1:31:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140719 1:31:07 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140719 1:31:07 [Note] Server socket created on IP: '0.0.0.0'.
140719 1:31:07 [ERROR] Can't start server : Bind on unix socket: Permission denied
140719 1:31:07 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
140719 1:31:07 [ERROR] Aborting
140719 1:31:07 [Note] /usr/sbin/mysqld: Shutdown complete-
[quote="jackaldu, post: 1689892">Could anybody tell me how can i solve it? [COLOR="silver">- - - Updated - - - Update still no luck
I cleared my.cnf and it is now :root@ns306747 [~]# mysql_install_db --user=mysql --basedir=/usr/ --ldata=/var/lib/mysql/ Installing MySQL system tables... ERROR: 1036 Table 'db' is read only 140719 6:53:33 [ERROR] Aborting 140719 6:53:33 [Note] /usr//sbin/mysqld: Shutdown complete
Still no luck :(0 -
[quote="jackaldu, post: 1689892">Could anybody tell me how can i solve it? [COLOR="silver">- - - Updated - - - Update still no luck
Hear is the solution maybe someone will have similar problem. Mark from Cpanel solved it. Just have to say to top notch professionalism So hear it is [QUOTE]Hello, The problem was with a couple of things: 1. Your root partition was chmod 0000, meaning nothing could be read or written to disk: [WARN] * Non-default Permissions: / (mode: 0000 | default: 0755 or 0555) I changed the permissions back to 0755, and after that I could start the MySQL service: [08:11:23 root /usr/bin]cPs# /etc/init.d/mysql start Starting MySQL.... SUCCESS! 2. The permissions on the mysql binary in /usr/bin did not have execute permissions resulting in a permission denied when trying to log into MySQL: [08:09:35 root@ /]cPs# mysql -bash: /usr/bin/mysql: Permission denied I checked and changed the permissions on the binary: [08:10:327 root@523 /usr/bin]cPs# ls -lsa mysql 3828 -rw-r--r--. 1 root root 3908986 Apr 3 23:53 mysql [08:11:13 ns306747 root@5235093 /usr/bin]cPs# chmod 0755 mysql And now I can connect to the service: [08:14:46 root@5235093 /usr/bin]cPs# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 42 Server version: 5.5.37-cll MySQL Community Server (GPL) Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> quit Bye0 -
Hello :) I am happy to see the issue is now resolved. Thank you for updating us with the outcome. 0
Please sign in to leave a comment.
Comments
3 comments