How
to Create a MySQL Database?
MySQL Databases are used with a lot of applications and is a
very powerful database program. Creating a mySQL database is
a relatively easy process but there are some pitfalls. Follow
these instructions and you will be on your way:
1 Log into the Control Panel for the site in which you want
to have the database.
2. Click on "MySQL Database".
You will now see a list of the databases for the site. If you
have not created a mySQL database yet you will see the boxes
to do so.
3. Next the box marked "Db:" put in
the name you want the database to have.
4. Click on "Add Db" right next to
the box you just typed in the name.
You should now see a screen which says the database was created.
But you are not finished yet.
5. Click on "Go Back".
You will now see, at the top of the screen, your newly created
database.
IMPORTANT NOTE: Your database is NOT named the
same as you just entered it. The software has added your login
name to the beginning
of the database name. For example if you login to this site is
fred and the name you entered in for the database is flintstone;
the name of the database is: fred_flintstone . This is an important
note in that whenever you want to access this database you have
to use this "fred_flintstone" name.
Now that you have created a database you must create a User
to be able to access the database. If you don't give someone
permission to access the (i.e, create a user) the database is
worthless.
To create a User do the following:
6. Scroll down until you see the section marked "Users ".
7. Enter in a name for the User next to the box
marked "Username ".
8. Enter in a password for this User in the box
marked "Password ".
9. Click on "Add User ".
Now you have just created a User. You will see a screen telling
you the account was created. But you are not finished.
10. Click on the "Go Back ".
NOTE: The User you just created will NOT be named just as you
created it. The software will add your login name to the beginning
just like it did for the database.
The last step you must do is tell the database that the User
you just created can access it. You do that by the following:
11. Look for the section of boxes just above the User's section
and just above the box where you entered/created a database.
It should have the User name and database you just created in
the drop down boxes.
12. To add a User to a Database simply select
the User you want in the first drop down box and then the database
in the second
box and press the "Add User to Db " button.
You should now see a screen which says the "Account was
added to Access List ". Now click on "Go Back ".
You have now created a database, created a User to access the
database , given the User a password, and can now use these settings
in any program which asks for them. Just remember the database
name (and the user name) will start with the account's login
name. The password will be exactly as you entered it into the
box.
Want to view
a Flash Video on How to Create a MySQL Database?
|
