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" <sjm...@pobox.com>
To: <mysql@lists.mysql.com>
Sent: Sunday, May 10, 2009 5:20 AM
Subject: Re: Still going in cicrles
compu...@videotron.ca (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=compu...@videotron.ca
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org