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
Can't connect to my mySQL server
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Can't connect to my mySQL server
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
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