[clug] Fedora 11 problem: mysql

[Eyal Lebedinsky]

Bringing closure to this thread: I physically deleted the mysql/mysql
directory and then started the server. It recreated the directory and
was happy.

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
mysql cleanup:

 > 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
does).

Thanks everyone
	Eyal

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 
> /var/lib/mysql
> /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)