SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: MySQL

  1. #1
    SitePoint Enthusiast
    Join Date
    Jul 2000
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Need Help on MySQL

    Well, I got MYSQL loaded on my server, and things are going good. Now, I am trying to follow the documentation of setting the root password by going to the bin directory typing: mysqladmin -u root -p password "my password"
    And then it would say Enter password: I do not know how to get through this part, or what the password would be. I tried putting in my password that I was trying to set it to, but that did not work and it printed:
    mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: YES)'

    Please help! Thank you! :-)
    Devin McLean
    http://dreamer.spacecoast.com
    -------------------------

  2. #2
    SitePoint Author Kevin Yank's Avatar
    Join Date
    Apr 2000
    Location
    Melbourne, Australia
    Posts
    2,571
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    The command you should be using is:

    mysqladmin -u root password "my password"

    Notice no "-p". This argument essentially says "prompt me for my password"; however, since the root account doesn't yet have a password, you don't want to try to connect using one.

    See here for more detailed instructions.

    Kevin Yank
    CTO, sitepoint.com
    I wrote: Simply JavaScript | BYO PHP/MySQL | Tech Times | Editize
    Babys got backa hard back, that is: The Ultimate CSS Reference

  3. #3
    SitePoint Enthusiast
    Join Date
    Jul 2000
    Posts
    26
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, I'll do that, thank you!
    Devin McLean
    http://dreamer.spacecoast.com
    -------------------------


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
  •