Problems activating your account? Send notification email to: admin@post4vps.com
Host4Fun Budget VPS Hosting

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
MySQL not connecting?
#1
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
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and HostLease for the amazing VPS 18
#2
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
Terminal
humanpuff69@FPAX:~$ Thanks To Shadow Hosting And Post4VPS for VPS 5
#3
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.
#4
On our server can't Mysql to be used external, as that you use our services.
Terminal
HostLease Media Group Netherlands - Leaders In Hosting Service Solutions!


CONTACT US:
Homepage: https://www.hostlease.com
Email: sales@hostlease.com
Phone Number (WhatsApp Free): +31 6 14355166
#5
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!
Running Therapy to restore ability
#6
@chanalku91
There is remote host in the panel but it's not working so I want to connect it externally, tell me how
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and HostLease for the amazing VPS 18
#7
(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!


Attached Files Image(s)
   
Running Therapy to restore ability
#8
Believe me, i already tried this way and it didn't work.
Idk about the MySQL port maybe @Pacific Spirit knows
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and HostLease for the amazing VPS 18
#9
(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.
#10
Okay, thanks.
Any admin can close this topic @deanhills @Dynamo
Gimme +rep Heart
[Image: img.php?userid=496]
Thanks For Post4VPS and HostLease for the amazing VPS 18
 


Possibly Related Threads...
Thread Author Replies Views Last Post
  CyberPanel FTP is not connecting youssefbasha 4 655 06-16-2019, 06:50 PM
Last Post: Hidden Refuge

Forum Jump:


Users browsing this thread: 1 Guest(s)
Hostlease

Sponsors: VirMach - Host4Fun - CubeData - Evolution-Host - HostDare - SSDBlaze - Abc-Hosters - Hyper Expert - Shadow Hosting - Bladenode - Hostlease


About Post4VPS

Post4VPS is a forum/destiny where you can Delploy Your Free VPSs just by the Power of Posts.

We Provide VPSs of many locations like Germany,US,Canada,France,London,etc.

We also Provide VPSs of Both Linux and Windows OS.