I've tried finding the solution to my error on multiple website, as well as other questions on serverfault. None have fixed this error for me.
MySQL was working just fine up until I added the following to my.cnf:
Once I restarted MySQL I received the error:
MySQL Daemon failed to start. Starting mysqld: [FAILED]
I tried removing what I had added to my.cnf and tried starting MySQL but it still refused to start. I checked to see if mysql.sock was in /var/lib/mysql/ but it wasn't. I tried adding a blank mysql.sock file, chowning it mysql, and chmoding it to 4777. It still wouldn't start.
I also have tried removing and updating mysql and mysql-server, neither of which worked. Nothing seems to be working so I came here to see if you guys had any other suggestions that might help.
Yes the problem is clearly that mysql.sock doesn't exist, but how should I add it properly or is there a way to have MySQL create it?
Below are my log files of attempting to start MySQL along with my my.cnf configuration file:
110608 16:07:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 110608 16:07:05 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 480 error messages, but it should contain at least 709 error messages. Check that the above file is the right version for this program! 110608 16:07:05 [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Unknown error 1146 110608 16:07:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 110608 16:07:05 InnoDB: The InnoDB memory heap is disabled 110608 16:07:05 InnoDB: Mutexes and rw_locks use GCC atomic builtins 110608 16:07:05 InnoDB: Compressed tables use zlib 1.2.3 110608 16:07:05 InnoDB: Using Linux native AIO 110608 16:07:05 InnoDB: Initializing buffer pool, size = 128.0M 110608 16:07:05 InnoDB: Completed initialization of buffer pool 110608 16:07:05 InnoDB: highest supported file format is Barracuda. 110608 16:07:05 InnoDB: Waiting for the background threads to start 110608 16:07:06 InnoDB: 1.1.7 started; log sequence number 1595675 110608 16:07:06 [ERROR] Aborting 110608 16:07:06 InnoDB: Starting shutdown... 110608 16:07:07 InnoDB: Shutdown completed; log sequence number 1595675 110608 16:07:07 [Note] 110608 16:07:07 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 connection arguments: '--socket=/var/lib/mysql/mysql.sock' 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
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 # Disabling symbolic-links is recommended to prevent assorted security risks; # to do so, uncomment this line: # symbolic-links=0 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [client] socket=/var/lib/mysql/mysql.sock