I recently corrupted the mysql.user
table in my mysql install on centos 5.6, so I removed the mysql
and mysql-server
packages and then removed /var/lib/mysql
. Then, I re-installed mysql
and mysql-server
via yum
. Here is the output of SELECT user.User FROM mysql.user;
mysql> SELECT User FROM user;
+------+
| User |
+------+
| root |
| |
| root |
| |
| root |
+------+
5 rows in set (0.00 sec)
Does anybody know if there is a data file other than /var/lib/mysql
laying around somewhere? Or just how to solve this?
Here is the result of SELECT Host, User FROM user;
mysql> SELECT Host, User FROM user;
+---------------+------+
| Host | User |
+---------------+------+
| 127.0.0.1 | root |
| server-name |
| server-name | root |
| localhost | |
| localhost | root |
+---------------+------+
5 rows in set (0.00 sec)