Few MySql Error Help

They have: 15 posts

Joined: Oct 2015


Following are the mysql Errors that i face during creating the mysql database permissions and user permissions for database.

Database User Permissions

Failed to save user : SQL flush privileges failed : Table 'mysql.servers' doesn't exist

Database Permissions Error

Failed to save database permissions : SQL flush privileges failed : Table 'mysql.servers' doesn't exist

and the following are the Error that appear while Making a database backup file within the VPS.

Database backup failed : mysqldump failed :

mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'test1_justcc'': Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50095, now running 50530. Please use mysql_upgrade to fix this error. (1558)

I try run via root mysql_upgrade -u root -p then entering password and its showing the following results like.

mysql>mysql_upgrade -u root -p

and nothing happen.

MySQL Version is "Server version: 5.5.30 MySQL Community Server (GPL) by Remi"

Note: i use Webmin panel 1.620 for all of this actions to creating database permissions etc