MySql Socket does not exist
I cannot get MySql to start, at all keeps telling me the socket does not exsist, I can't create it, the mysql user had been set to have read/write rights to the entire /var/lib/mysql directory, still cannot get anything to start.
Tried mysql_upgrade, it cannot connect to the socket due to the service not running, which doesnt even exist under the /etc/rc.d folder
I have given the mysql user rights to the mysql folder, doesnt seem to help, and I checked that it was recursive through the whole folder
Error Logs Below:
Quote:
100420 20:50:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100420 20:50:51 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100420 20:50:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100420 20:50:51 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100420 20:50:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100420 20:52:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100420 20:52:30 [Warning] Can't create test file /var/lib/mysql/StarTest.lower-test
100420 20:52:30 [Warning] Can't create test file /var/lib/mysql/StarTest.lower-test
100420 20:52:30 [Warning] One can only use the --user switch if running as root
100420 20:52:30 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100420 20:52:30 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100420 20:52:30 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100420 20:52:30 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100420 21:09:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100420 21:09:59 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100420 21:09:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100420 21:09:59 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100420 21:09:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100420 21:11:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100420 21:11:18 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100420 21:11:18 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100420 21:11:18 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100420 21:11:18 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100420 21:33:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100420 21:33:10 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100420 21:33:10 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100420 21:33:10 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100420 21:33:10 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100420 21:46:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100420 21:46:29 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100420 21:46:29 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100420 21:46:29 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100420 21:46:29 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Quote:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
FATAL ERROR: Upgrade failed
