<![CDATA[刘新修]]> http://liuxinxiu.com:80/index.php zh-cn http://liuxinxiu.com:80/s// <![CDATA[mysql 新建用户并授权 更新用户密码]]> 刘新修 <admin@yourname.com> Thu, 23 Feb 2023 02:35:56 +0000 http://liuxinxiu.com:80/s//
SQL代码
  1. insert into mysql.user(Host,User,Password) values ("%","admin",password("cnmo"));  
  2.   
  3. CREATE USER 'admin'@'localhost' IDENTIFIED BY 'cnmo';  
  4. GRANT privileges ON *.* TO 'admin'@'localhost';  
  5. GRANT ALL privileges on *.* to 'admin'@'localhost' identified by 'cnmo';  
  6. FLUSH PRIVILEGES;  

 更新用户密码

SQL代码
  1. use mysql # 连接权限数据库  
  2. update user set password=password('521') where user='root' and host='localhost'; # 改密码  
  3. flush privileges; # 刷新权限  

 

]]> http://liuxinxiu.com:80/s//#blogcomment <![CDATA[[评论] mysql 新建用户并授权 更新用户密码]]> <user@domain.com> Thu, 01 Jan 1970 00:00:00 +0000 http://liuxinxiu.com:80/s//#blogcomment