phpMyAdmin access denied for user root localhost using password NO

Question

I am unable to connect to my MySQL in xampp I have this error      MySQL said  Documentation      1045 - Access denied for user  root   localhost   using password  NO       mysqli real connect     HY000 1045   Access denied for user  root   localhost   using password  NO    phpMyAdmin tried to connect to the MySQL server  and the server rejected the connection  You should check the host  username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server    CONFIG INC PHP file   lt  php      This is needed for cookie based authentication to encrypt password in   cookie     cfg  blowfish secret      xampp      YOU SHOULD CHANGE THIS FOR A MORE SECURE COOKIE AUTH           Servers configuration     i   0        First server     i        Authentication type and info     cfg  Servers    i   auth type      config    cfg  Servers    i   user      root    cfg  Servers    i   password          cfg  Servers    i   extension      mysqli    cfg  Servers    i   AllowNoPassword     true   cfg  Lang             Bind to the localhost ipv4 address and tcp     cfg  Servers    i   host      127 0 0 1    cfg  Servers    i   connect type      tcp       User for advanced features     cfg  Servers    i   controluser      pma    cfg  Servers    i   controlpass             Advanced phpMyAdmin features     cfg  Servers    i   pmadb      phpmyadmin    cfg  Servers    i   bookmarktable      pma  bookmark    cfg  Servers    i   relation      pma  relation    cfg  Servers    i   table info      pma  table info    cfg  Servers    i   table coords      pma  table coords    cfg  Servers    i   pdf pages      pma  pdf pages    cfg  Servers    i   column info      pma  column info    cfg  Servers    i   history      pma  history    cfg  Servers    i   designer coords      pma  designer coords    cfg  Servers    i   tracking      pma  tracking    cfg  Servers    i   userconfig      pma  userconfig    cfg  Servers    i   recent      pma  recent    cfg  Servers    i   table uiprefs      pma  table uiprefs    cfg  Servers    i   users      pma  users    cfg  Servers    i   usergroups      pma  usergroups    cfg  Servers    i   navigationhiding      pma  navigationhiding    cfg  Servers    i   savedsearches      pma  savedsearches    cfg  Servers    i   central columns      pma  central columns    cfg  Servers    i   designer settings      pma  designer settings    cfg  Servers    i   export templates      pma  export templates    cfg  Servers    i   favorite      pma  favorite          End of servers configuration

User · Answer

Please run and re reconfigure your phpmyadmin sudo dpkg-reconfigure phpmyadmin

User · Answer

Go got XAMPP- mysql- bin- my ini  open the file with an editor and add  skip-grant-tables  after mysql

User · Answer

You need to modify the config-db php and set your password to the password you gave to the user root  or else if he has no password leave as this

User · Answer

This is the Different Solution  Check if your Services are running correctly  if WAMP icon showing orange color  and 2 out of 3 services are running it s showing  then this solution will work   Root cause   If in your system mysql was there  later you installed WAMP then again one MYSQL will install as WAMP package  default port for MYSQL is 3306   So in both mysql the port will be 3306  which is a port conflict  So just change the port it will work fine  Steps to change the Port    Right click the  WAMP icon  Chose Tool Change the port in Port used by MySql Section

User · Answer

found a solution  in my config file I just changed    cfg  Servers    i   auth type      config     to   cfg  Servers    i   auth type      HTTP

User · Answer

Just do what the message is asking for  create the user pma localhost in the phpMyAdmin panel with no password

User · Answer

cfg  Servers    i   auth type      HTTP    cfg  Servers    i   user      root    cfg  Servers    i   password      1234     This solves my problem too  It just logs in automatically

User · Answer

In case none of the aforementioned solutions works for you  then simply do the under changes  Change this   cfg  Servers    i   host      127 0 0 1     to   cfg  Servers    i   host      localhost     and   cfg  Servers    i   auth type      config     to   cfg  Servers    I   auth type     cookies     It works in my situation  possibly works on your situation also

User · Answer

Edit the file xampp mysql bin my ini  Add  skip-grant-tables   under  mysqld

User · Answer

When you install the WAMPP in your machine by default the password of PhpMyAdmin is blank  so put root in user Section and left blank of password field  hope it works    Happy Coding

User · Answer

Check  etc phpmyadmin config-db php file  Go to terminal run vi  etc phpmyadmin config-db php check the information Hit Ctrl   X Try login to phpmyadmin again through the web using the information from the config file

User · Answer

You may had set different passwords for user  root  or have been changed your password  I had same error as   mysqli real connect     HY000 1045   Access denied for user  root   localhost   using password  YES  and I found that my root password for phpmyAdmin is not same on both  mysql  and  phpmyadmin  databases  so I updated my password for  phpmyadmin  database same as  mysql  database as follow  sudo gedit  etc phpmyadmin config-db php and update the fields   dbuser  root    dbpass  myNewPassword    lt -- update your new password here  Best wishes

User · Answer

Follow these steps- 1 go to config inc php file and find -  cfg  Servers    i   auth type    2 change the value of  cfg  Servers    i   auth type   to  cookie  or  http    3 find  cfg  Servers    i   AllowNoPassword   and change it s value to true   Now whenever you want to login  enter root as your username skip the password and go ahead pressing the submit button    Note- if you choose authentication type as cookie then whenever you will close the browser and reopen it  again you have to login

User · Answer

Authentication type and info     cfg  Servers    i   password         lt ----your password   or     User for advanced features      cfg  Servers    i   controluser      pma     cfg  Servers    i   controlpass           to     User for advanced features      cfg  Servers    i   controluser      your user     cfg  Servers    i   controlpass      your password

User · Answer

guzuer   Change the value of    cfg  Servers    i   user      groot    cfg  Servers    i   password    groot     in your   xampp phpMyAdmin config inc php  Here my username is groot and password is groot   At the time of writing this answer  I had this issue and i fixed it by looking up your question

[phpmyadmin] phpMyAdmin access denied for user 'root'@'localhost' (using password: NO)

Examples related to phpmyadmin

Examples related to xampp