Posts

Showing posts with the label root

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 | +------------------+-----------+----...