A database consists of one or more tables.
You will need special CREATE privileges to create or to delete a MySQL database.
Create a MySQL Database Using MySQLi and PDO
The CREATE DATABASE statement is used to create a database in MySQL.
The following examples create a database named "myDB":
Example [MySQLi Object-oriented]
Note: When you create a new database, you must only specify the first three arguments to the mysqli object [servername, username and password].
Tip: If you have to use a specific port, add an empty string for the database-name argument, like this: new mysqli["localhost", "username", "password", "", port]
Example [MySQLi Procedural]
Note: The following PDO example create a database named "myDBPDO":
Example [PDO]
Tip: A great benefit of PDO is that it has exception class to handle any problems that may occur in our database queries. If an exception is thrown within the try{ } block, the script stops executing and flows directly to the first catch[]{ } block. In the catch block above we echo the SQL statement and the generated error message.
In this tutorial you will learn how to create a database in MySQL using PHP.
Creating MySQL Database Using PHP
Now that you've understood how to open a connection to the MySQL database server. In this tutorial you will learn how to execute SQL query to create a database.
Before saving or accessing the data, we need to create a database first. The CREATE DATABASE
statement is used to create a new database in MySQL.
Let's make a SQL query using the CREATE DATABASE
statement, after that we will execute this SQL query through passing it to the PHP mysqli_query[]
function to finally create our database. The following example creates a database named demo.
Example
Procedural Object Oriented PDO
Download
Tip: Setting the PDO::ATTR_ERRMODE
attribute to PDO::ERRMODE_EXCEPTION
tells PDO to throw exceptions whenever a database error occurs.