[mythtv-users] Trashed MySQL Configuration

[Mache Creeger]

Starting with mythbackend not be able to login to MySQL, I have now 
fiddled with it enough so that it seems that my MySQL installation is 
thoroughly screwed up on my MBE. As a result, my long standing Myth 
installation is done hard and my family is getting grumpy. I have 
tried yum erasing MySQL and reinstalling which as made matters worse. 
I have plenty of database backups.

Starting from square one, this is what I get when I try to start 
MySQL with /etc/rc.d/init.d/mysqld start.

100826 18:20:56 mysqld_safe Starting mysqld daemon with databases 
from /var/lib/mysql
100826 18:20:56 [Warning] option 'net_buffer_length': unsigned value 
8388608 adjusted to 1048576
100826 18:20:56 [Warning] Ignoring user change to 'mysql' because the 
user was set to 'mythtv' earlier on the command line

100826 18:20:56 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
100826 18:20:56 [ERROR] Can't open the mysql.plugin table. Please run 
mysql_upgrade to create it.
100826 18:20:56  InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'open'.
InnoDB: Cannot continue operation.
100826 18:20:56 mysqld_safe mysqld from pid file 
/var/run/mysqld/mysqld.pid ended
100826 18:21:00 mysqld_safe Starting mysqld daemon with databases 
from /var/lib/mysql
100826 18:21:00 [Warning] option 'net_buffer_length': unsigned value 
8388608 adjusted to 1048576
100826 18:21:00 [Warning] Ignoring user change to 'mysql' because the 
user was set to 'mythtv' earlier on the command line

Help!

# /etc/rc.d/init.d/mysqld restart
Stopping MySQL:                                            [FAILED]
MySQL Daemon failed to start.
Starting MySQL:                                            [FAILED]

# uname -r
2.6.32.19-163.fc12.i686

# rpm -qa | grep mythtv-backend
mythtv-backend-0.23.1-236.fc12.i686

# df
Filesystem           1K-blocks      Used Available Use% Mounted on
/dev/sda5             10080488    504364   9064056   6% /
tmpfs                   513508       192    513316   1% /dev/shm
/dev/sda7            446152116 264280104 159208720  63% /home
/dev/sda3             10080520   4925496   4642956  52% /usr
/dev/sda2             10080520   7325876   2242576  77% /var
/dev/sda1               194442     50473    143969  26% /boot
/dev/md0             2930148736 1929106012 1001042724  66% /opt

-- Mache