与Windows相比，如何在Ubuntu中创建MySQL表？

Im helping out a Github project. Myself im coding in windows while the actual project runs live on a Ubuntu Webserver. On my local repo i created an additional table creating a blank PHP file with this code and then just manually opening this (table.php) file once in the browser.

<?php    

$db = 'B5CGM';
$user='root';
$pw='147147';

//$user='root';
//$pw='';

$db_connect = mysql_connect("localhost", $user, $pw)
or die (mysql_error());

mysql_select_db($db, $db_connect);

$sql = "CREATE TABLE tac_flightsize
(

    entry int NOT NULL AUTO_INCREMENT,
    gameid int,    
    shipid int,
    flightsize int,

    PRIMARY KEY (entry),
 )";

mysql_query($sql, $db_connect);

echo "done";


?>

However, this approach (with adjust $user and $pw) is not working on the live server. What am i doing wrong when it comes to comparing windows to ubuntu ?

thanks,