mysql 创建用户:
insert into mysql.user(Host,User,Password) values('%','hsgzl',password('1'));
或
insert into mysql.user(Host,User,Password) values('主机IP地址','hsgzl',password('1'));
创建完成刷新权限:
flush privileges;
查询用户列表:
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
删除用户:
DELETE FROM mysql.user WHERE User='hsgzl' and Host='localhost';
删除用户后刷新权限:
flush privileges;
修改密码:
以root用户登录,命令:mysql -uroot -p 回车 输入密码;
mysql>use mysql;
insert into mysql.user(Host,User,Password) values('%','hsgzl',password('1'));
或
insert into mysql.user(Host,User,Password) values('主机IP地址','hsgzl',password('1'));
创建完成刷新权限:
flush privileges;
查询用户列表:
SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
删除用户:
DELETE FROM mysql.user WHERE User='hsgzl' and Host='localhost';
删除用户后刷新权限:
flush privileges;
修改密码:
以root用户登录,命令:mysql -uroot -p 回车 输入密码;
mysql>use mysql;