Can't connect to my mySQL server

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
jwtea
Posts: 66
Joined: Fri Mar 23, 2018 2:01 am

Can't connect to my mySQL server

Post by jwtea » Tue Dec 31, 2019 12:09 pm

Hello, i just purchased a shared hosting plan from NameCheap and i'm unable to connect to mySQl server on my livecode.

When i tried to connect the database, the error msg say "Can't connect to mySQL server"
Can i know what is the issue? Is there any setting i had to do on cpanel or the credentials i key in is wrong?

PS: I had created my database in cpanel already.


I referenced the step from the link below to connect to my database.
http://lessons.livecode.com/m/4071/l/70 ... l-database

bangkok
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 862
Joined: Fri Aug 15, 2008 7:15 am

Re: Can't connect to my mySQL server

Post by bangkok » Tue Dec 31, 2019 2:31 pm

Many possible causes, outside Livecode.

MOST LIKELY
-on your server : you need to allow MySQL login to be "remote" :
https://manage.accuwebhosting.com/knowl ... erver.html

Type your fixed IP address (if you have), or use the wildcard % (watch out, if "%" alone it means virtually all IP addresses could connect to your MySQL DB)

OR
-the firewall on your computer (or your company firewall) : you need to open the standard MySQL port = 3306

Post Reply

Return to “Databases”