(You must already be logged in to Gitlab or you’ll hit a 404)
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
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!