How remove or reset mysql password!

Question

I test all the suggested answers but still I canon't reset or remove password or even reinstall the mysql db on Ubuntu 16.04, Is there any ohter idea?

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

Tested all suggested answers? Could you be more specific and post what you tried so far? — Marc Vanhoomissen, Mar 12 '18 at 19:59

score 0 · Answer 1 · answered Jul 31 '18 at 04:56

0

Open your terminal
sudo mysql -u root
use mysql;
SELECT user, plugin FROM user;
UPDATE user SET plugin = "mysql_native_password" WHERE user = "root" ;
SELECT user, plugin FROM user;
exit
service mysql restart

answered Jul 31 '18 at 04:56

Puujee.Ts

11

You cant use sudo mysql -u root when you dont have the password – Ali Sep 12 '21 at 17:37

Kotler · Answer 2 · 2023-02-07T06:45:37.833

Have you can update new for the MySQL root password on Ubuntu Linux. Enter the following lines below:

1. Stop the MySQL Server: sudo /etc/init.d/mysql stop
2. Start the mysqld configuration: sudo mysqld --skip-grant-tables &
3. Login to MySQL as root: mysql -u root mysql
4. Replace "newpassword" with your new password:
UPDATE
  mysql.user
SET
  Password = PASSWORD('newpassword')
WHERE
  User = 'root';
FLUSH PRIVILEGES;
exit;

Note: on some versions, if password column doesn't exist, you may want to try:
UPDATE user SET authentication_string=password('newpassword') WHERE user='root';

After changed pass success. however, it works.

References:

How remove or reset mysql password!

2 Answers2