Pablo Software Solutions Forum Index Pablo Software Solutions

 
 FAQFAQ   SearchSearch   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

mySQL connect help please

 
Post new topic   Reply to topic    Pablo Software Solutions Forum Index -> Quick 'n Easy Web Server
View previous topic :: View next topic  
Author Message
vega



Joined: 02 Jul 2007
Posts: 2

PostPosted: Mon Jul 02, 2007 3:41 pm    Post subject: mySQL connect help please Reply with quote

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


Last edited by vega on Mon Jul 02, 2007 4:01 pm; edited 2 times in total
Back to top
View user's profile Send private message
admin
Site Admin


Joined: 13 Apr 2005
Posts: 1469

PostPosted: Mon Jul 02, 2007 3:55 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail
vega



Joined: 02 Jul 2007
Posts: 2

PostPosted: Mon Jul 02, 2007 4:55 pm    Post subject: Reply with quote

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

Thanks for your time.

Dan
Back to top
View user's profile Send private message
admin
Site Admin


Joined: 13 Apr 2005
Posts: 1469

PostPosted: Mon Jul 02, 2007 6:43 pm    Post subject: Reply with quote

Ok, thanks for clearing that up!
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Pablo Software Solutions Forum Index -> Quick 'n Easy Web Server All times are GMT + 1 Hour
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


SwiftBlue Theme created by BitByBit
Powered by phpBB © 2001, 2002 phpBB Group