All geek questions in one place

How to connect MySQL Workbench to Amazon RDS?

I am referring to Amazon RDS (MySQL) from Putty. MySQL Workbench only works with the SSH command line, but I would like to access the MySQL MySQL host database directly from the MySQL Workbench.

+6
source share
2 answers

MySQL forums host postings that link to various sources for connecting MySQL Workbench to online resources: http://forums.mysql.com/read.php?152,252640,252640#msg-252640 . The basic steps for Amazon RDS are on this page: https://thoughtsandideas.wordpress.com/2012/05/17/monitoring-and-managing-amazon-rds-databases-using-mysql-workbench/

Step 3) Fill in the values ​​described below, which are shown in Figure 4.

  • The name of the connection. Provide a name to identify your connection. Connection method - select standard TCP / IP via SSH from the drop instead of standard (TCP / IP). Then, on the two tabs of the panel that appears, fill in the following values ​​found on the Settings tab.
  • The SSH host name is to provide the Amazon EC2 instace public DNS (see Figure 3), which will be used as the intermediate server instance used to create a connection to the DB instance.
  • SSH username - specify the user of the Amazon EC2 instance (see Figure 3), which will be used as the intermediate server instance used to create the connection to the DB instance.
  • SSH key file - specify the secret key (xxx.pem) used to connect Amazon EC2 via SSH
  • MySQL Hostname — Specify the endpoint of the DB instance created in Amazon RDS (see Figure 5).

  • Username - enter the main username of the database instance created in Amazon RDS (see Figure 5).

  • Password — Click the Save in Keychain button and enter the password provided when creating the DB instance in Amazon RDS.

+7
source
  • In MySQL Workbench Click “Establish New Connection”,
  • Specify the connection name and select the connection method as standard TCP / IP,
  • Enter the host name from the RDS endpoint and port as 3306,
  • Enter the Mysql username and password as described in the RDS instance creation,
  • Then check the connection and click OK.

Check MySQL connection

0
source

Source: https://habr.com/ru/post/982252/

More articles:


All Articles