From: michel Date: May 10 2009 11:21am Subject: Re: Still going in cicrles List-Archive: http://lists.mysql.com/mysql/217476 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset=iso-8859-1; reply-type=original Content-Transfer-Encoding: 7BIT 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" To: 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=compukat@stripped >