Hi Guys!

Can you help me with this one.? I have a problem i cant start mysql of my server after the update. my operating system is centos. I get this error.

I get this error
MySQL Daemon failed to start.
Starting MySQL: [FAILED]—

I really have no idea! Thanks in advance.

What do your error logs say?

1 members found this post helpful.

Hi Sir,

here is what i encounter.

MySQL Daemon failed to start.
Starting MySQL: [FAILED]

here are those logs.

100614 09:40:41 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100614 09:49:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100614 9:49:45 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
100614 9:49:45 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100614 9:49:45 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100614 9:49:45 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100614 9:49:45 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
100614 9:49:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.

error from httpd
[Mon Jun 14 16:08:54 2010] [error] [client 77.88.31.246] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) in /mnt/md1/www/links/includes/open_db.php on line 19

Well, I suggest you do what the error log says and run mysql_upgrade on the CLI.