LiveCode Forums.

I always got this error "cannot connect to mysql server on mysql13 . 000webhost . com"
since I use webhost as my database server.

put "mysql13 . 000webhost . com" (*no spaces) into tDatabaseAddress
put "a9416334_pco" into tDatabaseName
put "a9416334_pco" into tDatabaseUser
put "urbandub123" into tDatabasePassword

put revOpenDatabase("mysql", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult

-check if you have a web "control panel" like CPanel for instance

-if yes, then check for "remote MYSQL" : be sure to have your IP address as host, or the wild card "%" (if you want to allow any IP address to connect to your MySQL database)

-if you don't have CPanel, then you need to check the privileges of your user "a9416334_pco" (in MySQL to allow remote connexion, it should be declared like "a9416334_pco@%"
http://stackoverflow.com/questions/1628 ... ote-access

-by the way, your user name and the database name are identical, is it on purpose ?

bangkok wrote:-check if you have a web "control panel" like CPanel for instance

-if yes, then check for "remote MYSQL" : be sure to have your IP address as host, or the wild card "%" (if you want to allow any IP address to connect to your MySQL database)

-if you don't have CPanel, then you need to check the privileges of your user "a9416334_pco" (in MySQL to allow remote connexion, it should be declared like "a9416334_pco@%"
http://stackoverflow.com/questions/1628 ... ote-access

-by the way, your user name and the database name are identical, is it on purpose ?

Thank you for the immediate replay sir.
I use 000webhost.com as hosting for my database and they don't allow remote access connection on databases unless we pay them
http://www.000webhost.com/faq.php?ID=27
About the username and database name, Yes.

markdub wrote: I use 000webhost.com as hosting for my database and they don't allow remote access connection on databases unless we pay them
http://www.000webhost.com/faq.php?ID=27
About the username and database name, Yes.

That's unfortunate... But how can you connect remotely to your database, if... the hosting company prevents this, unless you upgrade your account ?


Or, your first message wasn't very clear, and actually you try to run a LiveCode Server script on 000webhost.com... script that will connect to the local MySQL server ?

bangkok wrote:

markdub wrote: I use 000webhost.com as hosting for my database and they don't allow remote access connection on databases unless we pay them
http://www.000webhost.com/faq.php?ID=27
About the username and database name, Yes.

That's unfortunate... But how can you connect remotely to your database, if... the hosting company prevents this, unless you upgrade your account ?


Or, your first message wasn't very clear, and actually you try to run a LiveCode Server script on 000webhost.com... script that will connect to the local MySQL server ?

The first statement is correct sir.
Yes, they'll allow remote access on database if you'll upgrade your account.
I used only free hosting from 000webhost.
It is script that will directly connect on their mysql server.
sorry for the bad english.
here are the possible solutions
http://www.vampire-tiger.info/livecode- ... bases.html

markdub wrote: It is script that will directly connect on their mysql server.
sorry for the bad english.
here are the possible solutions
http://www.vampire-tiger.info/livecode- ... bases.html

Your LiveCode script was misleading, because it's for direct connections to a MySQL server

Ok, now I understand what you try to.

-you want a local PHP script on 000webhost.com that will process incoming SQL queries, sent by a remote LiveCode application, and forward them to your local MySQL database ( on 000webhost.com too)

-by the way, you should know that you could use LiveCode Server to do the same (instead of PHP), but that's another issue.

So :
-before to do tests with your remote LiveCode app, make sure that your PHP script is working properly.
-is it ? You should post your PHP script so we can have a look