Connecting to an RDS for MySQL Instance Through MySQL-Front

MySQL-Front is a Windows front end for MySQL databases. It allows you to interact with MySQL databases through a GUI. For example, you can connect to a database, run SQL commands, and manage tables and records.

This section uses MySQL-Front 5.4 as an example to describe how to use MySQL-Front to connect to an RDS for MySQL instance through an EIP.

Procedure

Download and install MySQL-Front (for example, MySQL-Front 5.4).
Start the MySQL-Front.
In the displayed dialog box, click New.

Figure 1 Connection management

Enter the information of the DB instance to be connected and click Ok, as shown in Figure 2.

Figure 2 Adding an account

**Table 1** Parameters
Parameter	Description
Name	Name of the database connection task. If you do not specify this parameter, it will be the same as that configured for Host by default.
Host	EIP bound to the DB instance. To obtain it: Click the instance name to enter the Summary page. In the navigation pane, click Connectivity & Security and check the EIP.
Port	Database port of the DB instance. To obtain it: Click the instance name to enter the Summary page. In the navigation pane, click Connectivity & Security and check the database port.
User	Username for accessing the instance. The default user is root.
Password	Password of the username.

In the displayed window, select the connection that you have created in 4 and click Open. If the connection information is correct, the DB instance will be connected.

Figure 3 Opening a session

FAQ

What Should I Do If I Forget My Password?

On the Instances page, locate the target DB instance, choose More > Reset Password in the Operation column, and set a new password.

Common Connection Error Messages

[Warning] Access denied for user 'username'@'yourIp' (using password: NO)
If this error message is displayed when you attempt to connect to an RDS for MySQL instance, check whether the username or password is correct.
[Warning] Access denied for user 'username'@'yourIp' (using password: YES)
If this error message is displayed when you attempt to connect to an RDS for MySQL instance, check whether the username or password is correct.
ERROR 2013: Lost connection to MySQL server during query
If the values of wait_timeout and interactive_timeout are too small, the RDS for MySQL client will automatically stop connections that timed out. For details, see RDS for MySQL Client Automatically Disconnected from a DB Instance.
ERROR 1045 (28000): Access denied for user 'root'@'192.168.0.30' (using password: YES)
Check whether the password is correct, whether the ECS has the permission to connect to the DB instance, and whether the RDS for MySQL client can ping the DB instance's floating IP address. For details, see RDS for MySQL DB Instance Inaccessible.
ERROR 1226 (42000): User 'test' has exceeded the 'max_user_connections' resource (current value:10)
Check whether the number of connections to the DB instance is limited. For details, see RDS for MySQL DB Instance Inaccessible.
ERROR 1129 (HY000): Host '192.168.0.111' is blocked because of many connection errors; unblock with 'mysqladmin flush-hosts'
Check whether the number of failed connection attempts (not caused by incorrect passwords) of the RDS for MySQL client exceeds the value of max_connection_errors. For details, see RDS for MySQL DB Instance Inaccessible.