Changing the PHPmyadmin Default Url

NGINX change phpmyadmin url

Please take a look at /etc/nginx/site-available/default where you will need to add location /phpmyadmin

How do i change the url of my phpmyadmin?

localhost/phpmyadmin is just the url for you, because the server is on your computer.
If you want your friends can use phpmyadmin, you just have to give them your ip/domain and they will access it with ip/phpmyadmin.

You'll maybe need to configure your firewall.

How to change base_url settings with phpMyAdmin

Take a look @ http://www.magentocommerce.com/wiki/recover/restore_base_url_settings

  1. Open your core_config_data table in phpMyAdmin.

  2. Find the following rows for your unsecure section, they should look like the following:

    PATH                    VALUE
    web/unsecure/base_url http://www.mydomain.com/
  3. Replace http://www.mydomain.com/ with your appropriate domain url (trailing slash necessary) and if you’ve installed in a subfolder append it with a / after it.

ubuntu 16.04 nginx change phpmyadmin url not working

Try:

location ^~ /whatever {
alias /usr/share/phpmyadmin;
index index.php index.html index.htm;
if (!-e $request_filename) { rewrite ^ /whatever/index.php last; }
# Secure phpMyAdmin Instance
auth_basic "Admin Login";
auth_basic_user_file /etc/nginx/.your_pass_file;
client_max_body_size 68M;

location ~ \.php$ {
if (!-f $request_filename) { return 404; }
fastcgi_pass unix:/var/run/php/php7.0-fpm.sock;
include fastcgi_params;
fastcgi_param SCRIPT_FILENAME $request_filename;
}
}

You need to use /whatever/index.php in the rewrite statement. The nested location blocks only need to match the end of the URI. The ^~ modifier avoids conflicts with other regular expression location blocks at the server block level. Use $request_filename in the SCRIPT_FILENAME. Your last nested location block appears to perform no function.

Avoid try_files with alias due to this issue. See this caution on the use of if.

Install phpmyadmin client on third level domain

It's possible to set pma on a third level domain.

This configuration working on CentOS 7 with apache web server:

  • Create db.mysite.com.conf in /etc/httpd/sites-available
  • Config your virtul host on your own
  • Set "DocumentRoot" to /usr/share/phpMyAdmin
  • Create a symbolic link in /etc/httpd/sites-enabled to enable your virtual host
  • Restart apache (systemctl restart httpd)

Enjoy! Thanks @CBroe for your "no" answer



Related Topics



Leave a reply



Submit