info:mysql:user:create
Please note, that this is an old archived version of this site.
Check out the new version at andunix.net!
Differences
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> | ||
info/mysql/user/create.1443122325.txt.gz · Last modified: 2015-09-24 19:18 by andunix
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution 4.0 International
