2017-11-22  176 views 发表评论

MySQL权限相关内容

 标签:  

1.设置用户密码

1)  mysql>set password=password('Mima');
    mysql>flush privileges;
2)  mysql>use mysql;
    mysql>update user set password=password('Mima') where user='root';
    mysql>flush privileges;

2.授予最高权限

1)mysql>grant all privileges on *.* to root@localhost identified by 'Mima'; 
   mysql>flush privileges;
   
   


待续。。。

给我留言

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen: