Remote MySQL Server Doesn't Work

[John Weng]

I have an external MySQL server defined and confirmed that Plesk can successfully communicate with it. DB Webadmin has full access via the Plesk admin interface.

While WordPress installs fine via the local MySQL server, it persistently fails when attempt to use the external MySQL server.

Error: Installation of WordPress at http://eristest2.partners.org/ failed. Non-zero exit status returned by script. Output stream: 'PHP Warning: mysql_connect(): Access denied for user 'eristest2'@'170.223.178.101' (using password: YES) in /usr/local/psa/var/apspackages/apscatalogW7i17t.zipa94a7315-73b7-07/cache/scripts/db-util.php on line 66 '. Error stream: 'PHP Warning: mysql_connect(): Access denied for user 'eristest2'@'170.223.178.101' (using password: YES) in /usr/local/psa/var/apspackages/apscatalogW7i17t.zipa94a7315-73b7-07/cache/scripts/db-util.php on line 66 '.

If I manually create the username and database first, then I'd get the following error

Error: Installation of WordPress at http://eristest2.partners.org/ failed. Database with requested name already exists

Appreciate any insight on this.

Thanks,
John

 

[IgorG]

You shouldn't create database manually there. Just make sure that database user on this remote SQL server has "allow from all hosts" default permission.

 

[John Weng]

The DB user account is allowed from any host, all global privileges. Anything else I should check? Thanks.