Simon,
I might have it fixed! I tried /home/qsys/mysql-5.1.32/libexec/mysqld and I
would get
/home/qsys/mysql-5.1.32/libexec/mysqld: Table 'mysql.plugin' doesn't exist
090510 0:19:54 [ERROR] Can't open the mysql.plugin table. Please run
mysql_upgrade to create it.
090510 0:19:54 [ERROR] Fatal error: Can't open and lock privilege tables:
Table 'mysql.host' doesn't exist
From reading around I tried running
/home/qsys/mysql-5.1.32/bin/mysql_install_db
/home/qsys/mysql-5.1.32/libexec/mysqld
and now I get
090510 0:32:38 [Note] Event Scheduler: Loaded 0 events
090510 0:32:38 [Note] /home/qsys/mysql-5.1.32/libexec/mysqld: ready for
connections.
Version: '5.1.32' socket: '/home/qsys/mysql-5.1.32/mysql.sock' port: 3305
Source distribution
I would suggest that the developers team might change the error messages
----- Original Message -----
From: "Simon J Mudd" <sjmudd@stripped>
To: <mysql@stripped>
Sent: Sunday, May 10, 2009 5:20 AM
Subject: Re: Still going in cicrles
> compukat@stripped (michel) writes:
>
>> I set up MySQL and when I try to start it it fails telling me that I
>> need to run 'mysql_upgrade'.
>
> Show us the full error output and provide information on the version
> of MySQL you are using.
>
>> When I run 'mysql_upgrade' it runs
>> 'mysqlcheck' which is supposed to only be run when the server works
>> ...
>
> No, mysql_upgrade does call mysqlcheck to see if things need
> adjusting. Look at the documentation
> http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html
>
> Look at http://dev.mysql.com/doc/refman/5.1/en/upgrade.html which
> gives information on upgrading MySQL. However be careful as IMO this
> documentation can be a bit confusing and is incomplete. Nevertheless
> it's a good starting point.
>
> If however you don't think you are upgrading then you need to provide
> more information on how you are installing MySQL so we can determine
> why MySQL thinks that it needs to do an upgrade. My guess would be
> that you have multiple mysql binaries on your server and are not
> running the version you expect.
>
> Simon
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
