2022年8月11日 星期四

创建用户admin，设置密码 （localhost）

CREATE USER 'admin'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpass';

授权

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;

CREATE USER 'admin'@'%' IDENTIFIED WITH mysql_native_password BY 'yourpass';

GRANT ALL PRIVILEGES ON *.* TO 'admin'@'%' WITH GRANT OPTION;

CREATE DATABASE IF NOT EXISTS `yourdb` COLLATE 'utf8_general_ci' ;

将数据库授权给admin

GRANT ALL ON `yourdb`.* TO 'admin'@'%' ;

FLUSH PRIVILEGES ;

查看授权

MySQL 查看用户授予的权限 - 潇湘隐者 - 博客园
https://www.cnblogs.com/kerrycode/p/7423850.html

修改用户名

https://blog.csdn.net/qq_40748984/article/details/118018892

mysql -u root -p 
Enter password：******
 mysql> use mysql;  选择你的数据库 
 Database changed 
 mysql> update user set user="新用户名" where user="root";    将用户名为root的改为新用户名 
 mysql> flush privileges;    刷新权限 
 mysql> exit;

修改密码

mysql -u root -p 
Enter password：******
 mysql>use mysql;  选择你的数据库 
 Database changed  
 mysql> UPDATE user SET authentication_string=PASSWORD("新密码") WHERE user='用户名'; 
 mysql> flush privileges;    刷新权限 
 mysql> quit;

远程授权

GRANT ALL PRIVILEGES ON . TO ‘sharecitys‘@’%’ identified by ‘Ylcshkts#@66Liao2021@%new11999#’ WITH GRANT OPTION;

flush privileges;