警告:mysqli_connect():(HY000/1045):用户“用户名"@“本地主机"的访问被拒绝(使用密码:是) [英] Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

问题描述

警告:mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6

Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES) in C:\Users\xampp\htdocs\PHP_Login_Script\config.php on line 6

警告:mysqli_real_escape_string() 期望参数 1 为 mysqli，布尔值在 C:\Users\xampp\htdocs\PHP_Login_Script\login.php 第 10 行

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\xampp\htdocs\PHP_Login_Script\login.php on line 10

警告:mysqli_real_escape_string() 期望参数 1 是 mysqli，布尔值在 C:\Users\xampp\htdocs\PHP_Login_Script\login.php 第 11 行

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, boolean given in C:\Users\xampp\htdocs\PHP_Login_Script\login.php on line 11

警告:mysqli_query() 期望参数 1 是 mysqli，布尔值在 C:\Users\xampp\htdocs\PHP_Login_Script\login.php 第 15 行

Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in C:\Users\xampp\htdocs\PHP_Login_Script\login.php on line 15

警告:mysqli_fetch_array() 期望参数 1 为 mysqli_result，第 16 行 C:\Users\xampp\htdocs\PHP_Login_Script\login.php 中给出的 null

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, null given in C:\Users\xampp\htdocs\PHP_Login_Script\login.php on line 16

警告:mysqli_num_rows() 期望参数 1 为 mysqli_result，空值在 C:\Users\xampp\htdocs\PHP_Login_Script\login.php 第 19 行

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in C:\Users\xampp\htdocs\PHP_Login_Script\login.php on line 19

即使我的配置文件是这样的，我也会在本地主机上收到此错误:

I'm getting this error above on localhost even if my config file is like this:

<?php

    define("DB_HOST", "localhost");
    define("DB_USER", "root");
    define("DB_PASSWORD", "");
    define("DB_DATABASE", "databasename");

    $db = mysqli_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD, DB_DATABASE);

?>

这曾经有效，但现在不再有效.这段代码有什么问题还是现在不起作用?这个是我现在正在编写的教程.

This used to work, but now it doesn't anymore. Is there any problem with this code or is it not working now? This is the tutorial I am working on right now.

推荐答案

那个用户名、主机和密码的组合是不允许连接到服务器的.验证服务器上的权限表(如果需要，重新加载授权)以及您是否连接到正确的服务器.

That combination of username, host, and password is not allowed to connect to the server. Verify the permission tables (reloading grants if required) on the server and that you're connecting to the correct server.

这篇关于警告:mysqli_connect():(HY000/1045):用户“用户名"@“本地主机"的访问被拒绝(使用密码:是)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！