connecting to mysql

Mark Smith Mark_Smith at cpe.umanitoba.ca
Sat Sep 29 10:47:29 EDT 2012


Thanks Mark. I'm new to the server stuff so was not familiar with the
process. LC has a lesson where they suggest you can connect to MySQL
directly on their site (I think) but maybe I am misunderstanding them.

http://lessons.runrev.com/s/lessons/m/4071/l/7003-Connecting-to-a-MySQL-database

Thats where I got the connection scripts from. I downloaded and installed
MySQL from the Oracle site and setup a local server and when I used
localhost as the connection address it worked fine but I'd like to ensure I
understand the process for a remote server as well, and make sure it works
if the port number is non-standard etc. I'm not sure I want to go to the
trouble of setting up my own computer as a server on the internet although I
suppose if there is no other way?

Cheers,

-- Mark


Mark Schonewille-3 wrote
> Hi Mark,
> 
> What made you think that you could use the RunRev server to test your own
> MySQL scripts? Have you got any documentation from RunRev about this?
> 
> Usually, web hosting companies don't allow remote connections. You need a
> script on your server as a layer between LiveCode and MySQL, which is
> usually written in PHP or ASP but could also be a LiveCode server script
> or a CGI script. Such a script handles URL's or web forms, which are sent
> to the server with the POST or GET method. You can connect to it from
> within LiveCode using put/get URL or post to URL commands.
> 
> --
> Best regards,
> 
> Mark Schonewille





--
View this message in context: http://runtime-revolution.278305.n4.nabble.com/connecting-to-mysql-tp4655547p4655551.html
Sent from the Revolution - User mailing list archive at Nabble.com.




More information about the use-livecode mailing list