Submitted by yaminz66 on Fri, 06/28/2013 - 09:15
HI
I am not able to do any updates to the MYSQL server database or create a database. I keep getting this message
"SQL flush privileges failed : Table 'mysql.servers' doesn't exist!"
I have tried to change the password through Webmin -> Servers -> MySQL, you can go into " Change Administration Password". but same problem.
I also tried to run "mysqlcheck --check-upgrade --all-databases --auto-repair" get root@localhost denied eventhough I am logged in as root.
Can you help please.
Yamin
Status:
Active
Comments
Submitted by andreychek on Fri, 06/28/2013 - 09:18 Comment #1
Howdy -- hmm, did you change to a non-standard MySQL version?
The errors you're seeing can occur when changing to a version that's not provided by CentOS.
What output do you receive if you run this command:
rpm -qa | grep -i mysql