1

After upgrading MySQL to version 5.6.10 from version 5.5 I'm getting the following errors when starting MySQL server:

2013-03-19 05:32:38 2666 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.6.10' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL) 2013-03-19 05:43:27 2666 [ERROR] Incorrect definition of table mysql.proc: expected column 'comment' at position 15 to have type text, found type char(64). 

I checked out the mysql.proc table and the comment field is set to TEXT. I ran mysql_upgrade after the upgrade. I tried running it again with --force after seeing that error, but that didn't fix it.

1 Answer 1

1

This question on stackoverflow links to a bug report that mentions:

"start the server with the --skip-grant-tables option to cause it to skip the normal grant table checks, then run mysql_upgrade. ... Then stop the server and restart it normally." 

reference URL from the bug report was: http://dev.mysql.com/doc/refman/5.5/en/news-5-5-7.html

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.