text: //connection variables
  $host = 'localhost';
  $user = 'root';
  $password = 'Cord0243';
  
  //create mysql connection
  $mysqli = new mysqli($host,$user,$password);
  if ($mysqli->connect_errno) {
      printf("Connection failed: %s\n", $mysqli->connect_error);
      die();
  }
  
  //create the database
  if ( !$mysqli->query('CREATE DATABASE accounts2') ) {
      printf("Errormessage: %s\n", $mysqli->error);
  }
  
  //create users table with all the fields
  $mysqli->query('
  CREATE TABLE `accounts2`.`users` 
  (
      `id` INT NOT NULL AUTO_INCREMENT,
      `username` VARCHAR(100) NOT NULL,
      `email` VARCHAR(100) NOT NULL,
      `password` VARCHAR(100) NOT NULL,
      `avatar` VARCHAR(100) NOT NULL,
  PRIMARY KEY (`id`) 
  );') or die($mysqli->error);
  