Article:
  Apache Web-Serving With Mac OS X, Part 5
Subject:   gosh-darn password stuff
Date:   2002-04-30 22:24:34
From:   oldbenway
Okay. So I did everything, it all worked fine, I complied my own SQL, set up the service so it starts when I boot- the last thing, I went to change the password for security.
The verbatim instructions in the tutorial did nothing (error) BUT then I notice that right above that, the final install command gave me a pointer:
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
This is done with:
"/usr/local/bin/mysqladmin -u root -p password 'new-password'
See the manual for more instructions."


Soooo I type it in (and below is trhe exact line grabbed from my terminal):
[localhost:/usr/local] donny% /usr/local/bin/mysqladmin -u root -p password 'yeahRight'
Enter password:
/usr/local/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'root@localhost' (Using password: YES)'


So it seems to have created a password, but won't let me use it, whatever it may be- I know i messed things up, is there anyway to force a password reset in SQL????


Thanks for helpinging the Newb (who shouldn't be allowed to run a terminal)
-oldbenway@hotmail.com

Full Threads Oldest First

Showing messages 1 through 3 of 3.

  • gosh-darn password stuff
    2002-10-09 11:08:16  thaddaeus [View]

    My problem is very similar...

    after i am prompted to enter my password i THEN get.

    mysqladmin: command not found.

    that's kind of weird because im in /bin and I can see the executable in the directory.

    every subsequent attempt resolved in a command not found right away.

    i tried rehashing to no avail.
    • gosh-darn password stuff
      2005-03-21 17:07:53  JayBeeDee [View]

      I don´t want to pretend to know what your problem really is. In any case you could try typing ./ in front of the command you can see in your current working directory. In your case that would be ./mysqladmin plus its parameters, then it should run.

      You may also want to check, which directories are really searched for executables by typing printenv PATH
      I am no unix crack, so I do not know, if it is recomended to add the directory you are talking about permanently to the searchpath...
  • gosh-darn password stuff
    2002-06-03 17:01:40  mknauf [View]

    Hey, I did the same thing ;-(

    Help... anybody...?

    mbk@mbknauf.com