Is there a reason why you don't just use a ssh based client like Navicat, Sequel Pro, SQL Workbench, or even just plain ssh, etc., and just remotely connect to it? Phpmyadmin really should not be on a production server, especially when you can just remotely connect to the db.
How to install phpmyadmin on forge?
Hi,
So I tried Bashy's best awnser in this thread and I have no luck
https://laracasts.com/discuss/channels/servers/phpmyadmin-on-forge
ran this
git clone --depth=1 --branch=STABLE git://github.com/phpmyadmin/phpmyadmin.git
then navigate to /etc/nginx/sites-available
sudo nano default
to add the location code, ive tried a few different spots, this seems like a good spot?
# FORGE CONFIG (DO NOT REMOVE!)
include forge-conf/default/server/*;
location /phpmyadmin {
index index.php;
auth_basic "Login";
auth_basic_user_file /home/forge/default/phpmyadmin/authbasic_mysql;
}
location / {
try_files $uri $uri/ /index.php?$query_string;
}
location = /favicon.ico { access_log off; log_not_found off; }
location = /robots.txt { access_log off; log_not_found off; }
access_log off;
error_log /var/log/nginx/default-error.log error;
error_page 404 /index.php;
location ~ \.php$ {
fastcgi_split_path_info ^(.+\.php)(/.+)$;
fastcgi_pass unix:/var/run/php/php7.1-fpm.sock;
fastcgi_index index.php;
include fastcgi_params;
}
restart server
sudo systemctl restart nginx
ive also added this sym link, but its unclear if this is still needed.
sudo ln -s /home/forge/default/phpmyadmin /usr/share/nginx/html
restart server again
sudo systemctl restart nginx
navigating to http://IP-ADDRESS/phpmyadmin/index.php
gives a error
No input file specified.
navigating to http://IP-ADDRESS/phpmyadmin
gives a error
403 Forbidden
So yeh, safe to say I have no idea what im doing.
Please or to participate in this conversation.