how to modify alter user root@localhost identified with mysql_native_password by properly 1

how to modify alter user root@localhost identified with mysql_native_password by properly

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.1.2.%'
IDENTIFIED BY PASSWORD '*fdfgdgdggfggfgfg' WITH GRANT OPTION;

Here is what the above code is Doing:
1. It’s creating a user called root.
2. It’s allowing the user to connect from any host.
3. It’s setting the password for the user to ‘password’.
4. It’s granting all privileges to the user.

Similar Posts