How can I get access to a VIVO database?

This question most commonly arises when someone ships a dump of a MySQL database to a developer at another site, for testing or debugging purposes. The sender of the data may be reluctant to provide the password to the root account, either because

• they do not wish the developer to know their root password, or
• they do not wish to use unsecured media to send their root password.

So the developer faces a puzzle. They can load the data into MySQL, they can start an instance of VIVO and give it access to the data, but they cannot log in to that VIVO because they don't know the password.

How to get access to a VIVO instance without knowing the root password?

Procedure

To gain access to the database, simply create a new root account.

...