After which it became authentication_string. Note1: password is the column name in table er prior to version 5.7. Now kill the mysqld_safe process and restart mysqld normally: $ sudo service mysqld start Mysql> UPDATE user SET password=PASSWORD('YOUR_NEW_PASSWORD_HERE') WHERE user = 'root' Open another terminal and open a mysql session to execute this: $ mysql Start a mysql deamon with this option: $ sudo mysqld_safe -skip-grant-tables Maybe updating the package the updater overwrote the root password. MYSQL is running in my system preferences. When i enter mysql or mysql -u root -p it gives me this:ĮRROR 1045 (28000): Access denied for user (using password: YES)ĮRROR 1045 (28000): Access denied for user (using password: NO) $ alias mysqladmin=/usr/local/mysql/bin/mysqladmin $ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start I plan on using this for Python, on my other computer I only use MYSQL (no MAMP) and I prefer to keep it that way. So far I’ve been able to get it installed but I cannot get my root user access (or any user for that matter). I just got a new macbook pro (OS X 10.8.2) and am attempting to get mysql set up on it.
