1045 - Access denied for user root localhost using password YES

Question

This might seem redundant but I was unable to find a correct solution   I was unable to login to mysql using the mysql console It is asking for a password and I have no clue what I actually entered  Is there a way to get the password or change it   This is how my config inc look   When I try to open phpmyadmin I get this error  1045 - Access denied for user  root   localhost   using password  YES     lt  php     Servers configuration     i   0      Server  localhost  1      i     cfg  Servers    i   verbose      localhost    cfg  Servers    i   host      localhost    cfg  Servers    i   port      3306    cfg  Servers    i   socket          cfg  Servers    i   connect type      tcp    cfg  Servers    i   extension      mysqli     cfg  Servers    i   auth type      cookie    cfg  Servers    i   user      root    cfg  Servers    i   password      prakash123    cfg  Servers    i   AllowNoPassword     true      End of servers configuration      cfg  DefaultLang      en-utf-8    cfg  ServerDefault     1   cfg  UploadDir          cfg  SaveDir              rajk - for blobstreaming     cfg  Servers    i   bs garbage threshold     50   cfg  Servers    i   bs repository threshold      32M    cfg  Servers    i   bs temp blob timeout     600   cfg  Servers    i   bs temp log threshold      32M       gt    I have tried to uninstall  Plus Deleted all the related files   WAMP and reinstall It didn t help either  While reinstalling WAMP server it is not asking for any username password stuff I don t know why  Any help is highly appreciated

User · Answer

Try the following code    cfg  Servers    i   password           if you see Password column field as  No  for the  root  user in Users Overview page of  phpMyAdmin

User · Answer

Go to  config inc php   Write your password over here -  cfg  Servers    i   password

User · Answer

after installation i started wamp and i was asked for user and pass which were already set on default  user admin pass  dots   and that was wrong with a message from your topic  Than  i just entered   Username  root  Password   leave it empty    and it worked for me

User · Answer

This process is quite simple in correcting the the error  What is happening is a failure to connect to phpMyAdmin  In order to fix the problem you simply need to provide the correct password to the system phpMyAdmin configuration file located in apps phpMyadmin config ini php 1  the root should already be set as user 2  Insert the password between     and that it   If you still have problems then this means that the user name and  or the password need to be updated or inserted into the DB  to do this use the command line tool and do an update   UPDATE mysql user SET Password PASSWORD  Johnny59 or whatever you want to use   WHERE User  root

User · Answer

Well  there are many solutions already given above  If there are none of them works  maybe you should just try to reset your password again to  root  as described here  and then reopen http   localhost phpMyAdmin  in other browser  At least this solution works for me

User · Answer

I had the same error today  I had installed Djangostack and when I checked my task manager there were two instances of mysqld running  I checked one was for wamp server and the other was for django stack  I ended the one for django stack  restarted all services in wamp server and I was able to access phpmyadmin

User · Answer

mysql exe- Run as administrator or go to following path C  wamp bin mysql mysql5 5 24 bin and than right click on mysql exe go to properties and than select tab as Compatibility and see the bottom of dialog box in privilege level and just check the Run this program as an administrator and then click apply ok finished now you open success phpMyadmin  bye

User · Answer

The problem was I have 2 instances of Mysql installed and I didn t know the password for both instances Just check if port 80 is used by any of the programs  This is what I did  1 Quit Skype because it was using port 80  Please check if port 80 is used by any other program    2 Search for Mysql services in task manager and stop it   3 Now delete all the related mysql files Make sure you delete all the files   4 Reinstall

User · Answer

This worked for me  In your config file   cfg  Servers     i    password      yourpassword     In your mysql shell  login as root  mysql -u root   change your password or update if you ve forgotten the old one  UPDATE mysql user SET Password PASSWORD  yourpassword   WHERE User  root     stop and restart your mysql server from the xampp control panel  phpmyadmin can login to see your databases

User · Answer

In the my ini file in C  xampp mysql bin  add the following line after the  mysqld  command under  Mysql Server   skip-grant-tables   This should remove the error 1045

User · Answer

Go to C  xampp phpMyAdmin Edit the config inc php file Replace  cfg  Servers    i   auth type      config   by  cfg  Servers    i   auth type      cookie     For now on the PHPMyAdmin will ask you for your password  no more error

User · Answer

If you arrived here because you can t log into your phpMyAdmin  then try the root password from your Mysql instead of the password you put during phpMyAdmin installation

User · Answer

I first changed the root password running mysql at a prompt with   mysql -u root -p   Update password    UPDATE mysql user SET Password PASSWORD  MyNewPass   WHERE User  root     Edited line in the file config inc php with the new root password    cfg  Servers    i   password      MyNewPass    Stop and re-start mysql service  in Windows  mysql stop bat mysql start bat   and got phpMyAdmin to work   EDIT 2017  for MySQL 5 7 use authentication string in place of  Password  see this answer     UPDATE mysql user SET authentication string PASSWORD  MyNewPass   WHERE User  root

User · Answer

I have encountered similar mistakes  and later found that my password is wrong

User · Answer

For UNIX  try this  It worked for me    connect MySQL use Navicat Premium with inital root  password  UPDATE mysql user     SET authentication string   PASSWORD  MyNewPass    password expired    N      WHERE User    root  AND Host    localhost   FLUSH PRIVILEGES  restart MySQL

User · Answer

Go to config inc php  find  cfg  Servers    i   password   and remove any password provided  i e change  cfg  Servers    i   password      password   with  cfg  Servers    i   password          Now you can launch phpMyAdmin  Selecting Users menu from phpMyAdmin  select the root user and click Edit previlidges  Now scroll down to Change Password area  switch between No Password and Password to provide your new password  that s it

User · Answer

mysql -u root -p UPDATE mysql user SET Password PASSWORD  mypass   WHERE User  root   Flush the privileges  FLUSH PRIVILEGES  Exit by typing  Exit Edited line in the file config inc php with the new root password   cfg  Servers    i   password      mypass  be succss

User · Answer

with MariaDb  above solutions doesn t works   Use  exemple below with ubuntu 16 04 and mariadb-server Distrib 10 0 28        sudo mysql secure installation             Change the root password   Y n       New password

User · Answer

After I updated my MySql  I was getting the same error message  It turned out that after installing a different version on MySql  inside the my ini  the port was different  Previous MySql version had port 3306 but the new one have port 3308  Check your MySql my ini  if it is different use the port from  ini in your connection

User · Answer

if multiple myslq running on same port no  enter image description here  Right click on wamp  and test port 3306 if its wampmysqld64  its correct else change port no and restart server

User · Answer

php artisan serve    this command get the env contents for the first time and if you update  env file need to restart it   in my case my username and dbname is valid and php artisan migrate worked  but need to cntrl c   to cancel php artisan serve   and run it again  php artisan serve

User · Answer

First you have to go config inc php file then change the following instruction   cfg  Servers    i   user         cfg  Servers    i   password           or

User · Answer

Just now I have this situation and I have tried this way which is very easy   First stop your mysql service using this command   service mysql stop   and then just again start your mysql service using this command   service mysql start   I hope it may help others

[mysql] #1045 - Access denied for user 'root'@'localhost' (using password: YES)

Examples related to mysql

Examples related to phpmyadmin

Examples related to localhost

Examples related to port

Examples related to wamp