This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
info:mysql:user:create [2015-09-24 19:18] andunix |
info:mysql:user:create [2016-01-25 11:49] (current) andunix |
||
---|---|---|---|
Line 25: | Line 25: | ||
CREATE DATABASE IF NOT EXISTS `{db}`; | CREATE DATABASE IF NOT EXISTS `{db}`; | ||
- | GRANT ALL PRIVILEGES ON '{db}' | + | GRANT ALL PRIVILEGES ON `{db}` . * TO ' |
+ | </ | ||
+ | |||
+ | Simpler Alternative: | ||
+ | |||
+ | <code sql> | ||
+ | CREATE DATABASE IF NOT EXISTS `dbname` DEFAULT CHARACTER SET = ' | ||
+ | GRANT ALL ON `dbname`.* TO ' | ||
</ | </ | ||
{{tag> | {{tag> |