• The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.

Cannot add user to the database

W

wer0ckz

Guest
Hi guys. I'm trying to add a user to a specific database but i got an error mesasge:

Error: Connection to the database server has failed:

Table 'mysql.servers' doesn't exist

See screenshot: http://postimage.org/image/gjt1kzidp/

Any suggestions?

Thanks in advanced
 
Usually after the upgrade there errors that arise with MySQL in Plesk while creating users, errors such as "Table 'mysql.servers' doesn't exist" to solve do the following:

mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql

Then RUN the following:

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

That is all for now ...
 
Back
Top