MariaDB 10.3 Access denied for user 'root'@'localhost' error

DB/MariaDB

강서버 2020. 6. 2. 17:03

728x90

MariaDB 10.3 login error

$ mariadb -u root -p
Enter password:
ERROR 1698 (28000): Access denied for user 'root'@'localhost'

$ sudo mariadb -u root -p

(or sudo mysql -u root -p)

after login

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'PassW0rd';
Query OK, 0 rows affected (0.001 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.001 sec)

re-login

$ mariadb -u root -p