/usr/sbin/mysqld: Table 'plugin' is read only. Cant start my Mysql

jackaldu

Member
Jul 18, 2014
8
0
1
cPanel Access Level
Root Administrator
Could anybody tell me how can i solve it?

Code:
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
- - - Updated - - -

Update still no luck

Code:
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
 

jackaldu

Member
Jul 18, 2014
8
0
1
cPanel Access Level
Root Administrator
Could anybody tell me how can i solve it?



- - - Updated - - -

Update still no luck
I cleared my.cnf and it is now :


Code:
[email protected] [~]# 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 :(
 

jackaldu

Member
Jul 18, 2014
8
0
1
cPanel Access Level
Root Administrator
Could anybody tell me how can i solve it?



- - - 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

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 [email protected] /]cPs# mysql
-bash: /usr/bin/mysql: Permission denied

I checked and changed the permissions on the binary:

[08:10:327 [email protected] /usr/bin]cPs# ls -lsa mysql
3828 -rw-r--r--. 1 root root 3908986 Apr 3 23:53 mysql

[08:11:13 ns306747 [email protected] /usr/bin]cPs# chmod 0755 mysql

And now I can connect to the service:

[08:14:46 [email protected] /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
Bye
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,216
463
Hello :)

I am happy to see the issue is now resolved. Thank you for updating us with the outcome.