I have a website which is hosted on cpanel, and uses and external mysql server.
When the script tries to connect to the external server, following error is generated:
ERROR 1045 (28000): Access denied for user
Same error is shown when I connect to external db from shell, from the server having the website and cpanel.
However, I am able to connect to the external DB from a third server using shell. It means something on the cpanel server stops external mysql connctions.
May I know how to solve this?
PS: This is not "allowing remote connections for mysql database on cpanel server", but opposite of it.
When the script tries to connect to the external server, following error is generated:
ERROR 1045 (28000): Access denied for user
Same error is shown when I connect to external db from shell, from the server having the website and cpanel.
However, I am able to connect to the external DB from a third server using shell. It means something on the cpanel server stops external mysql connctions.
May I know how to solve this?
PS: This is not "allowing remote connections for mysql database on cpanel server", but opposite of it.