当前位置:
用MySQL GRANT语句来增添新用户实操
时间:2025-11-05 00:35:48 出处:IT科技阅读(143)
复制shell> MySQL(和PHP搭配之最佳组合) --user=root
MySQL(和PHP搭配之最佳组合) MySQL(和PHP搭配之最佳组合) >
GRANT ALL PRIVILEGES ON *.*

TO monty@localhost IDENTIFIED BY something WITH GRANT OPTION;
MySQL(和PHP搭配之最佳组合) >GRANT ALL PRIVILEGES ON *.* TO monty@"%" IDENTIFIED BY something WITH GRANT OPTION;
MySQL(和PHP搭配之最佳组合) > MySQL GRANT RELOAD,用MT语用户PROCESS ON *.* TO admin@localhost; MySQL(和PHP搭配之最佳组合)> MySQL GRANT USAGE ON *.* TO dummy@localhost; 1.2.3.4.5.
分享到:
温馨提示:以上内容和图片整理于网络,仅供参考,希望对您有帮助!如有侵权行为请联系删除!