MySQL setup root password on initial setup

Posted August 18, 2014

I just installed LAMP on Ubuntu and changed root password. I ran mysql_secure_installation and pressed enter as suggested - ‘acces denied’.

I tried my ubuntu root password and failed. I did not set any other passwords.

Help please

tomasz.andrzej

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.

Andrew SB • August 18, 2014

When you first log onto the server, you should see something like

-------------------------------------------------------------------------------------
Thank you for using DigitalOcean's LAMP Application.
Your web root is located at /var/www/html and can be seen from http://108.131.197.65/
The details of your PHP installation can be seen at http://108.131.197.65/info.php
Your MySQL root user's password is vmZpCJtyE3
You are encouraged to run mysql_secure_installation to ready your server for production.
-------------------------------------------------------------------------------------

When you run mysql_secure_installation it will ask you for the MySQL root user’s password that is in the text above. It will also give you the option to set the password to one of your choosing. If you need to see the message again, run: cat /etc/motd.tail