Solution to Access Denied for User 'Root'@'localhost' (Using password:YES)

Access denied for user ‘root’@‘localhost’ (using password:YES)

  • in mac
    • open the my.conf in the directory /usr/local/mysql
    • add skip-grant-tables
    • restart the mysql service
      • sudo /usr/local/mysql/bin/mysqld_safe &
    • then use mysql -uroot -p
      • you can login without password
      • then update the password after use mysql;
      • update user set password=PASSWORD("rootadmin") where user='root';
    • after that
      • delete the skip-grant-tables add in the my.conf file
    • restart the mysql service
    • then you can use the mysql -u root -q to login with your new password