Few MySql Error Help

Albertwu posted this at 09:02 — 2nd March 2016.

Joined: Oct 2015

Hi,

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

Database User Permissions

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

Database Permissions Error

Code:
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 :

Code:
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