该楼层疑似违规已被系统折叠 隐藏此楼查看此楼
创建一个php文件,写入以下代码,运行后如果显示"Hello! Mysql Database connected
seccessful ;-)"说明连接正常:
$mysql_server_name='localhost'; //改成自己的mysql数据库服务器
$mysql_username='osho123_test'; //改成自己的mysql数据库用户名
$mysql_password='abc12345'; //改成自己的mysql数据库密码
$mysql_database='osho123_osho123'; //改成自己的mysql数据库名
$conn=mysql_connect($mysql_server_name,
$mysql_username,$mysql_password,
$mysql_database);
$sql='CREATE DATABASE mycounter
DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
';
mysql_query($sql);
$sql='CREATE TABLE `counter`
(`id` INT(255) UNSIGNED NOT NULL
AUTO_INCREMENT ,`count` INT(255)
UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY
( `id` ) ) TYPE = innodb;';
mysql_select_db($mysql_database,$conn);
$result=mysql_query($sql);
//echo $sql;
mysql_close($conn);
echo "Hello! Mysql Database connected seccessful ;-)";