How to Bytemark

Reset MySQL root password

Do you know your database root password?

In your web browser, go to but replace with the name of your server.

You’ll be prompted for a username and password. Type in root as the username.

If you prefer to use the command-line, run this instead:

mysql -u root -h localhost -p

Steps to reset

If you’ve forgotten the MySQL root password, here are the steps to change it. You’ll need to be logged into your server via an SSH-client (eg, PuTTY).

If using PuTTY, enter the Host Name (eg, and connect. When it prompts you for a user, type admin, press Enter, and type your password.

If you’ve forgotten your admin password, contact us and we can reset it for you with 5-10 minutes of downtime.

Run this command to generate a strong password and note it down.

openssl rand -base64 12

Paste and run the following command, which will open a MySQL shell:

sudo mysql --defaults-file=/etc/mysql/debian.cnf

In the MySQL shell, run this command and replace 123 with the password you noted down above:

update mysql.user set password=password('123') where user='root';

Now run these two commands to apply the change and exit the MySQL shell:

flush privileges;

Help, I don’t know what I’m doing!

If you’re not quite comfortable with the instructions above, give us a shout and we’re more than happy to assist!

You are currently viewing Symbiosis user documentation. Symbiosis also has a comprehensive technical reference manual.

Bytemark Cloud used to be called "BigV"—nothing has changed except the name! We’re hiring! Please visit to find out more.