 |
||
  |
||
 |
|
 |
|
MySQL Databases are used with a lot of applications. MySQL 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 to the box marked "Db:" put in the name you want the database to have. 4. Click on "Add Db" right next to the box that you just typed the name in. 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 how 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 as 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 database (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 that 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.
|
HOW
TO CREATE A MYSQL DATABASE |