0

I cant login into mysql, already did multiple tries on mysql_secure_installation.

Tried changing the password directly from the mysql.user table like this: https://linuxize.com/post/how-to-manage-mysql-databases-and-users-from-the-command-line/

Already tried removing the password plugin: How do I turn off the mysql password validation? Still didnt let me login...

Removed the password plugin, then did the mysql_secure_installation ERROR 1698 (28000): Access denied for user 'root'@'localhost'

Info: Mysql was installed on apt, already tried purging and installing again Server version: 5.7.27-0ubuntu0.18.04.1 (Ubuntu)

Francisco Pena
  • 103
  • 1
  • 7

2 Answers2

0

first try to remove all

askubuntu.com

 sudo apt-get purge mysql-server mysql-client mysql-common mysql-server-core-* mysql-client-core-*
 sudo rm -rf /etc/mysql /var/lib/mysql
 sudo apt-get autoremove
 sudo apt-get autoclean

now

Re install Mysql

easy beasy

Gabriel Casa
  • 3
  • 2
0

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

PROBLEM: sometime mysql will make your root user use unix plugin for auth ERROR 1698 (28000)

Francisco Pena
  • 103
  • 1
  • 7