Linux Help
guides forums blogs
Home Desktops Distributions ISO Images Logos Newbies Reviews Software Support & Resources Linuxhelp Wiki

Welcome Guest ( Log In | Register )



Advanced DNS Management
New ZoneEdit. New Managment.

FREE DNS Is Back

Sign Up Now
 
Reply to this topicStart new topic
> Mysql Privellage, problem after upgrading.
hampeh
post Mar 15 2005, 12:55 AM
Post #1


Whats this Lie-nix Thing?
*

Group: Members
Posts: 2
Joined: 1-March 05
Member No.: 4,715



Hi.

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

Previous setup.

mysql-3.23.58-9.1.i386.rpm
mysql-server-3.23.58-9.1.i386


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.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



RSS Lo-Fi Version Time is now: 23rd October 2017 - 09:25 PM