Where is the default root password for MySQL on Ubuntu?

Question

After a fresh new install of MySQL 5.7 on Ubuntu 19, when I attempt to log in for first time I cannot because I don't have the credentials. But the install did not prompt for credentials. I tried doing a grep for 'temporary password' in the following directories but none have a temp password. Where is the default password located? Thank you.

/var/log/mysql/error.log

and

/var/log/syslog

Possible duplicate of [How do I retrieve my MySQL username and password?](https://stackoverflow.com/questions/4371/how-do-i-retrieve-my-mysql-username-and-password) — Shanteshwar Inde, Jun 17 '19 at 05:20

score 2 · Answer 1 · answered Jun 17 '19 at 05:23

2

Restart MySQL in passwordless mode, reset the password, restart the MySQL service.

# 1 : Stop mysql service
/etc/init.d/mysql stop
# 2: Start to MySQL server w/o password:
mysqld_safe --skip-grant-tables &
# Step # 3: Connect to mysql server using mysql client:
mysql -u root

-- 4: Setup new MySQL root user password
use mysql;
update user set password=PASSWORD("NEW-ROOT-PASSWORD") where User='root';
flush privileges;
quit

# 5: Stop MySQL Server:
/etc/init.d/mysql stop
# 6: Start MySQL server and test it
/etc/init.d/mysql start
mysql -u root -p

source

from search

answered Jun 17 '19 at 05:23

Keith John Hutchison

4,582
8
40
60

After doing step 2, attempting step 3 doesn't work. I get 'Can't connect to local MySQL server through socket' error. – martinb Jun 17 '19 at 05:46
I also get the following when attempting step 2. ' mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.' – martinb Jun 17 '19 at 06:03
What is the output of `ps aux | grep mysql` – Keith John Hutchison Jun 17 '19 at 06:22
Can do you a reinstall of mysql? – Keith John Hutchison Jun 17 '19 at 06:23

score 1 · Answer 2 · answered Jun 17 '19 at 12:54

1

Can't connect to local MySQL server through socket Follow these step to resolve this

Find your socket file by running.

sudo find / -type s

create a link to this file in tmp directory.

sudo ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock

answered Jun 17 '19 at 12:54

Sabahat Inayat

11
4

by default, for root user there's no password. – Sabahat Inayat Jun 17 '19 at 13:03

Where is the default root password for MySQL on Ubuntu?

2 Answers2