1.create user webapi identified by 'webapi';
2.GRANT EXECUTE,INSERT,SELECT,UPDATE,DELETE ON webapi.* TO 'webapi'@'%';
3.FLUSH PRIVILEGES;
4.完成
1.create user webapi identified by 'webapi';
2.GRANT EXECUTE,INSERT,SELECT,UPDATE,DELETE ON webapi.* TO 'webapi'@'%';
3.FLUSH PRIVILEGES;
4.完成
本文标题:mysql创建账号,并授权库给他
本文链接:https://www.haomeiwen.com/subject/rqkknhtx.html
网友评论