How to Create Database in MySQL?
Before you can interact with your MySQL database, you need to create it! We can show you two ways to do this: with phpMyAdmin, or with SQL code from the query window or a shell prompt. Don’t worry it’s not hard.
Here’s How to do?:
1. If you have phpMyAdmin, you first need to login. In the right hand you are looking for “Create New Database”. All you need to do is enter the database name, and click create. Sometimes this feature is disabled. If this is the case, you need to contact your hosting company to create a new database.
2. You can use SQL code through the SQL query
mysql_query(“create database databasename”);
Insert this query into php code than create database.
3. Now, start run command.
You are going to run command and going to “cd wamp/bin/mysql/mysql any version/bin” and push Enter button and than “mysql -u username -p” and push Enter button than enter your Password and Now “create database databasename;” and push enter button.
Your Database has been created.