Visual Studio and PhpMyAdmin on Directadmin not working

F

Forcalon

New member
Joined
Oct 11, 2015
Messages
1
Hi! I'm currently done with a program to upload data to my database on directadmin, it works like a charm with xampp. But now when i'm trying to connect it to my database on directadmin it just shows "Failed to connect to any of the mysql hosts". It's weird because i added % to directadmin hosts so all ip's should be able to connect to it. My php site can interact with the database. So please can anyone help me? I'm using the usual "server=***.***.***.***;Password=****;Database=****;" Even tried adding port=3306.
 
Hi Forcalon,

Did you open the port 3306 in your server firewall.
Can you check if you can connect by using the MySQL Manager from the MySQL website.

With kind regards,

Robin
 
Hello Forcalon,

Go to your DA account under "MySQL Management", select your database (From column "Database name") you want to connect to and add to "Access Hosts" your IP.
Check your IP for example here www(dot)whatismyip(dot)com
 
You must log in or register to reply here.
Back
Top