Find the answer to your Linux question:
Results 1 to 2 of 2
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 ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Linux Newbie cybersmurf's Avatar
    Join Date
    Apr 2006
    Posts
    122

    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:

    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
    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
    The problem with developing something completely foolproof is underestimating the complete ingenuity of fools ~Unknown

  2. #2
    Linux Newbie cybersmurf's Avatar
    Join Date
    Apr 2006
    Posts
    122
    note: my.cnf does not exist either, and I installed on FC12 using yum for the mysql-server and mysql
    The problem with developing something completely foolproof is underestimating the complete ingenuity of fools ~Unknown

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •