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?

3 Replies

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
Linode Staff

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.

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct