Bitnami
How to access phpMyAdmin:
http://127.0.0.1:8888/phpmyadmin
https://docs.bitnami.com/bch/components/phpmyadmin/
https://docs.bitnami.com/aws/how-to/get-started-wordpress-aws-marketplace-beginner/
https://docs.bitnami.com/aws/apps/wordpress/
https://docs.bitnami.com/aws/apps/wordpress/administration/control-services/
CONNECT TO BITNAMI WORDPRESS AWS INSTANCE VIA PUTTY/NotePad++
Here is how to do it.
DOWNLOAD .PEM FILE FROM AWS AND USE PUTTYGEN TO GENERATE .PPK
- Create key pair on Amazon AWS and select the .pem version to download.
- Download it.
- Open PuttyGen and click “Load” button and change dropdown filter from PuTTY Private Key (*.ppk) → All Files in bottom right corner of windows explorer menu.
- Click “Save private key” as a .ppk file.
CONNECT FROM PUTTY TO AWS INSTANCE
- Open Putty
- Put hostname in the hostname field. eg. 192.168.1.168 (for bitnami public IP address)
- Look for “Saved Sessions” and add a name for the project. eg. VQDEV
- Click Save
- Go to “Connection → SSH → Auth→ Credentials
- Under “Private key file for authentication:” add your .ppk file.
ADDING BITNAMI PHPMYADMIN TUNNEL TO PUTTY
- Go to “Connection → SSH → Tunnels and under “Source port” add 8888 as the port and under “Destination” add localhost:80.
- Then click “Add” button.
- Then click back on “Session” and “Save”
- Then click the “Open” button and use bitnami as the username.
- Go to http://127.0.0.1:8888/phpmyadmin to show you are connected!
Creating an SSH KEY
ssh-keygen
- It will create an id_ under C:/Users/jimob/.ssh/id_ed25519 with randomized UID on the end or it will create id_rsa.
- Enter a passphrase if you want or just hit “Enter” for none.
- You will need to enter password twice or hit Enter again.
eval `ssh-agent`
- It should return something like this: Agent pid 1793
ssh-add ~/.ssh/id_rsa
- It should return something like this: Identity added: /c/Users/jimob/.ssh/id_ed25519 (jimob@orion)
LINUX: cat ~/.ssh/id_rsa.pub | xclip -sel clip WINDOWS: clip < ~/.ssh/id_ed25519.pub MAC:
File Permissions
https://docs.bitnami.com/bch/apps/wordpress-pro/administration/understand-file-permissions/
sudo chown -R bitnami:daemon TARGET
sudo find TARGET -type d -exec chmod 775 {} \;
sudo find TARGET -type f -exec chmod 664 {} \;
sudo chmod 640 TARGET/wp-config.php