권한 문제
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 |
댓글