This weekend I upgraded another server with the same result as above. I was able to work around it by
#mv /var/lib/mysql /var/lib/mysql.orig #mkdir /var/lib/mysql #chmod /var/lib/mysql to match mysql.orig #chown mysql:mysql /var/lib/mysql #mv /var/lib/mysql.orig/mysql /var/lib/mysql/mysql #start mysql
There is apparently some problem with one or more of the files in /var/lib/mysql.orig restarting mysql creats new one which work fine.
Once I did this I was able to move the old mysql tables in subdirectories of /var/lib/mysql with out any problems.
I hope this helps someone.
This weekend I upgraded another server with the same result as above. I was able to work around it by
#mv /var/lib/mysql /var/lib/mysql.orig mysql.orig/ mysql /var/lib/ mysql/mysql
#mkdir /var/lib/mysql
#chmod /var/lib/mysql to match mysql.orig
#chown mysql:mysql /var/lib/mysql
#mv /var/lib/
#start mysql
There is apparently some problem with one or more of the files in /var/lib/mysql.orig restarting mysql creats new one which work fine.
Once I did this I was able to move the old mysql tables in subdirectories of /var/lib/mysql with out any problems.
I hope this helps someone.