About database or database table to be used

[satimis]

Hi folks,


Previously I ran;

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

Now I want to change its password with:

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;

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

If;

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

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

[marpada]

In mysql database (that's the system database).

Don't confuse the database passwords with the password of mail users
________
Anal blonde
________
No2 Vaporizer

[satimis]

Originally Posted by marpada

In mysql database (that's the system database).

Don't confuse the database passwords with the password of mail users

Hi marpada,


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


satimis

[marpada]

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

or

mysql> USE mysql;
mysql> SET PASSWORD FOR 'mail_admin'@'localhost' = PASSWORD('newpassword');

and last

mysql> FLUSH PRIVILEGES;
________
Fix ps3
________
Lovely Wendie99

[satimis]

Originally Posted by marpada

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

or

mysql> USE mysql;
mysql> SET PASSWORD FOR 'mail_admin'@'localhost' = PASSWORD('newpassword');

and last

mysql> FLUSH PRIVILEGES;

Hi marpada,


I got password changed. Thanks


B.R.
satimis