mysql_databases
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
mysql_databases [2010/10/13 05:38] walter |
mysql_databases [2011/03/22 17:15] 127.0.0.1 external edit |
||
|---|---|---|---|
| Line 15: | Line 15: | ||
| databases are created like this: | databases are created like this: | ||
| create database mydatabase; | create database mydatabase; | ||
| - | GRANT ALL PRIVILEGES ON mydatabase.* to myuser IDENTIFIED BY 'mypassword' with GRANT OPTION; | + | GRANT ALL PRIVILEGES ON mydatabase.* to 'myuser'@'localhost' IDENTIFIED BY 'mypassword' with GRANT OPTION; |
| most of the time myuser is the same as the database name. | most of the time myuser is the same as the database name. | ||
mysql_databases.txt ยท Last modified: 2021/05/02 21:36 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
