LiveCode Forums

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

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