About database or database table to be used

Discussion in 'Server Operation' started by satimis, Oct 21, 2008.

  1. satimis

    satimis New Member

    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
     
  2. marpada

    marpada New Member

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

    Don't confuse the database passwords with the password of mail users :D
    ________
    Anal blonde
    ________
    No2 Vaporizer
     
    Last edited: May 13, 2011
  3. satimis

    satimis New Member

    Hi marpada,


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


    satimis
     
  4. marpada

    marpada New Member

    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: May 13, 2011
  5. satimis

    satimis New Member

    Hi marpada,


    I got password changed. Thanks


    B.R.
    satimis
     

Share This Page