MySql ERROR 1045 28000 Access denied for user root localhost using password NO

Question

I ve tried multiple solutions from StackOverflow but haven t had any success   I m on Mac OSX  Sierra 10 12 3  trying to create a new database and user   From terminal I enter   mysql -u root   which outputs this error      ERROR 1045  28000   Access denied for user  root   localhost   using password  NO    To try and resolve it I stopped mysql from  System Preferences   then from terminal typed   sudo mysqld safe    skip-grant-tables   I opened a second tab and entered   mysql -u root   Then from in mysql   update mysql user set password expired    N   authentication string PASSWORD  newpassword   where user    root    flush privileges    I then restart the computer  killing the process with CMD   C doesn t work    After restarting  trying mysql -u root still produces the same error   I am able to access mysql via a MySQL client and a non-root user   Any help is appreciated

User · Answer

For security reason mysql -u root wont work untill you pass -p in command so try with below way   mysql -u root -p Enter     enter your localhost password

User · Answer

In my case  I needed to Edit Inbound Rules on my AWS RDS instance to accept All Traffic  The default TCP IP constraint prevented me from creating a database from my local machine otherwise

User · Answer

You must run your mysql by xampp-controle exe in folder XAMPP  After that login   mysql -u root

User · Answer

Comment by  Niagaradad helped me  I was entering the wrong password the whole time    Notice the error message      ERROR 1045  28000   Access denied for user  ayaz   localhost   using password  YES    It says  Password  Yes  That means I am sending the password to SQL and that is wrong    Usually root account doesn t have password if you haven t set one  If you have installed mysql via homebrew then root account won t have a password    Here is the comment       so  not exactly the same then  NO means you are not sending a password to MySQL  YES means you are sending a password to MySQL but the incorrect one  Did you specifically set a password for the mysql root user when you installed MySQL  By default there is no password so you can use mysql -u root -p and hit enter

User · Answer

just use     sudo mysql   without the  -u root  parameter

User · Answer

Try this  on Windows  i don t know how in others   if you have changed password a now don t work   1  kill mysql 2  back up  mysql data folder 3  go to folder  mysql backup 4  copy files from  mysql backup mysql folder to  mysql data mysql  rewrite  5  run mysql  In my XAMPP on Win7 it works

User · Answer

mysql -u root -p    And mysql will ask for the password

User · Answer

If you need to skip the password prompt for some reason  you can input the password in the command  Dangerous   mysql -u root --password secret

User · Answer

Just to confirm  You are sure you are running MySQL 5 7  and not MySQL 5 6 or earlier version  And the plugin column contains  mysql native password    Before MySQL 5 7  the password hash was stored in a column named password  Starting in MySQL 5 7  the password column is removed  and the password has is stored in the authentication string column   And you ve also verified the contents of authentication string matches the return from PASSWORD  mysecret    Also  is there a reason we are using DML against the mysql user table instead of using the SET PASSWORD FOR syntax         spencer7593    So Basically Just make sure that the Plugin Column contains  mysql native password      Not my work but I read comments and noticed that this was stated as the answer but was not posted as a possible answer yet

User · Answer

Is it possible the root password is not what you think it is  Have you checked the file  root  mysql secret for the password  That is the default location for the automated root password that is generated from starting from version 5 7    cat  root  mysql secret

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

Examples related to mysql