SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: MySQL password

  1. #1
    SitePoint Zealot
    Join Date
    Dec 2000
    Location
    Ohio
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Being a newbie, I don't know if I did this correct or not. I log into MySQL as root. I typed:

    mysql> mysqladmin -u root cobalt-mysql newpassword
    ->

    I get a blank line after that. I tried to log on with the new password and it doesn't work. What did I do wrong?


  2. #2
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What are trying to do, just login?

    $>mysql -u root -p

    then type your password at the prompt if you are trying to password log in as root

    mysql>use mysql
    mysql>UPDATE user set password = password('yournewpassword') WHERE User = 'root';

    Please don't PM me with questions.
    Use the forums, that is what they are here for.

  3. #3
    SitePoint Zealot
    Join Date
    Dec 2000
    Location
    Ohio
    Posts
    150
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I can login fine, and then proced to do that. I get:

    Query OK, 0 rows affected (0.00 sec)
    Rows matched: 2 Changed: 0 Warnings: 0

    So I'm assuming nothing was changed isnce the old password still works.

  4. #4
    Dumb PHP codin' cat
    Join Date
    Aug 2000
    Location
    San Diego, CA
    Posts
    5,460
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh yeah run a $>mysqladmin -u root -p reload

    That is at the command prompt not the mysql command prompt and supply the original password for root
    Please don't PM me with questions.
    Use the forums, that is what they are here for.


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
  •