1.添加用户
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
语句描述:给所有ip并且用户名为myuser的用户分配所有数据库.所有表的操作权限,用mypassword这个密码
%代表所有的用户都可以进行远程连接
2.删除用户
mysql>Delete FROM user Where User="dev" and Host="localhost";
mysql>flush privileges;
3.查询mysql所有的用户
select user,host,password from mysql.user;
4.修改mysql用户名和密码
在mysql状态下:
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root’;
mysql>FLUSH PRIVILEGES;
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
语句描述:给所有ip并且用户名为myuser的用户分配所有数据库.所有表的操作权限,用mypassword这个密码
%代表所有的用户都可以进行远程连接
2.删除用户
mysql>Delete FROM user Where User="dev" and Host="localhost";
mysql>flush privileges;
3.查询mysql所有的用户
select user,host,password from mysql.user;
4.修改mysql用户名和密码
在mysql状态下:
mysql>UPDATE user SET password=PASSWORD(’new_password’) WHERE user=’root’;
mysql>FLUSH PRIVILEGES;