We did an update last night and now we are experiencing a very odd issue.
When mysqld is started using "service mysqld start" or when the server boots up mysql server page in Webmin shows that only information_schema and test databases are available. If I run "killall mysqld" until no mysqld processes are left running, I can then run mysqld_safe --skip-grant-tables & and the databases show up fine. It appears that the system has disassociated the mysql databases stored in /var/lib/mysql/ and I cannot find where it is pulling the others from.
Root is the user that the mysql server is using and the password is correct.
Any help would be appreciated as I do not want to reimage and reinstall everything like I had to do last time. I would prefer to figure out how to fix this as I am tired of reinstalling after every update.
Thanks!
Howdy,
Hmm, that's an odd issue!
Did you by chance load a MySQL version from a third party repository?
What you're describing could happen if there was a significant MySQL version change the took place.
If you're using CentOS, what output does this command produce:
rpm -qa | grep -i mysqlReturns This
[root@host ~]# rpm -qa | grep -i mysql mysql-server-5.1.67-1.el6_3.x86_64
mysql-libs-5.1.67-1.el6_3.x86_64 MySQL-python-1.2.3-0.3.c1.1.el6.x86_64 dovecot-mysql-2.0.9-5.el6.x86_64 perl-DBD-MySQL-4.013-3.el6.x86_64 mysql-5.1.67-1.el6_3.x86_64 php-mysql-5.3.3-22.el6.x86_64 mysql-connector-odbc-5.1.5r1144-7.el6.x86_64 mysql-devel-5.1.67-1.el6_3.x86_64