MySQL Forums
Forum List  »  Newbie

MySQL Login stopped working
Posted by: SIDDHARTH jain
Date: November 21, 2019 12:21PM

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?

Options: ReplyQuote


Subject
Written By
Posted
MySQL Login stopped working
November 21, 2019 12:21PM


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.