Error on starting mysqld
# tail -f /var/log/mysqld.log
120807 14:48:55 InnoDB: Started; log sequence number 0 161811
120807 14:48:55 [ERROR] Column count of mysql.db is wrong. Expected 22, found 20. Created with MySQL 50***, now running 50***. Please use mysql_upgrade to fix this error.
120807 14:48:55 [ERROR] mysql.user has no `Event_priv` column at position 29
120807 14:48:55 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
120807 14:48:55 [Note] /usr/libexec/mysqld: ready for connections. Version: ‘5.*.**’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
# mysql_fix_privilege_tables –verbose –password=************
This script updates all the mysql privilege tables to be usable by
the current version of MySQL
You can safely ignore all ‘Duplicate column’ and ‘Unknown column’ errors
because these just mean that your tables are already up to date.
This script is safe to run even if your tables are already up to date!
ERROR 1060 (42S21) at line 102: Duplicate column name ‘File_priv’
ERROR 1060 (42S21) at line 108: Duplicate column name ‘Grant_priv’
….
ERROR 1054 (42S22) at line 663: Unknown column ‘Trigger_priv’ in ‘where clause’
done
# service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
# tail -f /var/log/mysqld.log
120807 15:02:34 InnoDB: Starting shutdown…
120807 15:02:36 InnoDB: Shutdown completed; log sequence number 0 161811
120807 15:02:36 [Note] /usr/libexec/mysqld: Shutdown complete
120807 15:02:36 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
120807 15:18:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
120807 15:18:44 InnoDB: Started; log sequence number 0 161811
120807 15:18:44 [Note] Event Scheduler: Loaded 0 events
120807 15:18:44 [Note] /usr/libexec/mysqld: ready for connections.Version: ‘5.*.**’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 Source distribution
Leave a Reply