mysql hlasi chybu pri spusteni

zdravim. ked spustim mysqld -u root hlasi mi to 060301 22:13:30 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist . Skusal som to na slackware a suse a nic. pripajam log

060301 22:21:50  mysqld started
060301 22:21:50  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...
060301 22:21:50  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
060301 22:21:50  InnoDB: Flushing modified pages from the buffer pool...
060301 22:21:50  InnoDB: Started; log sequence number 0 43634
060301 22:21:50 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist
060301 22:21:50  mysqld ended

neviet co s tym ? dik

Zrovna dneska se mi to stalo taky :) Zapomnel jsem root heslo k databazi, tak jsem smazal celej adresar /var/lib/mysql/mysql a vytvoril znova pomoci mysql_install_db. A hlasilo mi to presne tuhle hlasku...

Smaz (jako root) soubory ve /var/lib/mysql/*. Jsou tam nejaky jako user.err, user.pid, atd... Po spusteni mysqlserveru se to vytvori znova a jede to... Teda alespon u mne to pomohlo ;-)

Dotaz: mysql hlasi chybu pri spusteni - mysql.host

Odpovědi