set password = ‘dbaadmin@123’;
mysql> create user root@’%’ identified by ‘dbaadmin@123’;
Query OK, 0 rows affected (0.05 sec)
mysql> grant all privileges on . to root@’%’;
Query OK, 0 rows affected (0.08 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)
mysql> ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘dbaadmin@123’;
Query OK, 0 rows affected (0.09 sec)
mysql>