Re: mysqld won't start

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Dave Stevens wrote:
Hi,

I have mysql installed in my F7 x86-64 system. When I try to use the System | Administration | Server Settings and highlight mysqld and click on start I get a delay and

<snip>
080131 16:25:56  InnoDB: Started; log sequence number 0 43655
080131 16:25:56 [ERROR] Fatal error: Can't open and lock privilege tables: Table
 'mysql.host' doesn't exist

This means that mysql cannot find privilege information.
Might be caused due to corrupt mysql databases or worst case, someone deleted/dropped the database "mysql" (the directory /var/lib/mysql/mysql).

One way would be to backup the current mysql databse, if it exists (use mysqldump). Then run the script /usr/bin/mysql_install_db. This will create a default privilege table.

One more thing that can be done is to try and run myisamcheck on all the files in /var/lib/mysql/mysql/*MYD files and see what it says. If there is no tables_priv.MYD then depending on how customized this server was, you could be in serious trouble. You will have to try the above procedure and then grant the necessary privileges that are not currently in the table.


--Saurabh

--
fedora-list mailing list
fedora-list@xxxxxxxxxx
To unsubscribe: https://www.redhat.com/mailman/listinfo/fedora-list
[Index of Archives]     [Older Fedora Users]     [Fedora Announce]     [Fedora Package Announce]     [EPEL Announce]     [Fedora Magazine]     [Fedora News]     [Fedora Summer Coding]     [Fedora Laptop]     [Fedora Cloud]     [Fedora Advisory Board]     [Fedora Education]     [Fedora Security]     [Fedora Scitech]     [Fedora Robotics]     [Fedora Maintainers]     [Fedora Infrastructure]     [Fedora Websites]     [Anaconda Devel]     [Fedora Devel Java]     [Fedora Legacy]     [Fedora Desktop]     [Fedora Fonts]     [ATA RAID]     [Fedora Marketing]     [Fedora Management Tools]     [Fedora Mentors]     [SSH]     [Fedora Package Review]     [Fedora R Devel]     [Fedora PHP Devel]     [Kickstart]     [Fedora Music]     [Fedora Packaging]     [Centos]     [Fedora SELinux]     [Fedora Legal]     [Fedora Kernel]     [Fedora OCaml]     [Coolkey]     [Virtualization Tools]     [ET Management Tools]     [Yum Users]     [Tux]     [Yosemite News]     [Gnome Users]     [KDE Users]     [Fedora Art]     [Fedora Docs]     [Asterisk PBX]     [Fedora Sparc]     [Fedora Universal Network Connector]     [Libvirt Users]     [Fedora ARM]

  Powered by Linux