How To Fix MySQL Remote Login Errors

Author: , August 25th, 2016

In this case I had done a restore from a MySQL 5.1 server to a MySQL 5.6 server. That was not too smart, because it broke the mysql database table structures and prevented me from logging in remotely. Local login worked both via the socket and TCP. mysql -u root -p -h remoteHostName Enter password: […]

How To Fix MySQL Error “Cannot load from mysql.proc. The table is probably corrupted”

Author: , July 22nd, 2013

Do a full backup first, just in case! mysql_upgrade -u root -p