unable to start MySQL
Hi,
I have just installed, PHP, Apache, on my WinXP Pro machine. I then went to install MySQL 4.1.7, which appeared to go well...Apart from when I got to execute, and the services wouldn't start...so looking on this forum I followed someone’s solution. I re installed...services started when i selected execute...
But when I went into MySQL folder and opened up winmysqladmin, right clicked on the traffic light in my toolbar, the light was red, and selected start NT, and start services...the response I got was unable to start try again in 30 seconds...
I then went back to reconfigure, and once again i got to execute, and services wouldn’t start...
Don’t know if this has anything to do with it, but in the books and help pages I have got, they all mention a log on page, to enter username and password, I have not seen this.
Can anyone help? I am very confused by all this; I just want to learn PHP for some database web design....
Wood1e
Mark Hensler posted this at 21:58 — 17th November 2004.
He has: 4,048 posts
Joined: Aug 2000
I've never run MySQL on a windows box, so I don't expect to be much help troubleshooting "services". But there should be a mysql log file somewhere that would contain error messages. If you can find that, copy & paste the last few lines here.
Mark Hensler
If there is no answer on Google, then there is no question.
Busy posted this at 22:36 — 17th November 2004.
He has: 6,151 posts
Joined: May 2001
try mysqld-nt.exe should be in your mysql/bin folder
Thats what I use on winxp pro but I'm still running mysql 4.0
Abhishek Reddy posted this at 05:49 — 18th November 2004.
He has: 3,348 posts
Joined: Jul 2001
\data\mysql.err
Should be other logs in that directory too.
wood1e posted this at 08:44 — 18th November 2004.
They have: 2 posts
Joined: Nov 2004
Hi,
Many thanks for that, I have pasted the error files below...
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.7-nt' socket: '' port: 3306 Source distribution
041116 18:55:35 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal shutdown
041116 18:55:36 InnoDB: Starting shutdown...
041116 18:55:41 InnoDB: Shutdown completed; log sequence number 0 43634
041116 18:55:41 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown complete
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.7-nt' socket: '' port: 3306 Source distribution
C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections.
Version: '4.1.7-nt' socket: '' port: 3306 Source distribution
Wood1e
Mark Hensler posted this at 06:21 — 20th November 2004.
He has: 4,048 posts
Joined: Aug 2000
That looks like a normal shutdown to me (not caused by error).
Just a thought... CTRL+ALT+DEL and tab to processes. Start mysqld, and make sure that it starts and stays running. Then try to access it. Does it disappear then?
(btw, he's using mysql 4 too)
Mark Hensler
If there is no answer on Google, then there is no question.
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.