Apache Friends Support Forum

I cannot get MySQL to start. I have looked at many of the other posts about mysql not starting, and I dont think they are the same as mine. I had Lampp setup and functioning, but after I rebooted and restarted Lampp, mysql will not start. here is the error I get when trying to run it manually

Code: Select all

root@shoegoo:/opt/lampp/sbin# ./mysqld
Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
040112 13:24:29  Aborting
                                                                                                                             
040112 13:24:29  ./mysqld: Shutdown Complete

Thanks in advance.

Dear Shoegoo!

It's not possible to start MySQL the way you tried.

Call

/opt/lampp/lampp startmysql

to start MySQL.

After starting take a look at the end of the .err file in your
/opt/lampp/var/mysql directory. Are there any error messages?

Greetings and good luck
Oswald

Yes there is an error

Code: Select all

root@shoegoo:/opt/lampp/var/mysql# /opt/lampp/lampp startmysql
LAMPP: Starting MySQL...
root@shoegoo:/opt/lampp/var/mysql# tail shoegoo.err
040118 13:17:46  mysqld ended

040118 13:17:59  mysqld started
040118 13:17:59  Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
040118 13:17:59  Aborting

040118 13:17:59  /opt/lampp/sbin/mysqld: Shutdown Complete

040118 13:17:59  mysqld ended

Thanks for the help.

Hi,

your mySQL DBs seem to be damaged....
Looks like you'll have to delete lampp again and reinstall....
Do NOT delete any Databases out of mysql!

And make sure lampp stops, before you shutdown your PC/Server

So long
KriS