[CentOS] MySQL on CentOS 6 broken? No 'mysql' database?

Jason T. Slack-Moehrle

slackmoehrle at gmail.com
Tue Feb 7 00:51:26 UTC 2012


Hi Guys,

I installed CentOS 6 and installed 'yum install mysql mysql-devel mysql-server'

When I try and start MySQL I get:
120206 16:42:07 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
120206 16:42:07 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120206 16:42:07 InnoDB: Started; log sequence number 0 44233
120206 16:42:07 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist
120206 16:42:07 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended



if I go look in /var/lib/mysql I see:

-rw-rw----. 1 mysql mysql 10485760 Feb 5 16:53 ibdata1
-rw-rw----. 1 mysql mysql 5242880 Feb 6 16:42 ib_logfile0
-rw-rw----. 1 mysql mysql 5242880 Feb 5 16:33 ib_logfile1
drwx------. 2 mysql mysql 4096 Feb 5 16:55 mysql
drwx------. 2 mysql mysql 4096 Feb 5 16:55 test



and the 'mysql' is empty.

I dont understand, I have never had this issue. I assume that the 'mysql' directory should contain something?

So with this, I cannot do anything to get MySQL going!

I tried a 'yum upgrade' to make sure everything was up to date.

[root at www mysql]# cat /etc/*release*
CentOS release 6.2 (Final)
cat: /etc/lsb-release.d: Is a directory
CentOS release 6.2 (Final)
CentOS release 6.2 (Final)
cpe:/o:centos:linux:6:GA



Any thoughts?
-Jason




More information about the CentOS mailing list