db_user_pwd

最新推荐文章于 2021-04-29 22:40:32 发布

xyh592

最新推荐文章于 2021-04-29 22:40:32 发布

阅读量513

点赞数 1

分类专栏： sql SQL

本文链接：https://blog.youkuaiyun.com/xyh592/article/details/86070894

版权

sql 同时被 2 个专栏收录

12 篇文章

订阅专栏

SQL

8 篇文章

订阅专栏

show grants for db_risk;
drop user 'db_risk'@'%';
CREATE user 'db_risk'@'%' IDENTIFIED by 'risk';

GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE, CREATE ROUTINE, ALTER ROUTINE, TRIGGER ON `ys_mosquito`.* TO 'db_mosquito'@'192.168.0.%'

flush PRIVILEGES;


alter user 'manage'@'%' IDENTIFIED by 'wvk9d7NTfknlAcqMv7cz';

grant all on *.* to 'test_1'@'localhost' identified by '123456';
SET PASSWORD FOR 'test_1'@'localhost' = PASSWORD('123456789');