How to put a root password in "One-click Wordpress" MySQL
I am unable to put a MySQL password in the "auto-installed Wordpress" linode web server for the user root.
I have tried: mysql_secure_installation
Looks locked. Is insecure?
You will need to run it with
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
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.184.108.40.206 Resetting the Root Password: Unix and Unix-Like Systems.
That should get you where you need to be. Hope this helps!