1、修改/etc/my.cnf文件
skip-grant-tables=1
2、登录MySQL,并刷新
#mysql #登录mysql
mysql>FLUSH PRIVILEGES;
3、修改root密码,并刷新
mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Password@123';
mysql>FLUSH PRIVILEGES;
4、设置远程登录并刷新
mysql>update user set host='%' where user='root';
mysql>FLUSH PRIVILEGES;
5、创建用户-- 使用mysql 数据库 正式环境
mysql>USE mysql
-- 为mysql创建用户:waiyan 密码为:XXXXX
CREATE USER waiyan IDENTIFIED BY 'XXXXX';
6、查看用户-- 查看下用户waiyan的权限
SELECT FROM user WHERE user='waiyan' ;
SHOW GRANTS FOR waiyan;
7、给用户赋权-- 给用户waiyan在数据库名为prescription上赋EXECUTE(执行存储过程),INSERT,SELECT,UPDATE,DELETE权限,@'%'表示从任意ip都可以访问到这个数据库
--GRANT EXECUTE,INSERT,SELECT,UPDATE,DELETE ON prescription. TO 'waiyan'@'%';
grant all privileges ON prescription.* TO 'waiyan'@'%';