What database table shall I use

satimis · #1 (**permalink**) 10-21-08, 09:30

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.

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

healdem · #2 (**permalink**) 10-21-08, 09:44

if you are struggling setting permissions then Id suggest you try the MySQL adminisrator availbale form the MySQL website as part of the GUI Tools

satimis · #3 (**permalink**) 10-21-08, 10:25

Quote:

Originally Posted by healdem

if you are struggling setting permissions then Id suggest you try the MySQL adminisrator availbale form the MySQL website as part of the GUI Tools

Hi healdem,

What I need is to change password, nothing else.

B.R.
satimis

healdem · #4 (**permalink**) 10-21-08, 11:24

Quote:

Originally Posted by satimis

Hi healdem,

What I need is to change password, nothing else.

B.R.
satimis

ok
if you are struggling to set passwords and or permissions then Id suggest you try the MySQL adminisrator availbale form the MySQL website as part of the GUI Tools

satimis · #5 (**permalink**) 11-01-08, 10:05

Quote:

Originally Posted by healdem

ok
if you are struggling to set passwords and or permissions then Id suggest you try the MySQL adminisrator availbale form the MySQL website as part of the GUI Tools

Noted with thanks

satimis

Internet Services

Web Development

Digital Marketing

Consumer Tech