tag:blogger.com,1999:blog-23076680.post684645871368153181..comments2023-10-31T09:34:20.315-04:00Comments on TΩИΨ: CentOS - How to Upgrade MySQL 5.1 to 5.6Tony Li Xuhttp://www.blogger.com/profile/10146779495057607642noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-23076680.post-84885561542202933472017-01-25T05:36:55.495-05:002017-01-25T05:36:55.495-05:00Good guide. The only problem I had is that afterwa...Good guide. The only problem I had is that afterwards mysqld would not start.<br />In the log file (/var/log/mysqld.log) I found the following error:<br /><br />[ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.<br /><br />Since the server couldn't start mysql_upgrade also couldn't run.<br />I found this to be the solution: http://stackoverflow.com/questions/36156475/mysqld-doesnt-start-after-brew-upgrade-from-5-6-to-5-7<br /><br />First, start your mysql without reading the user table: mysqld --skip-grant-tables<br /><br />Then run mysql_upgrade which should now run smoothly.<br /><br />Next stop mysqld: killall mysqld.<br /><br />Now you should be able to start up your mysql service normally again.Peter Marcoenhttps://www.blogger.com/profile/13302579507242771431noreply@blogger.comtag:blogger.com,1999:blog-23076680.post-88039874744460890612017-01-25T05:36:22.528-05:002017-01-25T05:36:22.528-05:00Good guide. The only problem I had is that afterwa...Good guide. The only problem I had is that afterwards mysqld would not start.<br />In the log file (/var/log/mysqld.log) I found the following error:<br /><br />[ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.<br /><br />Since the server couldn't start mysql_upgrade also couldn't run.<br />I found this to be the solution: http://stackoverflow.com/questions/36156475/mysqld-doesnt-start-after-brew-upgrade-from-5-6-to-5-7<br /><br />First, start your mysql without reading the user table: mysqld --skip-grant-tables<br /><br />Then run mysql_upgrade which should now run smoothly.<br /><br />Next stop mysqld: killall mysqld.<br /><br />Now you should be able to start up your mysql service normally again.Peter Marcoenhttps://www.blogger.com/profile/13302579507242771431noreply@blogger.com