About database or database table to be used

Hi folks,


Previously I ran;

Code:

mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON mail.* TO 'mail_admin'@'localhost' IDENTIFIED BY 'oldpassword';

Now I want to change its password with:

Code:

mysql> UPDATE mail.user SET password=PASSWORD('newpassword') WHERE user="'mail_admin'@'localhost'";

But I can't figure out which database OR database table I have to use.

mysql> SHOW DATABASES;

Code:

+--------------------+
| Database           |
+--------------------+
| information_schema |
| mail               |
| mysql              |
+--------------------+
3 rows in set (0.16 sec)

If;

Code:

mysql> USE mail;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed

Code:

mysql> UPDATE mail.user SET password=PASSWORD('newpassword') WHERE user="'mail_admin'@'localhost'";
ERROR 1146 (42S02): Table 'mail.user' doesn't exist

Error popup. Please help. TIA


B.R.
satimis

 

Hi marpada,


What I need is ONLY to change the password. Nothing else. What shall I do? Thanks


satimis

 

Hi marpada,


I got password changed. Thanks


B.R.
satimis