By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Aws light sail Wordpress. Does it include phpmyadmin?

0

Is phpmyadmin installed to a light sail Wordpress instance? And how do I check? I used ssh and typed phpmyadmin —version But it wasn’t found I tried logging in to phpmyadmin with no success. I checked the bitnami directory and there is a phpmyadmin directory but it is empty. Is it installed and if so where would it be? I am also port forwarding and using https://127.0.0.1:8888/phpmyadmin/ but it’s not found. My database seems to be a Mariadb database. I assume it is used with phpmyadmin ? Or is there another way to edit the database. I just want to access my Wordpress tables.

  • cedhood
    a year ago

    You will need to create an SSGH tunnel to connect to myphpadmin. AWS LightSail uses a Bitnami WordPress image which is optimized for performance and security. It means you can’t just connect to your server and open phpMyAdmin. Also, it doesn’t come with a cPanel to provide additional tools to get your work done.

    For security reasons, most of the admin tools are only accessible on the localhost IP address of 127.0.0.1 including phpMyAdmin.

    As the address is a local address, you need to create a secure SSH tunnel which will allow you to access those tools.

Topics
ComputeDatabase
Tags
Amazon LightsailDatabaseMariaDB
Language
English
rePost-User-5253354
asked a year ago388 views
1 Answer
-1

No, Amazon Lightsail WordPress instances do not include phpMyAdmin by default. However, you can easily install phpMyAdmin on your Lightsail instance by following these steps:

Connect to your Lightsail instance using SSH.

Download the latest version of phpMyAdmin by running the following command:

wget https://files.phpmyadmin.net/phpMyAdmin/{version}/phpMyAdmin-{version}-all-languages.tar.gz

Replace {version} with the latest version of phpMyAdmin available.

Extract the downloaded archive by running the following command:

tar xzf phpMyAdmin-{version}-all-languages.tar.gz

Rename the extracted directory to phpMyAdmin by running the following command:

mv phpMyAdmin-{version}-all-languages phpMyAdmin

Move the phpMyAdmin directory to the Apache web root directory by running the following command:

sudo mv phpMyAdmin /var/www/html/

Change the ownership of the phpMyAdmin directory to the Apache user by running the following command:

sudo chown -R www-data:www-data /var/www/html/phpMyAdmin/

Restart the Apache web server by running the following command:

sudo service apache2 restart

Access phpMyAdmin by visiting http://your-instance-ip/phpMyAdmin in your web browser, replacing your-instance-ip with the IP address of your Lightsail instance. You should now be able to log in to phpMyAdmin using the MySQL credentials for your Lightsail instance.

If this helps, please upvote and accept answer to help everyone on this forum. Let me know if you need anything else.

profile pictureAWS
Ananth Tirumanur
answered a year ago
profile pictureAWS
EXPERT
kentrad
reviewed a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content