alter user mysql native password 1

alter user mysql native password

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';

Here is what the above code is Doing:
1. We’re creating a new user called ‘root’ with the password ‘
2. We’re giving the user ‘root’ all privileges on the database ‘mysql’
3. We’re telling MySQL to use the native password plugin for the user ‘root’
4. We’re telling MySQL to use the password ‘‘ for the user ‘root’

Similar Posts