I am trying to connect to Plesk MySQL server from another server. I am trying to access it using IP address But It always gives the error like.
“Can’t connect to MySQL server on ‘xx.xxx.xxx.xx’ (4)”
Remote access setting of MySQL server are .”Allow remote connections from any host”
3
Answers
Here’s the steps to "Allow remote connections from any host" :
Open a DOS command prompt on the server.
Run the following command from the mysqlbin directory:
{mysql -u root –password=}
A mysql prompt should be displayed.
To create a remote user account with root privileges, run the following commands:
{GRANT ALL PRIVILEGES ON . TO ‘USERNAME’@’IP’ IDENTIFIED BY ‘PASSWORD’;}
‘USERNAME’ is the username to be created.
‘IP’ is the public IP address of the remote connection.
‘PASSWORD’ is the password to be assigned for this username.
(IP can be replaced with % to allow this user to logon from any host or IP)
mysql> FLUSH PRIVILEGES;
mysql> exit;
Edit
/etc/my.cnf
and change to (via ssh):And restart db:
Long story short. You can’t. Your provider does not have that featured enabled. Switch to cPanel providers.