Pablo Software Solutions

[vega]

I can't make QnE connect to mySQL interpreter. However, PHP works fine.

I have these 2 lines in the CGI tab of the config:

PHP | C:\xampplite\php\php-cgi.exe (PHP works fine)

MYD | C:\xampplite\mysql\bin\mysql.exe (mySQL does not)

I just want to connect locally (localhost) to test my scripts. No access from the web.

Could anyone please tell me what I am doing wrong with the mySQL line?

Thanks in advance,

Dan

[admin]

I'm not familair with the MYD extension and I don't think you should configure it in the CGI tab. MySQL is a database server and not a script interpreter!

QnE Web Server doesn't need any special configuration for MySQL.
QnE Web Server doesn't directly connect to the MySQL all database queries are handled by through PHP.

So all you will have to do is make sure PHP and the MySQL server are correctly setup.

Here are a few suggestions:
1. Maybe it's a permission issue:
If you are using QnE Web Server the server runs under the logged in user account. If you are using QnE Web Service it runs under the Local System account. In both cases make sure these accounts have access to MySQL.
2. Try to start mysqld-nt with --enable-named-pipe (instead of TCP/IP)

I'm not an expect on MySQL, but since setting up MySQL is not directly related to QnE Web Server I recommend doing a search on Google,to find out what the best configuration for your computer is.

There are lots of tutorials about MySQL available on the Internet.
Once you have PHP and MySQL working it should also work on QnE Web Server.

I usually use the original setup from the MySQL website, which seems to work ok, if you just follow the standard setup.

[vega]

I was not starting the correct service. Sorry about that . It works fine now.

Thanks for your time.

Dan

[admin]

Ok, thanks for clearing that up!