Open Source Web UI for ProxySQL
ProxyWeb is a modern, lightweight web-based interface for ProxySQL, the popular high-performance MySQL proxy. Designed for simplicity and full control, ProxyWeb allows administrators to manage ProxySQL servers, users, query rules, and variables—all through an intuitive web UI.
- Clean and responsive design
- Multi-server support
- Configurable reporting
- Global and per-server options
- Hide unused tables (global or per-server basis)
- Sort content by any column (asc/desc)
- Online config editor
- Narrow-down content search
- Paginate content
- Command history and SQL dropdown menu
- Adhoc MySQL queries
- Basic authentication
- Docker installed on your system
- Git installed
- Basic understanding of ProxySQL and MySQL
With Docker:
docker run -h proxyweb --name proxyweb --network="host" -d proxyweb/proxyweb:latest
git clone https://github.com/miklos-szel/proxyweb
cd proxyweb
make install
Visit http://ip_of_the_host:5000/setting/edit first and adjust the credentials if needed. The default connection is the local one with the default credentials.
ProxySQL only allows local admin connections by default.
In order to enable remote connections you have to enable it in ProxySQL:
set admin-admin_credentials="admin:admin;radmin:radmin";
load admin variables to runtime; save admin variables to disk;
After this we can connect to the ProxySQL with:
- username: radmin
- password: radmin
- port: 6032 (default)
Run:
docker run -h proxyweb --name proxyweb -p 5000:5000 -d proxyweb/proxyweb:latest
Visit http://ip_of_the_host:5000/setting/edit first and edit the servers
section.
Note
Basic authentication is turned on by default in the latest version, default credentials are as follows:
-
username: admin
-
password: admin42
These can be changed by editing the config file.
- ability to edit tables
- better input validation
- Thanks for René Cannaò and the SysOwn team ProxySQL.
- Tripolszky 'Tripy' Zsolt