Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.
While creating a database, a lot of users don't know that there are a few additional things that they need to organize as well. That includes the procedure of new database creation:
Fortunately, cPanel added the MySQL Database Wizard that can help in creation of database by following the steps below.
How to create database in cPanel using the MySQL Database Wizard-
You have created the database successfully!
You can handle various options for managing the databases by using phpMyAdmin in cPanel such as:
The basic functionality of the phpMyAdmin is to manage your databases.
You can only browse the database tables with existing records. The Browse window opens with the records when you click on the table name.
In the structure screen you will see the structure of database’s table. You will see the field name, their data types, collation, attributes etc. You can change the field’s structure as well as delete a field. Also, you can assign indexes i.e. Primary, Unique, Index, Fulltext.
You can create a search query for the selected table by using Search action. Either you can write the WHERE clause or use the "query by example" option. You must click on the Go button to perform search query.
You can insert the records in database table through the Insert action. To insert a new record you need to fill the appropriate values and click on the Go button.
You can empty your database table using the Empty option. It will remove the records and keep the table blank.
You can delete the table as well as delete stored records in it by using the Drop option.
See more knowledge articles of cPanel.