Can't connect to MySQL

[croivo]

I followed the tutorial on this link (http://lessons.runrev.com/m/4071/l/7003 ... l-database) but always get this error:

error.png (5.43 KiB) Viewed 5542 times

My server uses Cpanel version 11.52.0 (build 9) and MySQL version 5.5.45-cll-lve

[tomyeto]

If your database is hosted on webhosting, please make sure you allow remote access using your IP address.

[croivo]

Yes, I added "%" host to access the database... Still not working.

[ghettocottage]

Try adding your IP address

[SparkOut]

It may well be that whatever you set up in cPanel the ISP will block traffic direct to those ports. See what your ISP support/FAQ have to say.

[croivo]

I contacted my hosting support... and they told me to use "SSH Tunnel". Any example of how to use that tunnel in Livecode?

[ghettocottage]

what OS are you using? An SSH tunnel from a mac or linux is fairly simple,and I have even wrote a little script that can be launched from LC that creates a tunnel
.. from Windows you would (I seem to recall) use a little free application called Putty.

It is also possible to use a different method of connecting to your database where you send requests to a middle-man like LiveCode Server or PHP.

Someone wrote a blog-post about doing that:
http://learninglivecode.blogspot.com/20 ... eware.html

[croivo]

I'm on Windows...

That 'middle-man' idea sounds great... I'm gonna try that.

Tnx to all