Cannot set MYSQL root psw

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • danno74
    New Member
    • Feb 2008
    • 2

    Cannot set MYSQL root psw

    Greetings,

    I cannot set the root password, this is what happens:

    Code:
    server - me- mysql > ./bin/mysqladmin -u root password xxxxxxx
    ./bin/mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    it's a Solaris 10 server, and I'm new to working on security, so I'm sure it's something simple. A brand new install of MySQL as well.

    Thank you!

    Dan
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    Before you start re-installing, it is better to have a look at the standard MySQL document at chapter How to Reset the Root Password

    Ronald

    Comment

    • danno74
      New Member
      • Feb 2008
      • 2

      #3
      This is a new install, I need to set the password. These are directions to reset a password, which I cannot do since there is no password to reset.

      The documentation I have says the following:

      PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER!
      To do so, start the server, then issue the following commands:
      ./bin/mysqladmin -u root password 'new-password'
      ./bin/mysqladmin -u root -h host password 'new-password'


      When I do either, I get the error I posted in my first msg.

      Am I doing something wrong?

      Comment

      • werks
        New Member
        • Dec 2007
        • 218

        #4
        Have you try re-installing it?

        --
        Kenneth
        "Better Than Yesterday"

        Comment

        Working...