use mysql
UPDATE user SET Password = PASSWORD('password') WHERE User = 'username'
then reload MySQL
or
mysqladmin flush-privileges
OR
mysqladmin reload
afterward to tell the server to reload the grant tables.
----- Original Message -----
From: "PJN" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 1:44 AM
Subject: [LIH] MySQL password changing
I have a database on a mysql server. I would like to change the access
password. This is for a normal user, not for the mysqladmin. All the
documentation I have found refers only to changing the mysql admin's
password. If there is any way to get this done, could someone please help me
out?
I have already tried this option:
mysql> set password for db_userid=password('new_password');
but the changes do not seem to take effect.
Thanks in advance.
PJN
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
