Hi.

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

Previous setup.

mysql-3.23.58-9.1
mysql-server-3.23.58-9.1

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

done

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.

have you tried doing this in command line, using GRANT?
i don't know what kind of privledges you are trying to give
to this new user, so i won't include an example ..
but maybe if you do it manually and see that it may work then
you may be looking at a problem with phpmyadmin..

the wording of your statements is kinda throwing me off at some
points, so i don't know if you are actually saying your thinking
this is an issue with phpmyadmin, or mysql ...
so thats what my answer to you is based on ...