db_user_pwd

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

原创最新推荐文章于 2021-04-29 22:40:32 发布 · 523 阅读

0 ·

CC 4.0 BY-SA版权

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');