Home / ubuntu / Questions / 1029177
Accepted
Ashrafuzzaman Sujan
Asked: 2018-04-29 03:15:06 +0800 CST

ERROR 1698 (28000): Access denied for user 'root'@'localhost' at Ubuntu 18.04

  • 772

I have followed this tutorial to install MySQL but after successfully installed MySQL, I could not access database.

ERROR 1698 (28000): Access denied for user 'root'@'localhost'

permissions mysql lamp

2 Answers

  1. Best Answer

    I found a solution at here link, by following this solution I have solved my problem.

    Short steps are:

    sudo mysql -u root
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'test';

    Note: here test is a new password for the root user. Also, remember to run the command sudo service mysql restart after altering the user.

    • 79

  2. I found another way that is much better as we need not to give any password for local system.
    It is as followed.

    Open terminal and type 

    sudo mysql -u root -p

    It will prompt you in mysql, here you can fire any mysql commands.

    Use mysql table for change table type, so we can use empty password. Bellow is command for it

    USE mysql;

    Now we change type of table by following command

    UPDATE user SET plugin='mysql_native_password' WHERE User='root';

    now we have to flush the privileges, because we have used UPDATE. If you use INSERT, UPDATE or DELETE on grant tables directly you need use FLUSH PRIVILEGES in order to reload the grant tables. 

    FLUSH PRIVILEGES;

    now exit from mysql by following command

    exit;

    now restart mysql server by following command

    service mysql restart

    Hope this may help

    Thank you.

    • 26