Skip to content

Instantly share code, notes, and snippets.

@BiosSun

BiosSun/创建数据库用户并授予权限.mysql

Created October 24, 2013 09:14
Show Gist options
  • Save BiosSun/7133845 to your computer and use it in GitHub Desktop.
Save BiosSun/7133845 to your computer and use it in GitHub Desktop.
Download ZIP
创建 MySQL 数据库用户，同时为其分配权限。
Raw
创建数据库用户并授予权限.mysql
-- 创建一个用户，并授予其指定数据库的所有权限。
grant all privileges on `user`.* 'username'@'%' identified by 'password' with grant option;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment