No password is asked when installing mysql-server

January 15, 2017 36.3k views
LAMP Stack MySQL Ubuntu 16.04
devmnrj8d73c1ef4c13c847f2a
By:
devmnrj8d73c1ef4c13c847f2a

No password is asked when installing mysql-server.
this is the output I have from the terminal :

root@mizzouadvantagecod:~# sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree

Reading state information... Done
The following NEW packages will be installed:
mysql-server
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B/10.1 kB of archives.
After this operation, 106 kB of additional disk space will be used.
Selecting previously unselected package mysql-server.
(Reading database ... 85555 files and directories currently installed.)
Preparing to unpack .../mysql-server5.7.16-0ubuntu0.16.04.1all.deb ...
Unpacking mysql-server (5.7.16-0ubuntu0.16.04.1) ...
Setting up mysql-server (5.7.16-0ubuntu0.16.04.1) ...
root@mizzouadvantagecod:~#

1 comment
  • davidmancini May 19, 2018

    When I was following along the Digital Ocean guide, my Ubuntu 18.04 server did not ask to set the MySQL root user password during apt-get install mysql-server. I was able to login to MySQL and manually set the password using the following commands

    sudo mysqld_safe --skip-grant-tables&
sudo mysql --user=root mysql
mysql> update user set authentication_string=PASSWORD('new-password') where user='root';
flush privileges;
quit
sudo service mysql restart
sudo mysql -u root -p
exit

    I then needed to run mysql_secure_installation using the sudo command

    sudo mysql_secure_installation

    The sudo was not mentioned in the guide. When I ran it without sudo, I got the following error:
    Error: Access denied for user 'root'@'localhost'

    Hope this is helpful for others.

Log In to Comment
5 Answers
ienoobong May 3, 2018

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

  1. Go to official mysql installation guide and follow line by line
  2. You need to download a .deb file from here that configures which version of mysql you want to install and other configurations
  3. 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!

Reply
devmnrj8d73c1ef4c13c847f2a January 15, 2017

It's now fixed:

Remove all files related to MySQL

sudo apt-get purge mysql*

sudo apt-get autoremove

sudo apt-get autoclean

Then upgrade my distribution

sudo apt-get dist-upgrade

Then install MySQL

sudo apt-get install mysql-server
That's all.

Reply
jtittle1 January 15, 2017

@devmnrj8d73c1ef4c13c847f2a

As a general note, depending on the OS and the decision of the package manager, a password may not be required during package installation.

To remedy that, and something you should run after installing MySQL or MariaDB anyway:

mysql_secure_installation

Simply follow the on-screen prompts and it'll handle setting the root password (or changing it) as well as removing un-needed items from the core.

Reply
honor0102 August 29, 2018

try Dimitre's answer here:
https://stackoverflow.com/questions/7739645/install-mysql-on-ubuntu-without-a-password-prompt
you can set the mysql root password before installation

Reply
ankittyagi20 January 3, 2019

Check the mysql logs:
grep 'temporary password' /var/log/mysqld.log

Reply
Have another answer? Share your knowledge.

Related Questions