"acdben" PHP Script for automatic DB creation 1

<?php
$link = mysql_connect('localhost','root','root');
if (!$link) {
    die('connection error:' . mysql_error());
}

$sql = 'CREATE DATABASE a1_masterserver_rc_4_0_02 CHARACTER SET utf8 COLLATE utf8_general_ci ;';
if (mysql_query($sql, $link)) {
    echo "base a1_masterserver_rc_4_0_02 successfully created!\n";
} else {
    echo 'error when creating a database:' . mysql_error() . "\n";
}

$sql = 'CREATE DATABASE allods_auction_rc_4_0_02 CHARACTER SET utf8 COLLATE utf8_general_ci ;';
if (mysql_query($sql, $link)) {
    echo "base allods_auction_rc_4_0_02 successfully created!\n";
} else {
    echo 'error when creating a database:' . mysql_error() . "\n";
}

$sql = 'CREATE DATABASE allods_billing_rc_4_0_02 CHARACTER SET utf8 COLLATE utf8_general_ci ;';
if (mysql_query($sql, $link)) {
    echo "base allods_billing_rc_4_0_02 successfully created!\n";
} else {
    echo 'error when creating a database:' . mysql_error() . "\n";
}

$sql = 'CREATE DATABASE allods_guild_rc_4_0_02 CHARACTER SET utf8 COLLATE utf8_general_ci ;';
if (mysql_query($sql, $link)) {
    echo "base allods_guild_rc_4_0_02 successfully created!\n";
} else {
    echo 'error when creating a database:' . mysql_error() . "\n";
}

$sql = 'CREATE DATABASE allods_mail_rc_4_0_02 CHARACTER SET utf8 COLLATE utf8_general_ci ;';
if (mysql_query($sql, $link)) {
    echo "base allods_mail_rc_4_0_02 successfully created!\n";
} else {
    echo 'error when creating a database:' . mysql_error() . "\n";
}

$sql = 'CREATE DATABASE allods_online_rc_4_0_02 CHARACTER SET utf8 COLLATE utf8_general_ci ;';
if (mysql_query($sql, $link)) {
    echo "base allods_online_rc_4_0_02 successfully created!\n";
} else {
    echo 'error when creating a database:' . mysql_error() . "\n";
}

$sql = 'CREATE DATABASE a1_reports CHARACTER SET utf8 COLLATE utf8_general_ci ;';
if (mysql_query($sql, $link)) {
    echo "base a1_reports successfully created!\n";
} else {
    echo 'error when creating a database:' . mysql_error() . "\n";
}
?>