On Mon, 26 Nov 2001, PJN wrote:
|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.
if you want to create a user(myuser) with permissions to access a
particular database(say mydb) and password "secret"
grant all on mydb.* to myuser identified by "secret" ;
for limiting permissions ... replace "all" with the permissions you want
to give..
read the mysql manual for more detailed information.
Kingsly
_______________________________________________
linux-india-help mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/linux-india-help
