List:General Discussion« Previous MessageNext Message »
From:michel Date:May 10 2009 11:21am
Subject:Re: Still going in cicrles
View as plain text  
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
> 

Thread
Still going in cicrlesmichel9 May
  • Re: Still going in cicrlesSimon J Mudd10 May
  • Re: Still going in cicrlesmichel10 May
    • Re: Still going in cicrlesSimon J Mudd10 May
      • RE: Still going in cicrlesMartin Gainty10 May
  • Re: Still going in cicrlesmichel10 May
    • RE: Still going in cicrlesMartin Gainty10 May