Fresh mysql-server installation does not ask for password

Question

I am installing the package mysql-server on debian (actually Raspbian, the Debian version for raspberry pi). I'm installing it with the following command

sudo apt-get install mysql-server

During the installation I'm not asked to enter a root password. And if I try to connect to mysql with the following command :

mysql -u root

or

mysql -u root -p

and using the system root password, I got the following error :

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

I am quite confused since apparently I should be asked to provide a root password during the installation.

What should I do ?

Regards.

corporateWhore · Accepted Answer · 2018-01-06T16:47:13.000

31

Try this:

After installation, run MySql Secure Installation:

pi@raspberrypi:~ $ sudo mysql_secure_installation

You'll be asked a series of security related configuration questions, including setting the root password.

Once the root password is set, you'll need to be logged in as root (or use sudo) to login. This is a consequence of how MySql uses credentials based on process uid

edited Jan 06 '18 at 16:47

answered Jan 06 '18 at 16:00

corporateWhore

617
2
12
23

4

Thanks! I ran `$ mysql_secure_installation` (i.e. without sudo) and empty password did not work. **Just added** sudo and empty password **worked**! OS: debian-9 – Vinay Vissh Mar 26 '18 at 11:54
Be aware to not use `\\` chars in your password. – Ratata Tata Feb 13 '19 at 11:50
anyway to set it up to not ask for sudo everytime – Areza Feb 10 '20 at 14:24
its asking for root password even with sudo on first installation without giving me password.. -_- – Rohit Kaushal Oct 11 '20 at 05:19

score 26 · Answer 2 · answered Aug 15 '18 at 15:48

26

Here you go:

In the new my-sql if the password is left empty while installing then it is based on the auth_socket plugin.

The correct way is to login to my-sql with sudo privilege.

$ sudo mysql -u root -p

And then updating the password using:

$ ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'new-password';

Once this is done stop and start the mysql server.

$  sudo service mysql stop
$  sudo service mysql start

For complete details you can refer to this link.

Do comment for any doubt.

answered Aug 15 '18 at 15:48

Nandesh

4,437
2
20
26

3

After reading 5 or so stackoverflow threads regarding this password problem, this was the one that solved the issue. All was missing was the `sudo` before `mysql`. – Pedro Sep 14 '18 at 22:44
Happy to help :) @Pedro – Nandesh Sep 15 '18 at 11:22
@Nandesh I was in the same boat as Pedro -- several Stack Overflow and Ask Ubuntu posts, blog posts, etc. tried, all to no avail until I found your simple solution. Well done, and thanks! – duckmayr Nov 13 '18 at 22:08
@duckmayr For developer from developers :) – Nandesh Nov 14 '18 at 05:32

score 6 · Answer 3 · answered Nov 28 '18 at 13:09

If someone facing this problem in installing MYSQL in Ubuntu 18.04.

Ubuntu 18.04 uses sockets for authorization and not passwords!!

(https://websiteforstudents.com/mariadb-installed-without-password-prompts-for-root-on-ubuntu-17-10-18-04-beta/)

For me logging in was as simple as:

sudo  mysql -u root

Don't forget the sudo

I really hope there should have been a message stating that Ubuntu no longer used passwords when attempting to run mysql. this was a really drastic change in functionality.

score 3 · Answer 4 · answered Jan 02 '19 at 14:49

In my case nothing worked as mentioned here, following worked for me. As described here also: https://dev.mysql.com/doc/refman/8.0/en/linux-installation-yum-repo.html

A superuser account 'root'@'localhost is created. A password for the superuser is set and stored in the error log file. To reveal it, use the following command:

shell> sudo grep 'temporary password' /var/log/mysqld.log

score 1 · Answer 5 · answered May 03 '18 at 23:22

I had the same problem which prevented me from being able to access mysql all the answers to use mysql_secure_installation after running sudo apt install mysql-server didn't work. Here's what worked

Go to official mysql installation guide and follow line by line
You need to download a .deb file from here that configures which version of mysql you want to install and other configurations
After configurations are all done run sudo apt-get update && sudo apt-get install mysql-server This time you'd be asked for a password.

Hope it helps. Cheers!

score 1 · Answer 6 · answered Jun 24 '18 at 17:53

Download apt repository from mysql official site https://dev.mysql.com/downloads/repo/apt/

Select your version and click next and select ok and click next.

now

sudo apt-get update  

sudo apt-get install mysql-server

while installing it will ask for password.

score 1 · Answer 7 · answered Jul 30 '20 at 09:48

1

In my case the mysql root password was my superuser password.

answered Jul 30 '20 at 09:48

goulashsoup

2,639
2
34
60

score 0 · Answer 8 · answered Nov 11 '17 at 14:20

0

You might be interested reading this question and aswers.

Isn't the default password the empty string ?

answered Nov 11 '17 at 14:20

mszmurlo

1,250
1
13
28

Fresh mysql-server installation does not ask for password

8 Answers8