DEV Community

Discussion on: ACCESS DENIED: Reset MySQL root user password

Collapse
 
salsabilkz profile image
salsabil.kz

If you just run mysql command under root user you will be granted access without asked for password, because socket authentication enabled for root@localhost.

Short way to solve

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-password';