Eli Edri
Eli Edri
Programming language:SQL
2021-04-17 06:47:56
0
Q:

access denied for user 'root'@'localhost' mariadb

Lmr
Lmr
Code: SQL
2021-02-09 09:30:07 
UPDATE mysql.user SET plugin = 'mysql_native_password' WHERE user = 'root' AND plugin = 'unix_socket';
FLUSH PRIVILEGES;
1
Believe It or Not
Believe It or Not
Code: SQL
2021-02-15 03:07:34 
SELECT user,authentication_string,plugin,host FROM mysql.user;
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Current-Root-Password';
FLUSH PRIVILEGES;
1

Tags

Related

New to Communities?

Join the community