Error table "mysql.servers" does not exist

Question

I get the error "The table" mysql.servers "does not exist" from plesk when I try to create a new database user, the created user does not appear anywhere, but the name is still saved and it does not allow me to access the database .

edit I was unable to log in to phpMyAdmin on this web server, so instead I managed to log into it through a different domain and it tells me a notification: your PHP MySQL library version 5.0.90 is different from MySQL version 5.1.49. This can cause unpredictable behavior.

change phpmyadmin is manually installed, then libmcrypt is manually installed (which is an achievement with my gross skills: D), so phpmyadmin works. Then they accidentally figured out how to log in as root via plesk (the trick is to enter webadmin without selecting any database), at least I think it is root: S started sql: GRANT SELECT ON mysql. * TO 'my-user' @ 'localhost'; with a successful message returned to plesk to find out if I can manage sql with "my user" and not, it is still not enough for accessible users, but the name is still saved ... tried to run: mysql_fix_privilege_tables -user = root -password = mypasswordobviosuly -verbose but also gave an error, and I'm still not sure how to run direct mysql commands without using ssh (because I don't know the root password)

Answer 1

When trying to update, the following was detected. Was directed to the following page: http://kb.parallels.com/en/112290

I ran the following from this page:

"Run the following command to restore the MySQL table:
    #mysql_upgrade -T --debug-check -u admin -p`cat / etc / psa / .psa.shadow` mysql"

Answer 2

mysql phpmyadmin "root", : ( plesk) home- > → webadmin. "mysql", "" (, mysql), : "SQL" "phpmyadmin" sql:

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';

, , ... plesk ! ! , , , mysql, .

Answer 3

MySQL, mysql . ...

mysql_install_db --user=mysql

bash ( MySQL) .

...

mysql_secure_installation

root, , root .

Linux, Windows, MySQL .

Plesk , , MySQL, , - .

Answer 4

, mysql. SELECT :

GRANT SELECT ON mysql.* TO 'your-user'@'localhost';

Answer 5

show tables mysql servers, Error Table 'mysql.servers' does not exist.

<data-dir>/mysql , servers.frm , servers.MYI servers.MYD - , !

, , Daisy Chain Replication, servers.frm , @timo-huovinen, .

It should be noted that at least one table ( plugin) was missing files MYIand MYD.