Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2006
    Posts
    63

    Unanswered: What database table shall I use

    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

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Jun 2006
    Posts
    63
    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

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    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
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Jun 2006
    Posts
    63
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •