[Resolved] DB Migration?

4rxsid

Hi all,

I've got MySQL 4.0.18 running fine on an old NT 4.0 server and using phpMyAdmin 2.6.0-pl2 to admin the db via a browser. In my config.inc.php for phpMyAdmin, I have two different ID's and password's I use (only 1 at a time though, the other commented out). One ID that has full root access to all db's, including the mysql.user table and the other ID that is normally in play, that has restricted access.

I'm attempting to move to a newer server but I'm having difficulty getting phpMyAdmin to work w/o disabling the Grant table (via the MySQL Administrator GUI from mysql.com). If I disable the Grant table, of course now my browser session has full access to the mysql.user table to which I'm trying to secure my two different user id's and passwords. Here's my set up:

windows 2003 server.
apache 2.0.52
php 4.3.10
mysql 4.1.9
phpmyadmin 2.6.1

with the grant table disabled, i go into the phpmyadmin tool and select from the users table. i'm trying to enter a password for my root user and other user id's but when i enter it as PASSWORD type, it returns a 40 varchar value. when i turn grant tables back on, i can't get into phpmyadmin, says:

#1251 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

why wouldn't that work since the password for root in the config.inc.php for phpMyAdmin is identicle (plain text anyway) to that which i try to set via the phpmyadmin w/grant disabled?

Sorry for the long note, just wanted to try and anticipate what info may be needed.

Thanks,
Gary

4rxsid

does it have to do with MySQL 4.1 hashing?

4rxsid

ok...resolved. it is the 4.1+ hashing of MySQL passwords. here's the fix:

MySQL changed the password hashing functions in version 4. There are two easy solutions.

Either - start the server with the --old-passwords flag.

Or: update the users password using:
SET PASSWORD = OLD_PASSWORD('secret');
SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');

i choose the later...and it works like a charm. phpMyAdmin is now able to connect to the db.