1:
[root@server ~]# mysql -uroot -p
Enter password:
2:
mysql> show databases;
3:
mysql>use mysql;
4:查看用户
select host,user from mysql.user;
5: 创建用户
create user ‘test’@’%’ identified by ‘test’;
6:
%-所有ip都可以访问。
1:
[root@server ~]# mysql -uroot -p
Enter password:
2:
mysql> show databases;
3:
mysql>use mysql;
4:查看用户
select host,user from mysql.user;
5: 创建用户
create user ‘test’@’%’ identified by ‘test’;
6:
%-所有ip都可以访问。