after update mysqld no longer loads correct databases

Webmin
1

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!

2

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 mysql

3

Returns 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