본문 바로가기
Develop/DataBase

[오류]'Access denied for user 'root'@'localhost'

by jaekk 2018. 8. 23.

권한 문제

1. Open & Edit /etc/my.cnf
2. Add skip-grant-tables under [mysqld]
3. Restart Mysql
4. You should be able to login to mysql now using the below command mysql -u root -p
5. Run mysql> flush privileges;
6. Set new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
7. Go back to /etc/my.cnf and remove/comment skip-grant-tables
8. Restart Mysql
9. Now you will be able to login with the new password mysql -u root -p



'Develop > DataBase' 카테고리의 다른 글

[mysql]시간 설정  (0) 2018.08.23
[오류]인식되지 않은 서비스  (0) 2018.08.23
[MySQL]workbench download  (0) 2018.08.15
[MySQL] 설치 경로 확인  (0) 2018.08.10
mvc패턴 정리  (0) 2018.07.19

댓글