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 | |||
|
info:mysql:user:create [2015-09-24 19:19] andunix |
info:mysql:user:create [2016-01-25 11:49] (current) andunix |
||
|---|---|---|---|
| Line 26: | Line 26: | ||
| GRANT ALL PRIVILEGES ON `{db}` . * TO ' | 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.1443122366.txt.gz · Last modified: 2015-09-24 19:19 by andunix
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution 4.0 International
