+- Post4VPS Forum | Free VPS Provider (https://post4vps.com)
+-- Forum: VPS Discussion (https://post4vps.com/Forum-VPS-Discussion)
+--- Forum: VPS Support (https://post4vps.com/Forum-VPS-Support)
+--- Thread: MySQL not connecting? (/Thread-MySQL-not-connecting)
Pages:
1
2
MySQL not connecting? - youssefbasha - 01-11-2020
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
[[email protected] ~]# mysql -u whmcsuser -p -h myserverip
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'myserverip' (111)
[[email protected] ~]#
So can anyone help me with this?Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on 'myserverip' (111)
[[email protected] ~]#
PS: Thats not my p4v vps thats why i didn't post it in vps support
RE: MySQL not connecting? - humanpuff69 - 01-11-2020
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
RE: MySQL not connecting? - Mashiro - 01-11-2020
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.
RE: MySQL not connecting? - Pacific Spirit - 01-11-2020
On our server can't Mysql to be used external, as that you use our services.
RE: MySQL not connecting? - chanalku91 - 01-11-2020
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!
RE: MySQL not connecting? - youssefbasha - 01-11-2020
@chanalku91
There is remote host in the panel but it's not working so I want to connect it externally, tell me how
RE: MySQL not connecting? - chanalku91 - 01-12-2020
(01-11-2020, 08:26 PM)youssefbasha Wrote: @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!
RE: MySQL not connecting? - youssefbasha - 01-12-2020
Believe me, i already tried this way and it didn't work.
Idk about the MySQL port maybe @Pacific Spirit knows
RE: MySQL not connecting? - fChk - 01-12-2020
(01-12-2020, 07:31 AM)youssefbasha Wrote: 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.
RE: MySQL not connecting? - youssefbasha - 01-13-2020
Okay, thanks.
Any admin can close this topic @deanhills @Dynamo