Solved : ERROR 1698 (28000): Access denied for user ‘root’@’localhost’

How to Fix error for MySQL 5.7 with Ubuntu 18.04 : ERROR 1698 (28000): Access denied for user ‘root’@’localhost’

In Ubuntu systems running MySQL 5.7 (and later), the root user is authenticated by the auth_socket plugin by default.

$ sudo mysql #No Username to be the provide
mysql> USE mysql;
mysql> SELECT User, Host, plugin FROM mysql.user;

+------------------+-----------+-----------------------+
| User             | Host      | plugin                |
+------------------+-----------+-----------------------+
| root             | localhost | auth_socket           |
| mysql.session    | localhost | mysql_native_password |
| mysql.sys        | localhost | mysql_native_password |
| debian-sys-maint | localhost | mysql_native_password |
+------------------+-----------+-----------------------+

mysql> update user set plugin='mysql_native_password' where user='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;
$ service mysql restart

Comments

Post a Comment

Popular posts from this blog

To install the mysql driver manually in Dbeaver

Image
Go to https://mvnrepository.com/artifact/mysql/mysql-connector-java and choose the version we want in my case I will take version 5.1.47 this is the direct link to download http://central.maven.org/maven2/mysql/mysql-connector-java/5.1.47/mysql-connector-java-5.1.47.jar I also leave the following image so that you can see where you can download it. Then we save the driver in the directory easy to find.
Read more

How to Install Latest MySQL Server on AWS EC2 Ubuntu 18.04

Install MySQL Server To install the MySQL server, you must update your Linux packages system first, type: sudo apt update Then install the MySQL Server package: sudo apt-get install mysql-server MySQL prompt asking you to proceed install, then type: Y Set Password on Root User Please note that the MySQL root user is unsecured you need to provide a secure password for the root user once you deployed on production. To do this, run this command on your terminal: $ sudo mysql Next, we need to check which authentication method of each MySQL user, type command: mysql> SELECT user,authentication_string,plugin,host FROM mysql.user; You can see that the root user doesn’t have authentication_string using the auth_socket plugin. To configure the root account to authenticate with a password, run the following ALTER USER command: mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password' ; Please note, make sure...
Read more

Can't connect to Remote MySQL Server (10061) to Ubuntu

STEP 1: To allow remote access to MySQL, you have to comment out bind-address (you did) and skip-networking in the configuration file. Next, you have to make sure the user is allowed remote access. Check your user with this: SELECT User , Host FROM mysql . user ; If your user here has '127.0.0.1' or 'localhost' listed as host, you don't have remote access. Change this with: UPDATE mysql . user SET HOST = '%' WHERE User = '__here_your_username' ; Flush privileges: FLUSH PRIVILEGES ; The '%' is a wildcard for 'all hosts'. STEP 2: To Allow remote access to MySQL installed on a Ubuntu, you will have to access the file at this location: / etc / mysql / mysql . conf . d / mysqld . cnf There, you comment out the following line: bind-address = 127.0.0.1 basically to change: bind-address = 127.0.0.1 to: #bind-address = 127.0.0.1 Now you either restart the computer or just the mySQL service using the follwing...
Read more