Topic: Unable to start MySQL - V5.1.47-1
Afternoon all,
My system is Red Hat Enterprise Linux 5.3 x86_64 and I have just installed the following packages:
mysql - All version 5.1.47-1.el5
mysqlclient15
mysql-devel
mysql-libs
mysql-server
perl-DBD-mysql
php - All version 5.3.2-1.el5
php-cli
php-common
php-mysql
php-pdo
sqlite2-2.8.17-2.el5
Once installed I go to start the MySQL service by issuing the command:
service mysqld start
However I get the following output:
[root@Stephenson phprpms]# service mysqld start
MySQL Daemon failed to start.
Starting mysqld: [FAILED]
Upon looking at the log I see some error messages but don't know what they mean, anyone shed any light?
100608 16:01:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
/usr/libexec/mysqld: Unknown collation '#46' in table 'plugin' definition
100608 16:01:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
100608 16:01:53 InnoDB: Started; log sequence number 0 46409
100608 16:01:53 [ERROR] Fatal error: Can't open and lock privilege tables: Unknown collation '#46' in table 'host' definition
100608 16:01:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Really need to get this working ASAP.
Cheers.