MySQL下查看用户和建立用户

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都可以访问。