Membuat Database MySQL

With the MySQL database you can store various information that can then be easily accessed. The database itself can not be read easily by humans. MySQL databases are widely used in various web applications such as discussion forums, content management system (CMS, content management system), and others. To be able to use the database, you need to make it first. Only MySQL user (different from the users email and other users) that have certain access rights to these databases and can be read or add data to the database.
There are two ways in making a MySQL database. The easiest way is to follow the guidance Making MySQL Database (MySQL Database wizzard) which is in cPanel ®. The second way requires manually tahapn more and do not need the guidance.
Creating a Database with the Guide
Tahapn
1. When the tutorial pages (MySQL Database Wizzard) is open, enter the name of the database you want to create the text box "New Database".
2. Click the Next Step.
3. Next seen
o "Added the database NAMA_DATABASE_ANDA"
4. Enter your user name and password in the fields "Username" and "Password" that you want to access the database.
5. Click Next Step.
6. Next will be seen
o "Added USERNAME with the password PASSWORD."
7. When the page appears, you will be confronted with two-column table. At the top there is the option "ALL PRIVILEGES" with a box to tick if you want to give all permissions on that user, you also can choose the specific permissions that are on the table underneath. Options existing access rights are:
o SELECT - Allows user to select data from tables in the database.
o INSERT - Allows the user to enter data into tables in the database.
o UPDATE - Allows user to change the data in the database.
o DELETE - Allows user to delete data in the database.
o INDEX - Allows the user to index the data in the database. This can speed up database access.
o CREATE TEMPORARY TABLES - Allows users to create temporary tables in the database.
o CREATE - Allows users to create tables in the database.
o ALTER - Allows user to change the tables in the database.
o DROP - Allows user to delete a table in the database.
o LOCK TABLES - Allows user to lock the table in the database.
o REFERENCES - Allows user to make reference to the tables in the database.
NOTE: Normally you only need to check the option "All Privileges", except if you want to give some special access to one user on this database.
8. Assuming you already gave the check to the option "All privileges" or some access rights option in the table below, continue the tutorial by clicking on Next Step button.
9. Then look
o "User USERNAME was added to the database DATABASE."
10. Furthermore, there are three options to choose from
o Add another database - Select this if you want to create the database again.
o Add another user using the MySQL Database Area - Select this if you want to add a user on the database you just created earlier.
o Return to Home - Select this if you want to return to the main page of your cPanel ®.
Creating a MySQL Database Manually
Stages
1. When this page opens, enter the name of the database you want to create the text box "New Database".
2. Click the Create Database.
3. It will then be displayed
o "Added the database NAMA_DATABASE_ANDA".
4. Click Go Back.
5. Furthermore, we will see a table that contains the name of the database you just created with the following information:
o Database - The name of the database that you created in Step 1 above.
o Size - Large size of your database.
o Users - This entry database user name that you give rights to access this database. If you create a database manually, this column is usually empty (no user is given access rights). Continue to step 6 to find out how to give permissions on your database.
o Actions - commands that you can do on this database, namely
 Delete Database - Click this to delete a database
6. In the "New User", enter your user name and password in the fields "Username" and "Password" that you want to access the database.
7. Click on the Create User button.
8. Next will be seen
o "Added USERNAME with the password PASSWORD."
9. Click Go Back.
10. See the section "Add User To Database". Select the user you created in step 6 above from the "User", then select which database you want to give that user access to the "Database".
11. Then click the Submit button.
12. When the page appears, you will be confronted with two-column table. At the top there is the option "ALL PRIVILEGES" with a box to tick if you want to give all permissions on that user, you also can choose the specific permissions that are on the table underneath. Options existing access rights are:
o SELECT - Allows user to select data from tables in the database.
o INSERT - Allows the user to enter data into tables in the database.
o UPDATE - Allows user to change the data in the database.
o DELETE - Allows user to delete data in the database.
o INDEX - Allows the user to index the data in the database. This can speed up database access.
o CREATE TEMPORARY TABLES - Allows users to create temporary tables in the database.
o CREATE - Allows users to create tables in the database.
o ALTER - Allows user to change the tables in the database.
o DROP - Allows user to delete a table in the database.
o LOCK TABLES - Allows user to lock the table in the database.
REFERENCES - Allows user to make reference to the tables in the database.
NOTE: Normally you only need to check the option "All Privileges", except if you want to give some special access to one user on this database.
13. Assuming you already gave the check to the option "All privileges" or some access rights option in the table below, continue to click on the Make Changes button.
14.Selanjutnya visible
"User USERNAME was added to the database DATABASE."
15. Click Go Back.
16. Next you can see the user, that you have created in step 6 above, in the "Users".



Donload File Database mysql:

Here