This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
mysql_databases [2010/09/27 19:37] walter created |
mysql_databases [2011/09/11 21:17] walter [Systems] |
||
---|---|---|---|
Line 2: | Line 2: | ||
Databases can be created on: | Databases can be created on: | ||
* The ACM server, acm.cs.uic.edu | * The ACM server, acm.cs.uic.edu | ||
- | * Sorbis, linux.cs.uic.edu | ||
====== Creating a database ====== | ====== Creating a database ====== | ||
Line 11: | Line 10: | ||
mysql -u root -p | mysql -u root -p | ||
+ | **SysAdmin has root db password** | ||
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. |