[MySql & Mariadb] 에러메세지 : ERROR 1698 (28000): Access denied for user 'root'@'localhost' 해결방법

[MySql & Mariadb] 에러메세지 : ERROR 1698 (28000): Access denied for user 'root'@'localhost' 해결방법

 

sudo 를 통해 mysql & maraidb 에 우선 접속합니다.

$ sudo mysql(mariadb) -u root

USE mysql;
SELECT User, Host, plugin FROM mysql.user;

+------------------+-----------------------+
| User             | plugin                |
+------------------+-----------------------+
| root             | auth_socket           |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+

root plugin 을 mysql_native_password 로 바꿔주세요 !

update user set plugin='mysql_native_password' where user='root';
flush privileges;
select user, host, plugin from user;

+------------------+-----------------------+
| User             | plugin                |
+------------------+-----------------------+
| root             | mysql_native_password |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+

이렇게 하면 에러 해결입니다.