MySQL setup root password on initial setup

August 18, 2014 4.7k views

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

1 Answer

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
The details of your PHP installation can be seen at
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

Have another answer? Share your knowledge.