Database management in a single PHP file
website: https://www.adminer.org/

1.Download Adminer from the downloads page

cd /usr/local/cwpsrv/var/services/
mkdir adm;cd adm

https://github.com/vrana/adminer/releases/download/v4.7.1/adminer-4.7.1.php

mv adminer-4.7.1.php adminer.php
cd /usr/local/cwpsrv/var/services/
chown cwpsvc:cwpsvc -R adm

2.Add below config to /usr/local/cwpsrv/conf/cwp_services.conf

location /adm {
    root /usr/local/cwpsrv/var/services;
    index  index.html index.htm index.php adminer.php;

    location ~ \.php$ {
        try_files $uri =404;
        fastcgi_split_path_info ^(.+\.php)(/.+)$;
        fastcgi_read_timeout 600;
        fastcgi_pass    unix:/usr/local/cwp/php71/var/sockets/cwpsvc.sock;
        fastcgi_index   index.php;
        fastcgi_param   SCRIPT_FILENAME  $document_root$fastcgi_script_name;
        fastcgi_param   SCRIPT_NAME   $fastcgi_script_name;
        fastcgi_param   PHP_ADMIN_VALUE "open_basedir = /usr/local/cwpsrv/var/services/adm/:/tmp/";
        include                 fastcgi_params;
    }

    location ~* \.(js|css|png|jpg|jpeg|gif|ico)$ {
        access_log    off;
        log_not_found    off;
        expires 1M;
    }
}

3. Restart cwpsrv

sh /scripts/restart_cwpsrv

4.login to Adminer

https://IP:2031/adm

Tagged: