SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Apr 2003
    Location
    wien
    Posts
    2
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question change mysql pw does not work

    Hi all,

    I am starting to use mysql and trying to change the pw of root:


    =====================================================
    C:\mysql\bin>mysqladmin -u root password "test"

    C:\mysql\bin>mysqladmin -u root reload

    C:\mysql\bin>mysqladmin -u root -p status
    Enter password: ****
    mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user: 'root@127.0.0.1' (Using password: YES)'

    C:\mysql\bin>mysqladmin -u root -p status
    Enter password:
    Uptime: 12143 Threads: 2 Questions: 1345 Slow queries: 0 Opens: 66 Flush ta
    bles: 3 Open tables: 1 Queries per second avg: 0.111

    =====================================================


    ...but it does not work, i try to change the pw to "test" but it still stays "" ...

    ...many tnx 4 help

    mfg [AFB]-Mauser-

  2. #2
    SitePoint Guru
    Join Date
    Feb 2002
    Posts
    625
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Im not sure if this might help, but try this

    First you need to remove the anonymous user that has all privileges, than you set a password for root.

    C:\> C:\mysql\bin\mysql mysql
    mysql> DELETE FROM user WHERE Host='localhost' AND User='';
    mysql> QUIT
    C:\> C:\mysql\bin\mysqladmin reload
    C:\> C:\mysql\bin\mysqladmin -u root password your_password


Bookmarks

Posting Permissions

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