php - mySql 数据库连接到错误的服务器

Question

我一直在尝试设置 Sql 数据库，但无法在 php 中连接它。我的代码如下所示:

$conn = mysql_connect("my_sql_here.net","root",'my_password_here');
print $conn;
mysql_select_db("my_database",$conn);

$created = mysql_query("SELECT * FROM `inventory`);
if(!$created) {
print "error: ";
print mysql_error();
}
print json_encode($created);
mysql_close($conn); 

当我运行此代码时，我得到:

error: Access denied for user 'dom710'@'localhost' (using password: NO)false

为什么它尝试连接到本地主机？为什么尝试使用 root 作为密码？我非常困惑。

Answer 1

考虑使用 PDO 建立连接:

// Establish a connection
$host = 'my_sql_here.net';
$name = 'my_database';
$user = 'root';
$pass = 'my_password_here';

$dsn = "mysql:dbname=$name;host=$host;charset=utf8";
$conn = new PDO($dsn, $user, $pass);

// Perform your query
$query = 'SELECT * FROM `inventory`';
$statement = $conn->prepare($query);
$statement->execute();
$resultSet = $statement->fetchAll();

// Do stuff with your $resultSet