How do you create a MySQL database on the server?

Answer 1

Here is how you establish connection to mysql server & create a database in mysql

<?php

// Note that username, client host & passwords may vary

$host = "localhost";

$user = "root";

$password = "";

$con = mysql_connect($host,$user,$password);

if(!$con)

{

// Warns for connection failure

die("Failure in establishing connection: ".mysql_error());

}

$db = "CREATE DATABASE employees"; // Use any name for database

$create = mysql_query($db, $con);

if(!$create)

{

echo "Error creating database: ".mysql_error();

}

?>