SitePoint Sponsor |
|
User Tag List
Results 1 to 5 of 5
Thread: Can't connect to localhost
-
Dec 15, 2004, 09:55 #1
- Join Date
- Dec 2004
- Location
- Beside the historic creek in Kingston, London
- Posts
- 128
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Can't connect to localhost
On a new machine, I am trying to get MySql to work.
IIS is up and going, but when I try to get MySql to work its magic it says, in reply to "mysql\bin" then "mysql" Error 2003: Can't connect to MySQL server on 'localhost' (10061).
I've just bought Kevin Yank's gospel and I can't wait to get going ...
-
Dec 15, 2004, 11:49 #2
That is probably because the MySQL server process has not been started.
try typing net.exe start MySQL from a command prompt. That should display some messages indicating that the service is trying to start, and if it starts, then [b]mysql.exe -u root -p[b] should connect.
-
Dec 16, 2004, 03:18 #3
- Join Date
- Dec 2004
- Location
- Beside the historic creek in Kingston, London
- Posts
- 128
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Thanks, swdev. That prompts this message
'system error 5 has occurred. Access is denied.'
Hopefully that reveals something positive...? (Most impressed by your skills, sw. Hope my problem won't seem too puny for you.)
-
Dec 16, 2004, 11:36 #4
Okay, thanks for the praise
This may help
start a command window
goto your SQL installation directory, and then the bin sub-directory
type mysqld.exe
You should see some messages saying that MySQL is starting up, or some error messages.
If all is well, you will not be returned to a command prompt.
start a second command window
goto your SQL installation directory, and then the bin sub-directory
type mysqladmin.exe -u root -p shutdown
This will shutdown the MySQL server
then type mysql.exe --install-manual. This will install MySQL as a service that can then be started by net.exe start MySQL and stopped by net.exe stop MySQL
If you want to name the service something else, say TestServer, then type mysqld.exe --install-manual TestServer.
Hope this helps
-
Jan 19, 2005, 20:21 #5
- Join Date
- Apr 2004
- Location
- The Netherlands
- Posts
- 46
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
thanks, this thread partly helped my problem, I managed to start a second instance of Mysql this way, because the first instance crashed and I can't get it to shutdown, even a reboot won't help.
When I try to start it, it says 'Service already exists' but there is no mysqld in my task manager. Any idea? Reinstalling doesn't quite work.
Bookmarks