Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 21st October 2008, 16:01
marpada marpada is offline
Senior Member
 
Join Date: Sep 2008
Posts: 139
Thanks: 2
Thanked 14 Times in 14 Posts
Default

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

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

Last edited by marpada; 13th May 2011 at 01:49.
Reply With Quote
  #3  
Old 21st October 2008, 16:27
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
Default

Quote:
Originally Posted by marpada View Post
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
Reply With Quote
  #4  
Old 21st October 2008, 16:38
marpada marpada is offline
Senior Member
 
Join Date: Sep 2008
Posts: 139
Thanks: 2
Thanked 14 Times in 14 Posts
Default

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

Last edited by marpada; 13th May 2011 at 01:50.
Reply With Quote
  #5  
Old 21st October 2008, 18:02
satimis satimis is offline
Senior Member
 
Join Date: Oct 2006
Posts: 533
Thanks: 4
Thanked 2 Times in 2 Posts
 
Default

Quote:
Originally Posted by marpada View Post
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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Howto analyse a IPTables firewall issue? chillifire Installation/Configuration 2 27th August 2008 07:23
phpmyadmin error lifeisboost Installation/Configuration 9 14th August 2008 19:19
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 08:04
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
mysql clustering problem : cannot create table in database prince.fer Server Operation 2 16th April 2007 17:03


All times are GMT +2. The time now is 18:19.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.