mysql_databases
Differences
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 [2012/02/07 18:55] 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 | ||
| + | Databases can be accessed using: | ||
| + | * The mysql command on the command line in a remote or local shell | ||
| + | * Via [[https://acm.cs.uic.edu/phpmyadmin|PHPMyAdmin]] | ||
| ====== Creating a database ====== | ====== Creating a database ====== | ||
| Line 11: | Line 13: | ||
| 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. | ||
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
