DigitalOcean Kubernetes: new control plane is faster and free, enable HA for 99.95% uptime SLA

Related

MySQL "describe/explain/show columns from" Problem on Fedora: "ERROR 1 (HY000): Can't create/write to file"
Question
How to set up my cloud/vps server using Ubuntu 12.04 LTS, Apache, MSQL, Phpmyadmin, PHP
Question

Question

No password is asked when installing mysql-server

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-server_5.7.16-0ubuntu0.16.04.1_all.deb … Unpacking mysql-server (5.7.16-0ubuntu0.16.04.1) … Setting up mysql-server (5.7.16-0ubuntu0.16.04.1) … root@mizzouadvantagecod:~#

Subscribe
Share
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.

davidmancini • May 19, 2018

This comment has been deleted

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

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!

ankittyagi20 • January 3, 2019

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

Win1 • 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

Jonathan Tittle • 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.

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.

Now Available: Managed MySQL DatabasesProduct

Want a more reliable, scalable database?

  • Let us manage the database engine for your app so you can focus on building
  • Choose from 3 database engines: PostgreSQL, Redis, and MySQL
  • We'll handle setting up, backing up, updating, and restoring for you

Related

MySQL "describe/explain/show columns from" Problem on Fedora: "ERROR 1 (HY000): Can't create/write to file"
Question
How to set up my cloud/vps server using Ubuntu 12.04 LTS, Apache, MSQL, Phpmyadmin, PHP
Question

Try DigitalOcean for free

Click below to sign up and get $100 of credit to try our products over 60 days!

Sign up