Simple Solution Worked for Me
All,
I wrangled with this problem for a while, and found a very simple solution that worked.
In the directory /var/lib/mysql/ are files with names similar to: "mysql-bin.000xxxx". Most of them were owned by mysql:mysql, but the latest one (by number) was owned by root:root.
I believe the latest file was written when I executed '/usr/libexec/mysqld --user=root &' to start the DB.
By changing the ownership of the latest mysql-bin.xxx file from root:root to mysql:mysql using 'sudo chown mysql:mysql mysql-bin.xxxx', I was then able to start MySQL with /etc/init.d/mysqld start.
Hope this helps.
|