Warning mysqli connect HY000 1045 Access denied for user username localhost using password YES

Question

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      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      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      Warning  mysqli query   expects parameter 1 to be mysqli  boolean given in C  Users xampp htdocs PHP Login Script login php on line 15      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      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     lt  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      gt    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

User · Answer

The same issue faced me with XAMPP 7 and opencart Arabic 3   Replacing  localhost by the actual machine name reslove the issue

User · Answer

Use this  After setup this you will not receive this issue again   SET PASSWORD FOR root localhost   PASSWORD  your root password      I was stuck up in this issue after used this query everything was solved

User · Answer

mysqli connect DB SERVER DB USERNAME DB PASSWORD DB DATABASE     use DB HOST instead of DB SERVER

User · Answer

try   define  DB PASSWORD   null     and those are warnings  try    db    mysqli connect DB SERVER DB USERNAME DB PASSWORD DB DATABASE     But i will recommend you to set a root password

User · Answer

Try the above answers 90  of the time this will be you issue  For me my problem was that my database password had a   in it    servername    127 0 0 1    username    user bob    password    sdfasdf B     conn   mysqli connect  servername   username   password   any database       DO NOT USE DOUBLE QUOTES     password    sdfasdf B

User · Answer

Do you have two connections at the same time  If so  close every time you don t need it

User · Answer

Look at your code  You defined DB HOST and querying DB SERVER  DB USER and DB USERNAME Use this code  define  DB SERVER    localhost    define  DB USER    root    define  DB PASSWORD        define  DB DATABASE    databasename      connect   mysqli connect DB SERVER   DB USER  DB PASSWORD  DB DATABASE

User · Answer

In my case the problem was   define   DB PASSWORD    MyPassw0rd         the odd single   before the double

User · Answer

If youre running wamp update   define  DB HOST    localhost      To your machines ip address  mine is 192 168 0 25    define  DB HOST    192 168 0 25      You can find it on window by typing ipconfig in your console or ifconfig on mac linux

User · Answer

There is a typo error in define arguments  change DB HOST into DB SERVER and DB USER into DB USERNAME    lt  php      define  DB SERVER    localhost        define  DB USERNAME    root        define  DB PASSWORD            define  DB DATABASE    databasename         db   mysqli connect DB SERVER  DB USERNAME  DB PASSWORD  DB DATABASE      gt

User · Answer

I have fixed a few things here  the  DB HOST  defined here should be also DB HOST down there  and the  DB USER  is called  DB USER  down there too  check the code always that those are the same    lt  php     define  DB HOST    localhost        define  DB USER    root        define  DB PASSWORD            define  DB DATABASE              db   mysqli connect DB HOST  DB USER  DB PASSWORD  DB DATABASE     gt

User · Answer

Not that anyone would ever have CAPS on when entering a password   but it can give this error

User · Answer

I had this error trying to connect with a different user than root I d set up to limit access   In mysql I d set up user MofX with host   and it wouldn t connect   When I changed the user s host to 127 0 0 1  as in  MofX   127 0 0 1   it worked

User · Answer

you defIne as DB USER but use as DB USERNAME  Also php says username localhost cant access  Not root localhost    Change your define or connect paramater

User · Answer

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

User · Answer

Try changing    define  DB SERVER    localhost      to this   define  DB SERVER    127 0 0 1

User · Answer

This is your code    lt  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      gt    The only error that causes this message is that    you re defining a DB USER but you re calling after as DB USERNAME    Please be more careful next time   It is better for an entry-level programmer that wants to start coding in PHP not to use what he or she does not know very well    ONLY as advice  please try to use  for the first time  code more ubiquitous   ex  do not use the define   statement  try to use variables declaration as  db user    root    Have a nice experience

User · Answer

Same problem occurd with me  with AWS RDS MySQL  Just now  answered similar question here  Looked various sources  but as of this thread  almost all lack of answer  While this thread helped me  tweak in mind to update hostnames at server  Access your SSH and follow the steps   cd  etc  sudo nano hosts   Now  Appending here your hostnames  For example   127 0 0 1 localhost 127 0 0 1 subdomain domain com  if cname redirected to endpoints  127 0 0 1 xxxxxxxx xxxx xxxxx rds amazonaws com  Endpoints    and now  configuring config database php as follows    active group    default    query builder   TRUE    db  default     array       dsn      gt           hostname    gt   35 150 12 345        username    gt   user-name-here        password    gt   password-here        database    gt   database-name-here        dbdriver    gt   mysqli        dbprefix    gt           pconnect    gt  FALSE       db debug    gt  TRUE       cache on    gt  FALSE       cachedir    gt           char set    gt   utf8        dbcollat    gt   utf8 general ci        swap pre    gt           encrypt    gt  FALSE       compress    gt  FALSE       stricton    gt  FALSE       failover    gt  array         save queries    gt  TRUE      where 35 150 12 345 is your IPv4 Public IP  located at ec2-dashboard  gt  Network Interfaces  gt  Description   RDSNetworkInterface  gt  gt  IPv4 Public IP  35 150 12 345   there   Note  Please note that only IPV4 will work at  hostname  option  hostname  cname  domains will output database connection error

User · Answer

db   mysqli connect DB SERVER DB USERNAME DB PASSWORD DB DATABASE    Put   DB HOST   instead of   DB SERVER   also  put   DB USER   Instead of   DB USERNAME      than it working fine

User · Answer

Make sure that your password doesn t have special characters and just keep a plain password  for ex  12345   it will work  This is the strangest thing that I have ever seen  I spent about 2 hours to figure this out   Note  12345 mentioned below is your plain password  GRANT ALL PRIVILEGES ON dbname   TO  yourusername      IDENTIFIED BY  12345

User · Answer

The question has been answered above  Just to make you feel comfortable using all four string at the same time in a connection   lt  php   define  DB HOST    localhost      define  DB USER    root      define  DB PASSWORD          define  DB DATABASE    databasename        db   new mysqli DB SERVER  DB USERNAME  DB PASSWORD  DB DATABASE        you could test connection eventually using a if and else conditional statement        feel free to take out the code below once you see Connected    if   db        echo  Connected        else       echo  Connection Failed         gt

[php] Warning: mysqli_connect(): (HY000/1045): Access denied for user 'username'@'localhost' (using password: YES)

Examples related to php

Examples related to mysql

Examples related to database

Examples related to phpmyadmin

Examples related to localhost