MySQL Login stopped working
Hello,
we installed mysql on a ubuntu machine. After a month or so we are not able to login. we had created several users. none of them are able to log in including the root. we keep getting this message
```
$ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
```
```
$ systemctl status mysql.service
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2019-11-20 06:29:39 UTC; 1 day 11h ago
Main PID: 37613 (mysqld)
Tasks: 28 (limit: 9513)
CGroup: /system.slice/mysql.service
└─37613 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid
Nov 20 06:29:38 engblog systemd[1]: Starting MySQL Community Server...
Nov 20 06:29:39 engblog systemd[1]: Started MySQL Community Server.
```
Does mysql have some default setting where it deletes all users if the system is not used for a month or so? What do we do now?
Subject
Written By
Posted
MySQL Login stopped working
November 21, 2019 12:21PM
November 21, 2019 01:45PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.