PHP无法连接MySQL，但能够识别密码

Question

当我使用 php 使用 Netbeans 连接 MySQL 时，我的远程服务器出现问题

这是我的 PHP 代码:

<?php
    $dbPassword = "********";
    $dbUserName = "********";
    $dbServer = "192.168.1.98"; //Remote Server with LAMP
    $dbName = "test";

    ini_set('display_errors',1);
    error_reporting(E_ALL ^ E_NOTICE);

    $connection = new mysqli($dbServer,$dbUserName,$dbPassword,$dbName);
    if (mysqli_connect_error()) {
      die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
    }

    print_r($connection);
    ?>

我使用了基于 this 的给定代码用户的回复检查是否有错误，否则不会显示任何内容。

这是结果:

mysqli Object ( [affected_rows] => 0 [client_info] => mysqlnd 5.0.12-dev 
- 20150407 - $Id: b5c5906d452ec590732a93b051f3827e02749b83 $ 
[client_version] => 50012 [connect_errno] => 0 [connect_error] => [errno] => 0
[error] => [error_list] => Array ( ) [field_count] => 0 [host_info] =>
 192.168.1.98 via TCP/IP [info] => [insert_id] => 0 [server_info] => 5.7.19-
0ubuntu0.16.04.1 [server_version] => 50719 [stat] => Uptime: 4794 Threads: 5 
Questions: 1574 Slow queries: 0 Opens: 339 Flush tables: 1 Open tables: 166 
Queries per second avg: 0.328 [sqlstate] => 00000 [protocol_version] => 10 
[thread_id] => 182 [warning_count] => 0 )

*认真的吗？

当我使用phpinfo()测试时，我的php正在工作，但似乎无法连接mysql数据库

令我困惑的部分是当我在 phpcode 中将 mysql 的密码留空时:它显示:

Warning: mysqli::__construct(): (HY000/1045): Access denied for user 'joeslie'@'192.168.1.98' (using password: YES) in /var/www/html/files/config.php on line 11 Connect Error (1045) Access denied for user 'joeslie'@'192.168.1.98' (using password: YES)

所以我可以说PHP仍然可以通信并识别错误的密码。有什么建议吗？

Answer 1

尝试此操作，如果您能够创建表或显示任何错误，请告诉我。

 <?php
  $dbPassword = "********";
  $dbUserName = "********";
  $dbServer = "192.168.1.98"; //Remote Server with LAMP
  $dbName = "test";

  ini_set('display_errors',1);
  error_reporting(E_ALL ^ E_NOTICE);

  $connection = new mysqli($dbServer,$dbUserName,$dbPassword,$dbName);
  if($connection){
   echo "Connected to database.";
  }else{
   die('Connect Error (' . mysqli_connect_errno() . ') '. mysqli_connect_error());
  }

  // sql to create table
  $sql = "CREATE TABLE tableName(
   id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, 
   firstname VARCHAR(30) NOT NULL,
   lastname VARCHAR(30) NOT NULL,
   email VARCHAR(50),
   reg_date TIMESTAMP
  )";

  if (mysqli_query($connection , $sql)) {
   echo "Table tableName created successfully";
  } else {
   echo "Error creating table: " . mysqli_error($conn);
  }
  ?>