mysql privelege
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 ... |
All times are GMT -5. The time now is 07:15 PM. |