MySQL Error: 'Access denied for user 'root'@'localhost'

Dung Do Tien Jun 29 2021 306

I have a project using Php 7 and MySql and deploy in Ubuntu 20.04. I just installed MySql successful but when I run the command:

 $ ./mysqladmin -u root -p 'redacted'

I get an error:

mysqladmin: connect to server at 'localhost' failed error:
'Access denied for user 'root'@'localhost' (using password: YES)'

How can I fix it?

Have 2 answer(s) found.
  • M

    Minh Yến Jun 29 2021

    You can resolve your issue by following some steps below:

    1. Open & Edit /etc/my.cnf or /etc/mysql/my.cnf, depending on your distro.
    2. Add skip-grant-tables under [mysqld]
    3. Restart Mysql
    4. You should be able to login to mysql now using the below command mysql -u root -p
    5. Run mysql> flush privileges;
    6. Set new password by ALTER USER 'root'@'localhost' IDENTIFIED BY 'NewPassword';
    7. Go back to /etc/my.cnf and remove/comment skip-grant-tables
    8. Restart Mysql
    9. Now you will be able to login with the new password mysql -u root -p

     I hope it works for you!

  • M

    Mary Christ Jun 29 2021

    Maybe You have to reset your root password. Have in mind that it is not advisable to use root without a password.

    To reset the password for MySql you can refer to this article https://dev.mysql.com/doc/refman/8.0/en/resetting-permissions.html

Related Q&A May You Like

  1. MySql throw no database selected, select the default DB to be used by double-clicking its name
  2. How to generate whole sql database script in MySql Workbench
  3. Error querySrv ENODATA _mongodb._tcp.456d in MongoDB Compass
  4. What is best way to convert datetime to date in Sql Server?
  5. How to compare date without time with now() in PostgreSQL?
  6. MySQL Error Code: 1175. safe update mode update a table without a WHERE
  7. ERROR 1819 (HY000): Your password does not satisfy the current policy requirements in MySQL
  8. ERROR: column must appear in the GROUP BY clause or be used in an aggregate function in PostgreSQL
  9. Calculating distance between two positions(lat, long) in SQL Server
  10. Error: /opt/lampp/bin/mysql.server: 264: kill: No such process
  11. How to get the total of current connection in PostgreSQL?
  12. How to backup and restore MSSQL Server database in Ubuntu
  13. ERROR: OFFSET must not be negative in PostgreSQL
  14. How to update top N records for a table in PostgreSQL?
  15. PostgreSQL Error: Terminating connection due to administrator command
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close