Here i’m gonna tell you about how you could able to create Database and MySQL table in your cpanel. Though its easy and many people already know it, but this article will really help those who are new in cpanel.
How to Crate Database:
Login into your cpanel account. Scroll down and click on MySQL Database.
You will see Create New Database option. See below,
Give a name and click on Create Database. Your Database is now ready. Just you need a user. From the MySQL user area create a new user by providing username and password. After creating user you need to add that with the Database.
Select the Database and user and click on Add. You will see Manage User Privileges page. Check All Privileges then click on Make Changes. You will see a confirmation message that your user have been added with the Database.
How to Crate MySQL Table:
Now go back your cpanel home area and Click on PhpMyAdmin. You will see all of your Database that you created before. Click on a Database where you want to create a table. You will see like this..
Give a name of your table and provide a number of column that you need. Click on Go. You will see then your table has been created with required column. Give the name of the column, select Type with required Length/values. See below..
Note that if your column field is only for numeric select INT and for alphanumeric select VARCHAR and values will allows you that how long the information will be for specific column fields. Click on Go. Now your MySQL table has been created. You can add or remove any column from the table structure later on.
1 comments:
nice
Post a Comment