当前位置: 代码迷 >> 综合 >> mysql 添加用户
  详细解决方案

mysql 添加用户

热度:81   发布时间:2024-01-16 08:57:56.0


1.mysql 添加用户
 grant select,insert,update,delete on *.* to cmscms@localhost Identified by "cmscms";
 grant select,insert,update,delete on *.* to cmscms@"%" Identified by "cmscms";


2运行mysql
>use mysql  ---------**在这一步,继续不下去了。提示错误ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'mysql'**---------
>update user set password=password("new_password") where user="root";
>flush privileges;
>exit

update user set password=password("cmscms") where user="cmscms";
flush privileges;

  相关解决方案