we can create new databases and import table using phpMyAdmin. Create a database by clicking on the “New” link at the top of the left panel, or navigate to the databases tab. Enter a name for your new database (e.g., “CSC”) and select a “collation”, with is the encoding format used to stored text characters. The name must be 64 character or less and composed of letters, numbers and underscores. Avoid using numbers at the start of the name. Good name should indicate the purpose of the database.
Collation is set of rules used in comparison. Many people use MySql to store data other than English. Data is stored in MySql using a specific character set. The character set can be defined at different levels. We need t select the rules of collation which in turn depend on the character set chosen.
Now click on Create button it will create your database which will get added to the recent databases list.
