mysql> ALTER USER root@localhost IDENTIFIED BY password PASSWORD EXPIRE NEVER;
Query OK, 0 rows affected (0.10 sec)
mysql> ALTER USER root@localhost IDENTIFIED BY password PASSWORD EXPIRE NEVER; Query OK, 0 rows affected (0.10 sec)
mysql> ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY password;
Query OK, 0 rows affected (0.35 sec)
mysql> ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY password; Query OK, 0 rows affected (0.35 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.28 sec)
mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.28 sec)
mysql> ALTER USER root@localhost IDENTIFIED BY password PASSWORD EXPIRE NEVER; Query OK, 0 rows affected (0.10 sec) mysql> ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY password; Query OK, 0 rows affected (0.35 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.28 sec)
mysql> ALTER USER root@localhost IDENTIFIED BY password PASSWORD EXPIRE NEVER; Query OK, 0 rows affected (0.10 sec) mysql> ALTER USER root@localhost IDENTIFIED WITH mysql_native_password BY password; Query OK, 0 rows affected (0.35 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.28 sec)
