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.

    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?😕

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

        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....

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

            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

              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.

                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

                  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.

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

                      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.

                        Write a Reply...