1、第一步登录数据库
[root@instance-u5vpjp1n ~]# mysql -uroot -p
2、进到mysql库
MariaDB [(none)]> use mysql;
3、查看权限情况
MariaDB [mysql]> select host,user,password from user;
4、基于用户
MariaDB [mysql]> grant all privileges on *.* to root@'%'identified by '123456';
MariaDB [mysql]> flush privileges;
5、基于IP
MariaDB [mysql]> grant all privileges on *.* to 'root'@'192.168.0.4'identified by '123456' with grant option;
Query OK, 0 rows affected (0.00 sec)
MariaDB [mysql]> flush privileges;