Fresh mysql-server installation does not ask for password

mysql installation raspberry-pi raspbian
Robin Dupont picture Robin Dupont · Nov 9, 2017 · Viewed 20.5k times · Source

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.

Answer

corporateWhore picture corporateWhore · Jan 6, 2018

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

Related questions

Installing PDO driver on MySQL Linux server

I was suggested, not long ago, to change my code to use PDO in order to parameterize my queries and safely save HTML in the database. Well, here are the main problems: I looked at http://php.net/manual/en/…

Read More
Xampp MySQL not starting - "Attempting to start MySQL service..."

I've just installed XAMPP for Windows - should be the newest version (XAMPP Control Panel v3.2.1). Apache is running just fine on port 80 and 443, but MySQL is not starting. When I press the start button, I get this message: Attempting …

Read More
Mac install and open mysql using terminal

I downloaded the mysql dmg file and went through the wizard to run. Done. I have also started mysql server under system preferences. The purpose of me doing this is to work through the exercises of my SQL text book. …

Read More