The Symbiosis system comes with the MySQL database installed and running. It can be managed by use of the phpMyAdmin program.
Connecting to phpMyAdmin
The following instructions show how to connect to the database on the server
- Start your web browser.
- Navigate to
example.default.bytemark.uk0.bigv.io/phpmyadmin/and enter the authentication details for MySQL. Use the same password you were initially given for your admin user when you created your Cloud Server, but use root as the username.
Important note: If you have changed the admin password, it doesn’t have any effect on the MySQL root password. If you want to change the MySQL password, you can do so from within phpMyAdmin.
- Press the OK button to be log in.
- From here new databases and database users can be created as needed. phpMyAdmin is further documented on its home page.
Reset MySQL root password
Do you know your database root password?
In your web browser, go to
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!