How to Bytemark

Reset MySQL root password

Do you know your database root password?

In your web browser, go to http://example.com/phpmyadmin but replace example.com 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, myserver.default.example.uk0.bigv.io) 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;
quit;

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 careers.bytemark.co.uk to find out more.