Databases :: MySql :: Mysql as a service |
|||
| By: Squibi |
Date: 08/01/2003 00:00:00 |
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 | 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 | Type : Comment |
|
| yes, may-be the "mysqld" service/daemon wasn't running |
|||
| By: Squibi | Date: 09/01/2003 21:36:00 | 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 | 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 |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!








