Error 1045 - Cannot Log in to MySQL server - phpmyadmin

Question

We have installed PHPMyAdmin on a windows machine running IIS 7 0  We are able to connect to MySQL using command-line  But we are not able to connect using PHPMyAdmin  The error displayed is  Error  1045 Cannot log in to the MySQL server  Can somebody please help    PHP Version 5 4 0 mysqlnd 5 0 10 - 20111026 -  Revision  323634   phpMyAdmin-3 5 4-rc1-all-languages 7z    EDIT   I followed the link below with no success  mean i changed that password but phpmyadmin still has that error    C 5 4 1 1  Resetting the Root Password  Windows Systems    Also there is thread like below in stack with no help   Random error   1045 Cannot log in to the MySQL server but that error is not random -  i always have that error       And this is config inc php file in phpmyadmin folder       lt  php    vim  set expandtab sw 4 ts 4 sts 4            Config file view and save screen        package PhpMyAdmin-setup      if   defined  PHPMYADMIN          exit            Core libraries      require once    libraries config FormDisplay class php   require once    setup lib index lib php   require once    setup lib ConfigGenerator class php     config readable   false   config writable   false   config exists   false  check config rw  config readable   config writable   config exists     gt   lt h2 gt  lt  php echo     Configuration file     gt  lt  h2 gt   lt  php display form top  config php      gt   lt input type  hidden  name  eol  value   lt  php echo htmlspecialchars PMA ifSetOr   GET  eol     unix      gt     gt   lt  php display fieldset top         null  array  class    gt   simple       gt   lt tr gt       lt td gt           lt textarea cols  50  rows  20  name  textconfig  id  textconfig  spellcheck  false  gt  lt  php             echo htmlspecialchars ConfigGenerator  getConfigFile              gt  lt  textarea gt       lt  td gt   lt  tr gt   lt tr gt       lt td class  lastrow  style  text-align  left  gt           lt input type  submit  name  submit download  value   lt  php echo     Download     gt   class  green    gt           lt input type  submit  name  submit save  value   lt  php echo     Save     gt   lt  php if    config writable  echo   disabled  disabled     gt    gt       lt  td gt   lt  tr gt   lt  php display fieldset bottom simple    display form bottom      gt    where part of these codes should i change     Thanks

User · Answer

For ubuntu users  your config inc php file should be like this     Authentication type     cfg  Servers    i   auth type      cookie    cfg  Servers    i   user      username    cfg  Servers    i   password      password      Server parameters     cfg  Servers    i   host      127 0 0 1    cfg  Servers    i   connect type      tcp    cfg  Servers    i   compress     false   cfg  Servers    i   AllowNoPassword     false         phpMyAdmin configuration storage settings         User used to manipulate with storage        cfg  Servers    i   controlhost             cfg  Servers    i   controlport             cfg  Servers    i   controluser      pma       cfg  Servers    i   controlpass

User · Answer

a number  of answers  check out this one also  make sure that no instance of mysql is  running  always brought by not ending your sessions well  get the super user rights with      sudo su   and type your password when prompted to  remember nothing appears when you type your password  so  don t worry just type it and press enter   Next go to your terminal and stop all mysql instances     etc init d mysql stop  after that  go and restart the mysql services  or restart xampp as a whole   This solved my problem  All the best

User · Answer

another thing that worked for me after everything didn t - change  localhost  in config inc php to 127 0 0 1

User · Answer

If you logged into  phpmyadmin   then logged out  you might have trouble attempting to log back in on the same browser window   The logout sends the browser to a URL that looks like this   http   localhost phpmyadmin index php db  amp token 354a350abed02588e4b59f44217826fd amp old usr tester   But for me  on Mac OS X in Safari browser  that URL just doesn t want to work   Therefore  I have to put in the clean URL   http   localhost phpmyadmin   Don t know why  but as of today  Oct 20  2015  that is what I am experiencing

User · Answer

You need to do two additional things after following the link that you have mentioned in your post   One have to map the changed login cridentials in phpmyadmin s config inc php  and second  you need to restart your web and mysql servers    php version is not the issue here  you need to go to phpmyadmin installation directory and find file config inc php and in that file put your current mysql password at line    cfg  Servers    i   user      root     mysql username here  cfg  Servers    i   password      password     mysql password here

User · Answer

In Linux I resolve this problem by going to the root command prompt type     mysqladmin -u root password  Secret Phrase Here    Then go back and login   Works every time

User · Answer

In mysql 5 7 the auth mechanism changed  documentation can be found in the official manual here   Using the system root user  or sudo  you can connect to the mysql database with the mysql  root  user via CLI   All other users will work  too   In phpmyadmin however  all mysql users will work  but not the mysql  root  user   This comes from here     mysql -Ne  select Host User plugin from mysql user where user  root     ----------- ------ -----------------------    localhost   root   auth socket      hostname   root   mysql native password    ----------- ------ -----------------------    To  fix  this security feature  do   mysql -Ne  update mysql user set plugin  mysql native password  where User  root  and Host  localhost   flush privileges     More on this can also be found here in the manual

User · Answer

If you are installing first time then please try login with username and password as root

User · Answer

sudo service mysql stop     sudo mysqld --skip-grant-tables  amp      mysql -u root mysql     Change MYSECRET with your new root password  UPDATE user SET Password PASSWORD  MYSECRET   WHERE User  root   FLUSH PRIVILEGES  exit

User · Answer

When you change your passwords in the security tab  there are two sections  one above and one below  I think the common mistake here is that others try to log-in with the account they have set  below  the one used for htaccess  whereas they should log in to the password they set on the above section  That s how I fixed mine

[mysql] Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin

Examples related to mysql

Examples related to passwords

Examples related to phpmyadmin

Examples related to windows-server-2008-r2

[mysql] Error # 1045 - Cannot Log in to MySQL server -> phpmyadmin

Examples related to mysql

Examples related to login

Examples related to passwords

Examples related to phpmyadmin

Examples related to windows-server-2008-r2