MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:May 25 2003 1:31am
Subject:Re: Upgrade troubles
View as plain text  
Scott-
check your user grants in the db mysql, table users
Hth,
Martin
----- Original Message -----
From: "Scott Haneda" <lists@stripped>
To: "MySql" <mysql@stripped>
Sent: Saturday, May 24, 2003 7:32 PM
Subject: Upgrade troubles


> mysql_fix_privilege_tables -uroot -pmypassword
> This scripts updates the mysql.user, mysql.db, mysql.host and the
> mysql.func tables to MySQL 3.22.14 and above.
>
> This is needed if you want to use the new GRANT functions,
> CREATE AGGREGATE FUNCTION or want to use the more secure passwords in 3.23
>
> If you get 'Access denied' errors, you should run this script again
> and give the MySQL root user password as an argument!
> Converting all privilege tables to MyISAM format
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> If your tables are already up to date or partially up to date you will
> get some warnings about 'Duplicated column name'. You can safely ignore
> these!
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> Creating Grant Alter and Index privileges if they don't exists
> You can ignore any Duplicate column errors
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> Adding columns needed by GRANT .. REQUIRE (openssl)
> You can ignore any Duplicate column errors
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> Creating the new table and column privilege tables
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
> Changing name of columns_priv.Type -> columns_priv.Column_priv
> You can ignore any Unknown column errors from this
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> Fixing the func table
> You can ignore any Duplicate column errors
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
>
> Adding new fields used by MySQL 4.0.2 to the privilege tables
> You can ignore any Duplicate column errors
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
> ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)
> [mp3:local/mysql/bin] root#
>
> -------------------------------------------------------------
> Scott Haneda                                Tel: 415.898.2602
> http://www.newgeo.com                       Fax: 313.557.5052
> scott@stripped                            Novato, CA U.S.A.
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>
Thread
foreign key help neededCato Liberty24 May
  • Upgrade troublesScott Haneda25 May
    • Re: Upgrade troublesMartin Gainty25 May
      • Re: Upgrade troublesScott Haneda25 May
      • create table question....Bruce Douglas25 May
        • RE: create table question....Bruce Douglas25 May
Re: foreign key help neededHeikki Tuuri25 May