To connect Trevor.io to your MySQL database, login to Trevor and head to the connect MySQL screen.
You'll need to enter the following fields:
You may also need to whitelist Trevor.io's IP addresses or connect via SSH.
This is just a memorable name you choose to give this datasource. It can be anything you like, e.g. "Our Prod Database".
Host and Port
This is the host and port of the server on which your database is hosted.
If your database is hosted on Amazon RDS, follow these instructions to find the host and port. If not, please contact us for help.
Whitelist IP addresses
By default, AWS will make your database inaccessible to the outside world. Two steps are needed to allow Trevor to securely access your database:
- Ensure that your database has its "Publicly accessible" setting set to true (if not, you will need to connect via SSH instead)
- allow (i.e. whitelist) access to your database from Trevor's IP addresses.
To whitelist Trevor's IP addresses follow these instructions.
This is the name of the database you want Trevor to connect to.
Easiest way to get this is to run the following command on your database:
User and Password
This is the username and password for the database user that you want Trevor to connect as.
To create such a user please follow these instructions.
Connect via SSH
Often it is the case that your database is not directly accessible to the internet. This is where connecting via SSH is the perfect solution.
Detailed instructions on how to do this can be found here.
Please sign in to leave a comment.