MySQL said Documentation 1045 - Access denied for user root localhost using password NO

Question

I installed xampp but when I tried to run it I got an error as thus  Error MySQL said  Documentation 1045 - Access denied for user  root   localhost   using password  NO  Connection for controluser as defined in your configuration failed  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  I tried to search on  internet for a solution  but I still can t fix my problem  I have already checked whether I used a password or not in config inc php file but  i  have not used any password Also  when i try to access with a  password  I still can t solve this problem  I hope anyone can help me   thank you

User · Answer

Check your MySQL Port number 3306   Is there any other MySQL Install in your system on same port    If any installation found the change the port number to any number between 3301-3309  except 3306      user name   root   password        Empty

User · Answer

I think to troubleshoot your problem you should try the following    Check whether the MySQL service is running  Control Panel --  services  Use a MySQL client like SQLYOG to check whether you are able to connect to MYSQL Server with the username and password you are using in your code  Just try a sample php program  which fetches the data from table  Ex  http   www anyexample com programming php php mysql example  display table as html xml

User · Answer

Here s the solution to getting the 1045 Access denied for user  root   localhost   using password  NO  in phpMyAdmin   First here s what happens   The problem occurs when you change over from using phpMyAdmin with no password and mysql with no root password   You change root in mysql to having a root password   You dutifully change phpMyAdmin s config ini php file s  cfg  Servers    i   password      line to include your password and restart everything you can find  but phpMyAdmin still can t get through     The reason is that your browser still contains cookies for phpMyAdmin and those cookies reflect not needing a password to access mysql   The solution    Clear out the cookies relating to phpMyAdmin   Its browser specific  but in my Firefox  its under Tools   Page Info   Cookies   You might need to relog in with phpMyAdmin or use the signon php script  under  examples in my WAMP install

User · Answer

Try resetting your password since it seems it has changed you can reset your password by going to  C  xampp mysql   and clicking on the resetroot bat file  Then change in the php config file the password back to blank and you should have access again

User · Answer

I had this problem with a fresh install of wamp and using only default settings without setting any passwords   I found an incorrect default setting and I solved it by the following steps    Go to C  wamp apps phpmyadmin4 1 14  Your phpmyadmin version  may differ  open the file config inc in a text editor find the line   cfg  Servers    i   host      127 0 0 1   change it to  cfg  Servers    i   host      localhost   save the file restart all services in wamp   The problem seems to be that someone forgot to make the server and host match in the configuration files

User · Answer

reset your mysql password on xampp security page  restart your mysql service and then access the phpmyadmin page using your password  i tried it  this is working fine for me

User · Answer

On OSX  I had same difficult  but a figure out a solucition  open terminal  put  cd  Applications XAMPP xamppfiles  put  sudo   xampp security    then put your root password and answer the questions

User · Answer

Try this   1  xampp htdocs xampp cds php  change line 4 to  mysql connect  localhost   root   enter password here    change line 64 to  if  mysql connect  localhost   root   enter password here      From here

User · Answer

I had this same problem after I dropped the special PhpMyAdmin controluser account from MySQL   I had to update the config inc php file and replace the entries for  controluser  and controlpass  with  user  and  password    So my file ended like this    cfg  Servers    i   user      root    cfg  Servers    i   password    123456

User · Answer

Try this    Open config inc php file in the phpmyadmin directory  Find line 21   cfg  Servers    i   password         Change it to   cfg  Servers    i   password      your password   Restart XAMPP   Reference

User · Answer

My ini from the file  password and  bind-address  127 0 0 1  are commented change the password to root and uncomment bind-address  127 0 0 1     and from the file cds php  change the   mysql connect  localhost    root        to mysql connect  localhost    root    root      Stop the Mysql services and try login again it got logged in

User · Answer

Go to the file C  wamp apps phpmyadmin3 2 0 1 config inc php     Find the line  cfg  Servers    i   password      and change it to   cfg  Servers    i   password    root    where root is the name of the password you had set in this instance  Hope this helps somebody

User · Answer

Step one  Go to    C  xampp phpMyAdmin  Step Two  Open the config inc php file  Step Three  Locate the following information and change the password      Authentication type and info     cfg  Servers    i   auth type      config    cfg  Servers    i   user      ENTER YOUR USER NAME HERE    cfg  Servers    i   password      ENTER YOUR PASS HERE    cfg  Servers    i   extension      mysqli    cfg  Servers    i   AllowNoPassword     true   cfg  Lang

User · Answer

I m afraid there s a conflict with the port number 80   Make sure you don t run some software like Skype that use the same port 80

User · Answer

try to go to Windows services and stop the MySQL service go to your wamp server and click on  restart all services   Refrsch your browser

User · Answer

If you are using XAMPP rather than WAMP  the path you go to is   C  xampp phpMyAdmin config inc php

User · Answer

Open the config inc php file in the WAMP phpmyadmin directory Change the line   Servers    i   password        to    cfg  Servers    i   password      your mysql root password   Clear browser cookies  Then Restart all services on WAMP    This worked for me    NB  the password to use has to be the MySQL password

User · Answer

1045 - Access denied for user  root   localhost   using password  NO  solution   Step 1  Open Location of you wamp xampp  Step 2  Go to phpmyadmin Step 3  Open config inc php Step 4  Change the password to the password set for the MySql server and not  anything else in this   cfg  Servers    i   password        Step 5  Restart all services  restart wamp xampp

User · Answer

I m using Linux Mint 18 2 of this writing  I had a similar issue  when trying to load myphpadmin  it said   1045 - Access denied for user  root   localhost   using password  NO     I found the file in the  opt lampp phpmyadmin directory  I opened the config inc php file with my text editor and typed in the correct password  Saved it  and launched it successfully  Profit   I was having problems with modifying folders and files  I had to change permission to access all my files in  opt lampp  directory  I hope this helps someone in the future

User · Answer

I had this problem after changing the password for the root user in phpMyAdmin   I know nothing about programming but I solved it by doing the following    Go to file C  wamp apps phpmyadmin3 2 0 1 config inc php  I guess you would replace  wamp  with the name of your server if you re not using Wamp Server  Find the line  cfg  Servers    i   password      and change this to   cfg  Servers    i   password    NO   Try opening phpMyAdmin again  and hopefully the message will now read  Access denied for user  root   localhost   using password  YES  Now change the password in the above line to  yourpassword   whatever you had set it to before    Hope this helps somebody

[mysql] MySQL said: Documentation #1045 - Access denied for user 'root'@'localhost' (using password: NO)

Examples related to mysql

Examples related to phpmyadmin

Examples related to xampp

Examples related to mysql-error-1045