[clug] Fedora 11 problem: mysql
eyal at eyal.emu.id.au
Mon Aug 10 06:18:25 MDT 2009
Bringing closure to this thread: I physically deleted the mysql/mysql
directory and then started the server. It recreated the directory and
I proceeded to add a password as recommended.
I then copied over the mysql/mythconverg directory (with the server
down). Created the necessary user:
> CREATE USER 'mythtv'@'%' IDENTIFIED BY '********';
> GRANT ALL PRIVILEGES ON mythconverg to 'mythtv'@'%';
Started mythtv and it had issues with some rows and I had to do some
> use mythconverg
> delete from recordedseek where mark = -1;
Then all was well. My mythtv is now commissioned on this new server and
it mostly works (mythweb does not show any recorded programs but mythtv
Eyal Lebedinsky wrote:
> I upgraded an f10 system to f11 and mysql will not start now (there are
> other problems too).
> The log shows:
> 090613 16:03:43 mysqld_safe Starting mysqld daemon with databases from
> /usr/libexec/mysqld: Table 'mysql.plugin' doesn't exist
> 090613 16:03:44 [ERROR] Can't open the mysql.plugin table. Please run
> mysql_upgrade to create it.
> 090613 16:03:44 InnoDB: Started; log sequence number 0 54148
> 090613 16:03:44 [ERROR] Fatal error: Can't open and lock privilege
> tables: Incorrect key file for table 'host'; try to repair it
> 090613 16:03:44 mysqld_safe mysqld from pid file
> /var/run/mysqld/mysqld.pid ended
> Running mysql_fix_privilege_tables (or any other utility) fails as there
> is no server
> to connect to.
> Luckily this system is not yet commissioned but any help appreciated.
Eyal Lebedinsky (eyal at eyal.emu.id.au)
More information about the linux