mysql refuses to launch

[pafLaXe]

hello

i run a fesora core 3 system on a t-bird based box.

i have allready installed and used mysql on FC2 and 3, but i needed to reinstall the whole system a couple of days ago, and then, impossible to launch mysql.

when i start it with :

# /etc/init.d/mysql start

i get in the error log :

050204 13:59:29 mysqld started
050204 13:59:29 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
050204 13:59:29 InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 0 43634.
InnoDB: Doing recovery: scanned up to log sequence number 0 43634
050204 13:59:29 InnoDB: Flushing modified pages from the buffer pool...
050204 13:59:29 InnoDB: Started; log sequence number 0 43634
050204 13:59:29 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
050204 13:59:29 mysqld ended

It is MySQL v4.19 RPM package from mysql.com, but i also tried 3.23 RPM that comes with fedora distribution with approx the same result...

I searched the doc and other forums, without finding anything interesting...

please help me i really need it !

thx !

vince

[strasm]

So, when you installed FC3 you didnt just let anaconda install it? have you tried going to add new programs?

I am not an expert at FC3, but i recently installed it and had some issues with mysql. Here are some of the steps you have to take:

this will set up mysql with your root password
# mysqladmin -u root password 'yourpassword'

FC3 is by deafault using SELinux so you either have disable SELinux in /etc/selinux/config or run it as 'targeted' you can do that thru the gui. You will need to make it so that the selinux policies do not restrict httpd or mysqld.

Let me know if any of this is helpful.

[pafLaXe]

Hi,

No I didnt let Anaconda install the 3.23 MySQL version bundled with FC3 since I use some SQL syntax introduced in 4.0... I dont understant why it doesn't work now since I used it with no problem on FC2 and my previous and not updated version of FC3...

I just cant use mysqladmin since the server cant start...

I'm going to try and disable SELinux (i don't really need it on my dev box anyway).

Thx for your help.

vince

[pafLaXe]

ok, i set SELinux policy to targeted and checked the 'disable selinux for mysqld box'

the server is up now... thx for your help