Hello i accidental delete from /var/lib/mysql the mysql.sock file ! and now can start mysql I use centos ! what should i do !!!!!!!!
[root@host tmp]# /etc/init.d/mysqld restart Stopping mysqld: [ OK ] MySQL Daemon failed to start. Starting mysqld: [FAILED]
have you google it ? what linux distribution are you using ? also mysql.sock should be recreated when mysql server starts ... do you have a line in you my.cnf with bin-logging (log-bin=mysql-bin) ? ... comment it out and try again
i am googling 2 hours now !! Centos and mysql 5.5 i add that to my.cfn log-bin=/var/lib/mysql/binlog 130609 21:05:52 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 130609 21:05:53 [Note] Plugin 'FEDERATED' is disabled. /usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13) 130609 21:05:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it. 130609 21:05:53 InnoDB: The InnoDB memory heap is disabled 130609 21:05:53 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130609 21:05:53 InnoDB: Compressed tables use zlib 1.2.3 130609 21:05:53 InnoDB: Using Linux native AIO 130609 21:05:53 InnoDB: Initializing buffer pool, size = 128.0M 130609 21:05:53 InnoDB: Completed initialization of buffer pool 130609 21:05:53 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. 130609 21:05:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
