MySQL Starts/Shuts down.

LPXCasper

I have no clue what this thing is doing. I will click start and it will start. However, approximately 20 seconds later, it will shut itself off. I am a begginner in PHP as well as MySQL. I need desperate help...please reply!!! 😕

nnichols

Assuming you are running the MySQL server on your local windows machine.

Open the error log file and see what it says. If you installed in "C:\mysql\" the error log should be "C:\mysql\data\mysql.err", have a look and see what it says.

LPXCasper

This is what I get when I check the error:

030302 15:22:29 InnoDB: Started
030302 15:22:29 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
030302 15:22:29 Aborting

030302 15:22:29 InnoDB: Starting shutdown...
030302 15:22:31 InnoDB: Shutdown completed
030302 15:22:31 MySql: Shutdown Complete

Any Ideas?😕

nnichols

What OS are you running?
Have you had the server running successfully before or have you just installed it??

LPXCasper

I am currently running Windows XP home edition, and to your other question...yes, I have had it up and running...but if I were to restart, this would happen, and for some reason that FATAL ERROR shocks me....

nnichols

So it runs fine when first started, but if restarted for some reason it does this??

LPXCasper

Yea, it works fine until I restart my computer. Then if I look in the error log I get this:

Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist

nnichols

Which executable are you running and are you running it as an NT service.

This problem is being caused by the server not being shutdown properly when you restart your computer.

LPXCasper

Originally posted by nnichols
Which executable are you running and are you running it as an NT service.

I am running "winmysqladmin.exe". And it is running as: Server=C:/mysql/bin/mysqld-nt.exe

nnichols

You must make sure you shutdown mysql before you restart/shutdown your computer then it will be ok.

Personally I would stop using "winmysqladmin.exe" and run the mysql server as a service. Then XP will start and shut it down for you.

LPXCasper

How do I run it as a service???

nnichols

Give me five minutes and I will post a zipped reg hack which should setup the service for you.

LPXCasper

ok thank you 😛

nnichols

I have attached a file called mysql.txt. You need to change the file extension to .reg and then double-click it to make the reg entry.

I suggest you take a backup of your registry first - just in case.

Then go to "Start -> Control Panel -> Administrative Tools -> Services" and make sure that there is a mysql entry in the list of services. You might need to right click on the entry and set "Startup type:" to "automatic".

Let me know how you get on.

LPXCasper

Great help! Thanks alot~!

nnichols

Is it working ok??