qbmiller
发布于

mysql8 增加用户

create database xxxx_db;
 create user 'username'@'%' identified by 'xxxxxxx'; 
 grant all privileges on xxxxx_db.* to 'username'@'%' ; 
 flush privileges; 

drop user 'username'@'%';

ALTER USER 'username'@'%' IDENTIFIED WITH mysql_native_password BY 'xxxxxxx';  
浏览 (28)
点赞
收藏
评论