Koozali.org: home of the SME Server

Legacy Forums => General Discussion (Legacy) => Topic started by: g00s3m4n on January 26, 2005, 03:04:13 PM

Title: Mysql update
Post by: g00s3m4n on January 26, 2005, 03:04:13 PM

Hello,

i upgraded mysql on my box to 4.0.23 (not the latest, i know). everything seems to work on, except that i am not able to run the /usr/bin/mysql_fix_privilege_tables script. here is what happens:

[root@skit root]# /usr/bin/mysql_fix_privilege_tables
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: NO)

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: NO)

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: NO)

Adding columns needed by GRANT .. REQUIRE (openssl)
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

Creating the new table and column privilege tables
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
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: NO)

Fixing the func table
You can ignore any Duplicate column errors
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

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: NO)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)

if i use /usr/bin/mysql_fix_privilege_tables password
with password being my actual root password it does the same thing.

does anyone have any suggestions?

thanks

g

Title: Mysql update
Post by: Normando on January 26, 2005, 04:48:27 PM

try this commands first:

/etc/rc.d/init.d/mysqld stop

/etc/e-smith/events/actions/conf-mysql-password

/etc/rc.d/init.d/mysqld start

Title: Mysql update
Post by: g00s3m4n on January 27, 2005, 09:29:03 AM

hello,

thanks for the reply, it does not seem to work. i am able to get into phpmyadmin without any problem, except that i get a message "Warning: Your privilege table structure seem to be older than this MySQL version! Please run the script mysql_fix_privilege_tables that should be included in your MySQL server distribution to solve this problem!"

here is a test i did:

[root@skit root]# mysqladmin -u root -pmypassword ver
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'

anyone have any suggestions?