To create one of the standard Databases

1.  Make sure MySQL is installed and running on your system.
2.  Download the script off of my web page and unzip it.  Place the unzipped file in the "c:\mysql\scripts" directory.
3.  Start a command prompt and issue the following commands:
   
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.

Now just start the Messier Program and go to:
    Edit ->    Set Local DB
and enter the following:
    Server:        localhost (or just leave blank)
    Database:    The new database name that you just created.
    User:            astrouser

and then click on the update button.