Forgotten MySQL username on ubuntu

Question

I've forgotten my MySQL owner details. I need a way to find my username. My password will not be a problem. I use Ubuntu 12.04 Linux, and would prefer a command line solution.

Thank you in advance.

Question is duplicate http://stackoverflow.com/questions/4371/how-do-i-retrieve-my-mysql-username-and-password — Swapnil Patil, Sep 10 '13 at 13:14
Its not duplicate. I saw that when I googled 16 mins ago. That works for windows not debian linux. Got it? — Ema4rl, Sep 10 '13 at 13:22

Alma Do · Answer 1 · 2014-03-19T08:55:06.847

7

Well, then you have a clear way to restore it:

Run your MySQL server with skipping grant tables option.
Log in as root
Run query
```
SELECT DISTINCT user FROM mysql.user
```
That's it - you have a list of users. Save it somewhere, then run server normally and try your user names one by one.

Tip: if you want to reset root password, there's a corresponding manual page.

edited Mar 19 '14 at 08:55

answered Sep 10 '13 at 13:12

Alma Do

37,009
9
76
105

Let me check this. I'll get back. Thanks. – Ema4rl Sep 10 '13 at 13:23
Pls, how do I run with skipping grant tables option. I didn't find anything readable code in the docs link. – Ema4rl Sep 10 '13 at 13:30
@EmmanuelHarrison see [this sample](http://stackoverflow.com/questions/1708409/how-to-start-mysql-with-skip-grant-tables) – Alma Do Sep 10 '13 at 13:44

score 0 · Answer 2 · answered Sep 10 '13 at 13:15

0

Well there is simple way how to change mysql user password as root

mysql -u root -p password
mysql> SET PASSWORD FOR username = PASSWORD('new_password_here');

answered Sep 10 '13 at 13:15

Kārlis Millers

664
2
11
29

1

I got this error: "ERROR 1133 (42000): Can't find any matching row in the user table ". – Ema4rl Sep 10 '13 at 13:26
it asks for password and says unknown database password – codingbbq Feb 14 '15 at 05:12

Forgotten MySQL username on ubuntu

2 Answers2