This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
info:mysql:user:create [2013-02-04 22:17] 127.0.0.1 external edit |
info:mysql:user:create [2016-01-25 11:49] (current) andunix |
||
---|---|---|---|
Line 23: | Line 23: | ||
MAX_USER_CONNECTIONS 0 ; | MAX_USER_CONNECTIONS 0 ; | ||
- | CREATE DATABASE IF NOT EXISTS | + | CREATE DATABASE IF NOT EXISTS |
- | GRANT ALL PRIVILEGES | + | GRANT ALL PRIVILEGES ON `{db}` . * TO ' |
- | ON '{db}' | + | </ |
- | TO ' | + | |
+ | Simpler Alternative: | ||
+ | |||
+ | <code sql> | ||
+ | CREATE DATABASE IF NOT EXISTS `dbname` DEFAULT CHARACTER SET = ' | ||
+ | GRANT ALL ON `dbname`.* TO ' | ||
</ | </ | ||
{{tag> | {{tag> |