View Single Post
  #1  
Old 21st October 2008, 15:38
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
Default 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
Reply With Quote
Sponsored Links