I've just upgrade mysql server/client on my linux machine.

Previous setup.


current setup.
[root@hostname bin]# mysql -V
mysql Ver 14.7 Distrib 4.1.10a, for pc-linux-gnu (i686)

I have run the mysql_fix_privilege_tables without any problems.

[root@hostname bin]# ./mysql_fix_privilege_tables --user=root --password=xxxxxx
This script updates all the mysql privilege tables to be usable by
MySQL 4.0 and above.

This is needed if you want to use the new GRANT functions,
CREATE AGGREGATE FUNCTION, or the more secure passwords in 4.1


And then i restarted the mysql server.

My problem now is when i add a new user through phpmyadmin, it will says that the username/password incorrect... but then the old user before i upgrade to the new mysql version still can login to the phpmyadmin.

btw, im using fedora core2, with php-4.3.10-2.4.

Anyone have any idea how to fix this..

Your help is appreciated.