How to put a root password in "One-click Wordpress" MySQL

You will need to run it with sudo:

sudo mysql_secure_installation

and it should allow you to set a new root password for MySQL afterwards. In the rare event that doesn't work either, you can become root and then try it again:

sudo su -
mysql_secure_installation

Hey there!

So the Wordpress One Click App does install MySQL with the secure installation. The One Click App actually sets a random root password for better security with this command:

DBROOT_PASSWORD=`head -c 32 /dev/random | base64

This is later called in the One click App when setting the root password for MySQL.

In order to reset the MySQL root password, you will want to follow the steps at this link starting with section B.4.3.2.2 Resetting the Root Password: Unix and Unix-Like Systems.

That should get you where you need to be. Hope this helps!

Thank you for the very fast reply. All understood, scrane.