How To: Connect PHPMyAdmin to Amazon RDS MySQL or Lightsail Database MySQL Service

    3
    5



    In this video tutorial, we will configure PHPMyAdmin to use Remote MySQL RDS.

    🔗 Tutorial Steps

    How To Configure PHPMyAdmin to connect to Remote MySQL RDS

    ⌚ Video Timestamps

    00:00 – Introduction
    02:00 – Instance and Database Setup
    04:23 – SSH & SSH Tunnel Setup
    07:31 – Load PHPMyAdmin
    08:11 – Configure RDS Server Entry in PHPMyAdmin Config
    12:30 – Restart Apache
    13:20 – Verify PHPMyAdmin connection to RDS Database

    As always if you found this useful, like the video, Subscribe and most importantly share this with Others and ask them to subscribe!!

    📹 About Channel

    Hi Everyone, welcome to my channel Mukesh’s Techspace, if you are new here, I post tutorials on AWS, Azure, Lightsail, WordPress hosting and other easy to setup web hosting tools and services. I also post videos on WordPress Tips and Tricks for developers. So if you are interested in this type of content please subscribe to the channel.

    👩‍🏫 LEARN FREE

    Join Skillshare Today and Get Two Weeks of Premium Tutorials for FREE: https://go.mukesh.me/skillshare

    📨 SEND YOUR NEWSLETTER EMAILS CHEAPER
    Sendy – https://go.mukesh.me/sendy

    📷 My Gear

    Best Cameras/Mics for YouTube: https://go.mukesh.me/best
    Camera: https://go.mukesh.me/camera
    Mic: https://go.mukesh.me/mic
    HDMI to USB Video Capture: https://go.mukesh.me/hdmi-to-usb
    Adobe Creative Cloud: https://go.mukesh.me/creativecloud
    Sony Power Adapter: https://go.mukesh.me/sonypower
    Easily Record, Edit video using Screencast-O-Matic! – https://go.mukesh.me/screenrecorder

    🏷 Tags

    aws lightsail, phpmyadmin, remote rds, remote mysql, aws aurora, database service,lightsail api,install aws cli,setup aws cli,create lightsail instances,lightsail api,lightsail sdk,how to create lightsail instance,how to create lightsail snapshot,wordpress hosting,web hosting tutorials,how-to web hosting,cloud hosting,web hosting for beginners,create static ip,web host management,cpanel,whm,plesk,run cloud,wordpress cluster,file replication,wordpress

    PS: Some of the link above are affiliate link that I get a kickback from. Your price does not change.

    source

    Previous articleDöme Gábor – Vadvízi kalandok 16. rész – Nagy halak az éjszaka leple alatt – Dupla epizód
    Next articleDeveloping AWS Lambda Functions Locally in VS Code

    5 COMMENTS

    1. Hi, Mukesh. Great video! Your videos are very informative and have helped me a lot. I currently use a C-panel instance with my WordPress website and a custom PHP patient account portal under a subdomain. The portal has sensitive Hippa compliant medical information and the development files both in the public folder with the website files and folders. I'm debating changing the entire system to compartmentalize my website from my portal files but keep it under the subdomain since i can't figure out how to hide this folder from other users. I'm thinking of creating a few instances where I can use a load balancer with stand-alone Word Press instances to have more than one server for the website and have a separate My SQL database Instance to put the portal files sensitive info. I want to do this so developers who need to work on the website cannot access the portal files. Currently, when I give them Cpanel access, a user can see everything. Also, it seems that I can have more control and security this way.
      My question is if I connect the website to the remote database can I give the PHP My Admin credentials to a user from the WordPress instance without them having access to the files in the database instance since they will be connected?