Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161

    Unanswered: Post-Installation on a Mac OSX Snow Leopard

    I installed MySQL on a Mac OSX Snow Leopard and got the mysql service started but I couldn't login as root to reset the password.

    1. ./mysql - logs in with no username and no password but show databases doesnt show a mysql database.

    2. Couldn't login as root either.
    Code:
    $ ./mysql -u root
    ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO
    3. Neither did mysqladmin work
    Code:
    ./mysqladmin -u root password "password"
    ./mysqladmin: connect to server at 'localhost' failed
    error: 'Access denied for user 'root'@'localhost' (using password: NO)'
    Is there any other way ?
    MySQL 5.1

  2. #2
    Join Date
    Sep 2009
    Location
    San Sebastian, Spain
    Posts
    880
    Hi,

    I did put together a video tutorial on how to reset the root password if it became lost. This might be of interest to you: MySQL - changing lost root password - YouTube
    Ronan Cashell
    Certified Oracle DBA/Certified MySQL Expert (DBA & Cluster DBA)
    http://www.it-iss.com
    Follow me on Twitter

  3. #3
    Join Date
    Feb 2005
    Location
    Mumbai, India
    Posts
    161
    Thanks ! This worked. Yay ! There are some differences though. On my Mac 10.6.6, process usernames dont show up on ps -ef. It shows the userid instead. I had to just figure out the userid (0 being root and the other one being mysql).
    MySQL 5.1

Posting Permissions

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