<?php

/* Attempt MySQL server connection. Assuming you are running MySQL

server with default setting (user 'root' with no password) */

$link = mysqli_connect("antares.eiu.edu", "ac_brandt", "mz%eMqsTa6js");

     

// Check connection

if($link === false){

    die("ERROR: Could not connect. " . mysqli_connect_error());

}

     

// Print host information

echo "Connect Successfully. Host info: " . mysqli_get_host_info($link);

// Attempt create database query execution


CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `username` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `password` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
>