Access denied for user root localhost using password NO

Question

I m trying to set the password of the user root but I m gettin the error below  any idea    ----------------------------------------------------------------------------------------------------------------------------------------    Grants for root localhost                                                                                                                 ----------------------------------------------------------------------------------------------------------------------------------------    GRANT ALL PRIVILEGES ON     TO  root   localhost  IDENTIFIED BY PASSWORD   436576511F70A4E3B305E1AB8E209851945D8687  WITH GRANT OPTION    ----------------------------------------------------------------------------------------------------------------------------------------  1 row in set  0 00 sec    mysql gt  exit Bye root tirengarfio  var www rs2  mysqladmin -u root password foo  mysqladmin  connect to server at  localhost  failed error   Access denied for user  root   localhost   using password  NO

User · Answer

For some information I ve get error after changing password   Access denied for user  root   localhost   using password  NO  Access denied for user  root   localhost   using password  YES   In both cases there was error  But the thing is after that I ve tried it with mysql -uroot -ppassword instead of mysql -u root -p password - gt  with spaces between -uroot and -ppassword so maybe if someone get trouble can try this way

User · Answer

Firstly  go to the folder support-files on terminal  and start the server by mysql server start  Secondly  go to the folder bin on terminal or type   usr local mysql bin mysqladmin -u root -p password  It would ask you for the old temporary password which was given to you while installing Mysql  type that and type in your new password and it would work

User · Answer

mysqladmin -u root -p password Enter password   New password   Confirm new password    password is to be typed literally  It s a command  You don t have to substitute password with your actual password

User · Answer

If you are using XAMPP just go to C  xampp phpMyAdmin and then open config inc php find  cfg  Servers    i   password        line and put your password there

User · Answer

You can reset your root password  Have in mind that it is not advisable to use root without password

User · Answer

Another solution if someone gets the error The specified password for user account    root    is not valid  or failed to connect to the database server also with the right password  is the follow     In the Windows registry  delete the mysql pwd reg key under HKCU Software Microsoft WebPlatformInstaller     Unistall older version of MySQL  NET connector     Download and install the latest MySql  NET Connector

User · Answer

I was getting the same error on OS X El captain   Mysql version 5 7   I was able to connect to mysql with root after executing these steps   Stop the mysql server  sudo mysql server stop   Start mysql in safe mode  sudo mysqld safe --skip-grant-tables   Using mysqld  Change the database to mysql and update the details for user  root    show databases  use mysql  UPDATE mysql user      SET authentication string   PASSWORD  MyNewPass    password expired    N      WHERE User    root  AND Host    localhost   exit    After that kill the  mysqld safe  process and start mysql normally  You should be able to login to mysql using root and new password  SQL docs for more details

User · Answer

Make sure the MySQL service is running on your machine  then follow the instructions from MySQL for initially setting up root  search for  windows  and it will take you to the steps for setting up root    http   dev mysql com doc refman 5 1 en default-privileges html

User · Answer

Set Change password   mysqladmin -u root -p password   Login to MySQL console   mysql -u root -p   To exit the console     q

User · Answer

Simply edit my ini file in C  xampp mysql bin path  Just add   skip-grant-tables   line in between lines of   The MySQL server  mysqld  and port 3306  Then restart the MySQL server    Looks like

User · Answer

Use mysql -u root -p  It will ask for password  insert password and enter

User · Answer

This is basically a more detailed version of a previous answer    In your Terminal  go to the location of your utility program  mysqladmin  For example  if you were doing local development and using an application like M W XAMP  you might go to the directory      Applications MAMP Library bin  This is where mysqladmin resides    If you re not using an application like MAMP  you may also be able to find your local installation of mysql at   usr local mysql  And then if you go to   usr local mysql bin   You are in the directory where mysqladmin resides   Then  to change the password  you will do the following     At your Terminal prompt enter the exact command below  aka copy and paste  and press enter  The word  password  is part of the command  so don t be confused and come to the conclusion that you need to replace this word with some password you created previously or want to use in the future  You will have a chance to enter a new password soon enough  but it s not in this first command that you will do that        mysqladmin -u root -p password The Terminal will ask you to enter your original or initial password  not a new one yet  From the above image you provided  it looks like you have one already created  so enter it here     Enter password  oldpassword   The Terminal will ask you to enter a new password  Type it here and press enter    New password  newpassword   Then the Terminal will ask you to confirm the new password  Type it here and press enter     Confirm new password  newpassword  Reset or restart your Terminal     In some cases  as with M W XAMP  you will have to update this new password in various files in order to get your application running properly again

User · Answer

Those are all good answers  but don t quite touch the deep cause of the problem one most likely has if faced with the OP question  That is  not knowing the ORIGINAL  starting  password created during the installation time   And all these command lines with  -u root      etc  imply knowing and using THAT password   Now this part from the original installation message may help anyone facing the problem above   Initial password for first time use of MySQL is saved in  HOME  mysql secret ie  when you want to use  mysql -u root -p  first you should see password in  root  mysql secret

User · Answer

for this kind of error  you just have to set new password to the root user as an admin  follow the steps as follows    root     mysql -u root ERROR 1045  28000   Access denied for user  root   localhost   using password NO     Stop the service daemon of mysql running     root     service mysql stop    mysql stop waiting  Start mysql without any privileges using the following option  This option is used to boot up and do not use the privilege system of MySQL    root     mysqld safe --skip-grant-tables  amp     At this moment  the terminal will seem to halt  Let that be  and use new terminal for next steps    enter the mysql command prompt       root     mysql -u root mysql gt    Fix the permission setting of the root user    mysql gt  use mysql  Database changed mysql gt  select   from  user  Empty set  0 00 sec  mysql gt  truncate table user  Query OK  0 rows affected  0 00 sec  mysql gt  flush privileges  Query OK  0 rows affected  0 01 sec  mysql gt  grant all privileges on     to root localhost identified by  YourNewPassword  with grant option  Query OK  0 rows affected  0 01 sec      if you don t want any password or rather an empty password       mysql gt  grant all privileges on     to root localhost identified by    with grant option      Query OK  0 rows affected  0 01 sec       mysql gt  flush privileges      Query OK  0 rows affected  0 00 sec    Confirm the results       mysql gt  select host  user from user   ----------- ------    host        user    ----------- ------    localhost   root    ----------- ------  1 row in set  0 00 sec     Exit the shell and restart mysql in normal mode   mysql gt  quit   root     kill -KILL  PID of mysqld safe   root     kill -KILL  PID of mysqld   root     service mysql start  Now you can successfully login as root user with the password you set     root     mysql -u root -pYourNewPassword   mysql gt

User · Answer

open my cnf using following path      C  xampp mysql bin    under   The following options will be passed to all MySQL clients  password remove   comment sign if it is there password    newpassword  save file  close file re-start mysql

User · Answer

Some times it just happens due to installation of Wamp or changing of password options of root user  One can use privilages-- root  user  and then set password option to NO to run the things without any password OR set the password and use it in the application

User · Answer

For MySQL 5 7  These are the below steps    Stop your MySQL server completely  This can be done by accessing the Services window inside Windows XP and Windows Server 2003  where you can stop the MySQL service   Open your MS-DOS command prompt using  cmd  inside the Run window  Inside it navigate to your MySQL bin folder  such as C  MySQL bin using the cd command   Execute the following command in the command prompt  mysqld exe -u root --skip-grant-tables  Leave the current MS-DOS command prompt as it is  and open a new MS-DOS command prompt window   Navigate to your MySQL bin folder  such as C  MySQL bin using the cd command   Enter mysql and press enter   You should now have the MySQL command prompt working  Type use mysql  so that we switch to the  mysql  database   Execute the following command to update the password   update user set authentication string password  1111   where user  root

User · Answer

mysqladmin -u root -p password   enter your current password  then   enter your new password

User · Answer

In your code replace the  root  with your Server username and password with your server password  For example if you have DB and your php files on the server http   www example com then obviously you would have to enter into this server site using your username and password

User · Answer

etc init d mysqld stop  Stopping MySQL    OK      mysqld safe --skip-grant-tables  amp    1  13694    Starting mysqld daemon with databases from  var lib mysql      mysql -u root  Welcome to the MySQL monitor  Commands end with   or  g   Your MySQL connection id is 1  Server version  5 0 77 Source distribution    Type  help   or   h  for help  Type   c  to clear the buffer     mysql gt

User · Answer

Change the password from config inc php present in C  xampp phpMyAdmin  Type mysql -u root -p in the command prompt  You will be asked to enter the password  Enter that password which you updated in the config inc php

User · Answer

1  You can set root password by invoking MySQL console  It is located in  C  wamp bin mysql mysql5 1 53 bin by default    Get to the directory and type MySQL  then set the password as follows         gt  SET PASSWORD FOR root localhost   PASSWORD  new-password      2  You can configure wamp s phpmyadmin application for root user by editing   C  wamp apps phpmyadmin3 3 9 config inc php    Note  - if you are using xampp then   file will be located at   C  xampp phpMyadmin config inc php   It looks like this            cfg  Servers    i   verbose      localhost            cfg  Servers    i   host      localhost            cfg  Servers    i   port                  cfg  Servers    i   socket                  cfg  Servers    i   connect type      tcp            cfg  Servers    i   extension      mysqli            cfg  Servers    i   auth type      config            cfg  Servers    i   user      root            cfg  Servers    i   password      YOURPASSWORD            cfg  Servers    i   AllowNoPassword     false    The error  Access denied for user  root localhost   using password NO   will be resolved when you set  cfg  Servers    i   AllowNoPassword   to  false  If you priviously changed the password for  root localhost   then you have to do 2 things to solve the error  Access denided for user  root localhost      if   password   have a empty quotes like     then put your password between quotes  change the  using password NO  to  using password YES    This will resolve the error   Note  phpmyadmin is a separate tool which comes with wamp   It just provide a interface to MySQL  if you change my sql root s password  then you should change the phpmyadmin configurations  Usually phpmyadmin is configured to root user

User · Answer

when trying to run this command i got the same error   sudo mysqladmin create asteriskcdrdba   i simply add a few lines to the code  -u root -p   and pressed the enter key  i then typed my password and hit enter  Linux liked my command as nothing more was displayed  so maybe try   sudo  lt your command here gt  -u  lt username gt  -p   after that hit enter and enter your password

User · Answer

if you changed the port to non standard one  then you need to specify it    connection   mysqli connect  localhost 3308    root        loginapp

[mysql] 'Access denied for user 'root'@'localhost' (using password: NO)'

Examples related to mysql