正在连接MySQL服务器 - Connecting to MySQL server

Connecting to MySQL server

本文关键字：服务器 MySQL 连接 | 更新日期: 2023-11-09

我这里有下面的代码行，我到处都找过如何以这种格式连接到MySQL服务器，但我似乎找不到如何连接！

$Conn = mysqli_connect("YourMySQLDetails");

通常，我会这样连接：

    $myServer = "localhost";
    $myUser = "632496";
    $myPass = "xrxy3749";
    $myDB = "632496";

但是我在网页上收到以下错误

Failed to connect to MySQL: Can't connect to MySQL server on 'YourMySqlDetails' (111)Error:

这是整个文件

<?php
$Conn;
CreateDatabase();
function CreateDatabase(){
$con=mysqli_connect("localhost","632496","xrxy3749","password","632496");
   if (mysqli_connect_errno($con))
 {
      echo "notconnect some Problem Occur";
 }
else
 {
      echo "Connect Successfully";
 }
//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer"); 
//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
   or die("Couldn't open database $myDB"); 
 AddTables();   
 }
function AddTables(){
global $Conn;
// Check connection
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="CREATE TABLE servers(ID INT NOT NULL AUTO_INCREMENT, 
 PRIMARY KEY(ID),ServerName CHAR(60),Url CHAR(100),Players INT, MaxPlayers INT, Uptime       INT, LastTimeSeen DATETIME)";
// Execute query
if (mysqli_query($Conn, $sql)){
    echo "Table servers created successfully";
}else{
     echo "Error creating table: " . mysqli_error();
  }
 }
 ?>

按照这个例子操作。我认为你的问题很容易解决。我用这个例子连接数据库。

<?php
  $con=mysqli_connect("localhost","632496","xrxy3749","632496");
  if (mysqli_connect_errno($con))
     {
          echo "notconnect some Problem Occur";
     }
  else
     {
          echo "Connect Successfully";
     }
?>

尝试使用此代码连接mysql数据库

$con=mysqli_connect("localhost","632496","xrxy3749","632496");

您已在连接详细信息中添加了额外的密码字段。

您不能在同一文件中同时使用mysql和mysqli函数。

$con=mysqli_connect("localhost","632496","xrxy3749","password","632496");

将其替换为以下代码

$con=mysqli_connect("localhost","632496","xrxy3749","632496");

一个错误

$dbhandle = mssql_connect($myServer, $myUser, $myPass)

用这个替换它

$dbhandle = mssqli_connect($myServer, $myUser, $myPass, $dbhandle)

删除此代码

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
   or die("Couldn't open database $myDB");

更换所有位置

$Conn to $con

使用以下代码来解决问题

<?php
$con = mysql_connect("localhost","username","password");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("dbname", $con);
?>