Can't connect to my mySQL server

Creating desktop or client-server database solutions?

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
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. ... l-database

VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 927
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.

-on your server : you need to allow MySQL login to be "remote" : ... 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)

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

Post Reply

Return to “Databases”