Table 'mysql.servers' doesn't exist

[ViAdCk]

Hi,

On one server when we change a user password through directadmin it gives the folowing error:

Error Flushing Privileges: Table 'mysql.servers' doesn't exist

But the password does change correctly. This also causes that mysql usernames aren't included in directadmin backups.

Any idea how this can be fixed?

Thanks!

 

[zEitEr]

Hello,

Try

mysql --defaults-extra-file=/usr/local/directadmin/conf/my.cnf mysql

and execute the query

CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT='MySQL Foreign Servers table';

and/or run

mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --force

 

[ViAdCk]

Thanks, that worked fine

 

[ViAdCk]

Update: changing the passwords inside directadmin doesn't give any errors but when we create a backup we see the following in the mysql error log:

[ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist

When we restore the backup, the mysql users are missing.

Any idea how to fix this?

 

[zEitEr]

What output did you have from the commands in post #2 ?

 

[ViAdCk]

The "servers" table was created correctly and I can see the table correctly in phpmyadmin.

I haven't executed the following code:

mysql_upgrade --defaults-extra-file=/usr/local/directadmin/conf/my.cnf --force

What does that code do exactly? I prefer not to update mysql on this server as we are moving users away from this server.

 

[zEitEr]

https://dev.mysql.com/doc/refman/5.7/en/mysql-upgrade.html