Installing MySQL Client on Ubuntu and Connecting to Amazon RDS

Installing MySQL Client on Ubuntu:

  1. Open Terminal: Press Ctrl + Alt + T to open the terminal.

  2. Update Package List: Run the following command to make sure your package list is up-to-date.

    sudo apt update

  3. Install MySQL Client: Use the following command to install the MySQL client.

    sudo apt install mysql-client

  4. Verify Installation: After installation, you can check the version to ensure it's installed.

    mysql --version

Using MySQL Client with Amazon RDS:

  1. Get RDS Endpoint and Credentials:

    • In the AWS RDS Console, locate your MySQL instance.
    • Note down the endpoint (something like your-database-instance-name.xxxxxxx.region.rds.amazonaws.com).
    • Ensure you have the username and password for your RDS instance.

  2. Connect to RDS with MySQL Client:

    mysql -h your-database-instance-name.xxxxxxx.region.rds.amazonaws.com -u your-username -p
    • Replace your-database-instance-name, xxxxxxx.region, your-username with your actual RDS details.

  3. Enter Password: You'll be prompted to enter the password. Type it and press Enter.

  4. Connected to RDS: If successful, you'll be connected to your RDS instance via the MySQL client.

  5. Run Queries:

    • Now, you can run SQL queries directly in the terminal.
    • For example, to show all databases: 
      SHOW DATABASES;

  6. Exit MySQL Client: When you're done, type exit and press Enter to exit the MySQL client.

That's it! You've installed the MySQL client on Ubuntu and connected it to your Amazon RDS instance. You can now interact with your RDS database using MySQL commands.