| Command |
Comments |
| cd \mysql\bin | |
| mysql -u <userid> -p | <userid> is what was setup
when MySQL was installed. Do not use the -p option if no password
was setup for MySQL |
| create database <new database
name>; |
<new database name> is a
user created value, I recommend all lower case and no special
characters
or spaces. Should be descriptive as to what the database is used for. For the Messier list just use messier. |
| use <new daabase name>; |
|
| \. \mysql\scripts\<script
file> |
<script file> that was
placed in \mysql\scripts |
| grant select, update, insert,
delete on <new database name>.* to
astrouser@localhost; |
|
| exit |
Closes MySQL session. |
| exit |
exits out of command prompt. |