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 that hard.
Time Required: 2 mins
- If you have phpMyAdmin, you first need to login. In the right hand pane you are looking for "Create New Database". All you need to do is enter the database name, and wha-la, your done. Sometimes this feature is disabled. If this is the case, you need to contact your hosting company to create a new database.
- You can use SQL code though the SQL query window in phpMyAdmin, or from a command line. You can create a database by executing the following SQL code:
Be sure to replace DBname with the actual name you wanted your database to be called.
create database DBname;
What You Need
- Before you begin, be sure you know your MySQL username and password