[youssefbasha]

Hello guys,
I got a small problem.
Yesterday i got whmcs and wanted to install it on a shared hosting but i want to use my server as MySQL (External Connection)
I installed phpMyAdmin and added the right info in the WHMCS but it says "Can't connect to the server" and i also tried to connect with terminal and it didn't work so i think it's something in MySQL

Terminal

[root@server ~]# mysql -u whmcsuser -p -h myserverip
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'myserverip' (111)
[root@server ~]#

So can anyone help me with this?
PS: Thats not my p4v vps thats why i didn't post it in vps support

[humanpuff69]

make sure the mysql port isnt blocked or invalid and you turn on the mysql remote . on default mysql deny remote access for security purposes

but if the phpmyadmin that is local cannot connect to it make sure the mysql server is running . you can check it with "service mysql status" command

[Mashiro]

In addition that what @humanpuff69 already mentioned: are the users on your MySQL servers allowed to even use/peform a remote MySQL login?

In order for MySQL remote server to work there are quite some things that need to be configured and that includes also to properly setup user permission to login remotely from different machines when the MySQL remote server feature has been enabled and configured properly.

[Pacific Spirit]

On our server can't Mysql to be used external, as that you use our services.

[chanalku91]

You should look for a shared hosting provider that allows you to remote databases connection like Jagoan Hosting!
Or you can use your VPS as your MySQL Server but with the lack of a very long time Query makes web pages load slowly!

[youssefbasha]

@chanalku91
There is remote host in the panel but it's not working so I want to connect it externally, tell me how

[chanalku91]

@chanalku91
There is remote host in the panel but it's not working so I want to connect it externally, tell me how

I say again, the shared hosting that you use must supports Remote MySQL!

You must add your computer's IP to the Access List so you can access the MySQL Server!
And make sure the server also opens the MySQL Server port!

[youssefbasha]

Believe me, i already tried this way and it didn't work.
Idk about the MySQL port maybe @Pacific Spirit knows

[fChk]

Believe me, i already tried this way and it didn't work.
Idk about the MySQL port maybe @Pacific Spirit knows

@Pacific Spirit already told you that the port is closed on the public IP (see Post 4,)  which is the standard rule. Only few hosting services allow that feature with the precaution of whitelisting the IP from which the SQL queries will originate.

[youssefbasha]

Okay, thanks.
Any admin can close this topic @deanhills @Dynamo