MySQL with EasyPHP

[clydesider31]

Good evening

I teach Computing Science in secondary school and I'm trying to create a series of practical tasks for senior pupils. They have already created a MySQL database using EasyPHP and used this successfully to create a database-driven website (due to restrictions on the school network, the pupils run EasyPHP from USB pen drives). I now want them to access the same database from a Livecode program.

I am working with databases and Livecode for the first time and I've encountered problems trying to connect to the database using the following code:


put "localhost" into databaseAddress
put "testDB" into databaseName
put "root" into databaseUser
put "root" into databasePassword

put revOpenDatabase("MySQL", databaseAddress, databaseName, databaseUser, databasePassword) into connect

if connect is a number then
put connect into linkID
answer info "Connected to the database." & cr & "Connection ID = " & linkID
else
put empty into linkID
answer error "Unable to connect to the database:" & cr & connect
end if


This generates the error "Can't connect to MySQL server on localhost(0)". I suspect the issue is that I've not used the full path name of the database but I'm not sure what that is.

I found an earlier post with a similar problem 'MySQL + Localhost using MAMP'. The solution makes use of all 6 parameters associated with the revOpenDatabase function
get revOpenDatabase("mysql", "localhost", "testdb", "root", "root",false,"/Applications/MAMP/tmp/mysql/mysql.sock"

The school PCs run Windows 7 so I'm guessing that the pathname would be something like: "E:/EasyPHP/EasyPHP-DevServer-14.1VC9/binaries/mysql/data/testdb"

However, when I try using this pathname, I still generate the same error message as before.

Any help would be very much appreciated. Many thanks in anticipation.

[AxWald]

Hi,

not sure if I can help, but I may be able to give some hints:

1.) The second parameter in revOpenDatabase("mysql", ...) is the URL ("mySite.com"). If "localhost" doesn't work you might try the equivalent "127.0.0.1". Maybe add a port: "127.0.0.1:3306"
If this doesn't work, try the real IP of the machine (or the real URL).

2.) When using paths on windows and having problems, always additionally try the backslash variant: "C:\aFolder\aFile.txt" instead of "C:/aFolder/aFile.txt" ...
I don't have a local MySQL here, but when connecting to a local SQLite I use this variant.
But as far as I see in the doku there's no need for a path anyways.

3.) Make sure MySQL allows connections other but from PhP! This is often disabled for security reasons.

Hope this helps! Have fun!

[clydesider31]

Many thanks for your prompt reply.

Replacing 'localhost' with '127.0.0.1' is indeed the solution. I only wish I had thought of that myself - seems so obvious now!