Create MySQL Database - At The Control Panel

MySQL database has become the world's most popular open source database because of its high performance, high reliability and ease of use. It is also the database of choice for a new generation of applications built on the LAMP stack (Linux, Apache, MySQL, PHP / Perl / Python.) Many of the world's largest and fastest-growing organizations including Facebook, Google, Adobe, Alcatel Lucent and Zappos rely on MySQL to save time and money powering their high-volume Web sites, business-critical systems and packaged software.

MySQL runs on more than 20 platforms including Linux, Windows, Mac OS, Solaris, IBM AIX, giving you the kind of flexibility that puts you in control. Whether you're new to database technology or an experienced developer or DBA, MySQL offers a comprehensive range of database tools, support, training and consulting services to make you successful.

Create MySQL Database

Let's follow the steps for Create MySQL Database:
  1. The first step is to log into your personal web hosting control panel.To do this, click the Control Panel login link in the upper right corner of your screen. Then enter your web hosting account details (this will be your username and password), and click the 'Login' button to go straight to your Control Panel.
  2. The second step is to enter the MySQL Databases section of the Control panel. Once on the Control Panel index page you need to click the 'MySQL Databases' icon under Site Management.
  3. To create a MySQL table you need to open the phpMyAdmin tool for the coresponding database.
  • Once in the MySQL Databases section click the database name link or its corresponding phpMyAdmin icon to open the phpMyAdmin tool.
  • Then select the database from the drop-down list on the left. Next step is to define the new table's name in the 'Name' field of the 'Create new table on database' form. Then specify the number of fields in the table in 'Number of fields' and hit the 'GO' button.
  • Once the new table is created you can specify the fields' names, length, collation, attributes, etc. In our tutorial movie we've specified some examplary field name and values for the 3 fields we created in the previous step.
  • Once you specify the values for Length, select the Collation type from the drop-down menu you need to hit the 'Save' button to save you new table settings.
Then you'll can see a summary of all MySQL database table settings.

You are all done Create MySQL Database steps.