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