mysql用户创建以及权限刷新

来源:互联网 发布:男人月薪4500 知乎 编辑:程序博客网 时间:2024/03/28 21:04
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;
mysql>UPDATE mysql.user SET password=PASSWORD('输入新密码') WHERE user='root';
mysql>FLUSH PRIVILEGES;






遇见插入失败:


报错问题:ERROR 1364 (HY000): Field 'ssl_cipher' doesn't have a default value


修改方法:将/etc/my.cnf配置文件中  sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES屏蔽掉,重启mysql服务,等插入完成再把该配置还原,再重启服务即可


根据最新的配置信息和代码修改文档






授权:


grant all privileges on hssync.* to hssync@'%' identified by '1';


grant select,insert,update,delete on test.* to hssync@'%' identified by '1';
0 0
原创粉丝点击