visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
315 experts, 1193 registered users, 1659 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


05/10/2011 1h30 : Steve Jobs is dead, the father of Apple ][ is gone, we are all orphaned.

Databases :: MySql :: Mysql as a service


By: Squibi U.S.A.  Date: 08/01/2003 00:00:00  English  Points: 300 Status: Answered
Quality : Excellent
I have a bulletin board that uses PHP and Mysql. I've installed Mysql on the server, but when I try to access the bulletin board from a client, I get a database error (could not connect).

If I log in to the server (and remain logged in) and start Mysql from a command line, I can connect from the client, but the minute I log out of the server, I lose the connection.

How do I get round this?

thanks
By: sumotimor Date: 08/01/2003 19:04:00 English  Type : Answer
I assume your running windows. Mysql comes with a built in service installer...

C:\mysql\bin> mysqld-nt --install
- or -
C:\mysql\bin> mysqld --install

Now check the services in control panel, from here you can set it to start automatically.
By: VGR Date: 08/01/2003 19:22:00 English  Type : Comment
yes, may-be the "mysqld" service/daemon wasn't running
By: Squibi Date: 09/01/2003 21:36:00 English  Type : Comment
I successfully added it as a service, but when I tried to start the service it errored out with: 1067, the program terminated unexpectedly.

I looked up this error on the mysql website, and it says this is usually caused by changing the default install directory, but I haven't done this. The program is installed in C:\mysql.


By: VGR Date: 09/01/2003 23:18:00 English  Type : Assist
first check (ps -aux or task manager, Ctrl-Alt-Del on NT) that mysqld is not already running

the winmysqladmin program (delivered with mySql) is perfect for this. You can manipulate the .ini file from there, check the access to databases and tables, get stats and also start/stop/uninstall the service

Do register to be able to answer

EContact
browser fav
page generated in 821.241140 milliseconds

Why Google AdSense ads ?

compteur
 Ranking-Hits PageRank for this page