Amazon Linux AMI install mysql client programs for RDS

by

You can install the MySQL client programs for RDS on Amazon Linux AMI using the following steps:

  1. Install the MySQL repository: Run the following command to install the MySQL repository:
wget https://repo.mysql.com/mysql80-community-release-el7-1.noarch.rpm
sudo yum localinstall mysql80-community-release-el7-1.noarch.rpm
  1. Install the MySQL client programs: Use the following command to install the MySQL client programs:
sudo yum install mysql-community-client
  1. Verify the installation: You can verify the installation by running the following command:
mysql --version
  1. Connecting to RDS: Once the client is installed, you can connect to the RDS instance by using the following command:
mysql -h <hostname> -P <port> -u <username> -p

You will be prompted to enter the password for the user you are trying to connect as.

  1. Test the connection: After the connection is established, you can test the connection by running a simple query such as SHOW DATABASES;

Note: Make sure that your RDS instance is configured to allow connections from your Amazon Linux AMI instance by checking the Security group of your RDS.

Leave a Comment