SET admin-web_enabled='true';
LOAD ADMIN VARIABLES TO RUNTIME;
SAVE ADMIN VARIABLES TO DISK;
> select * from global_variables where Variable_name like '%stats%';
+-----------------------------------+----------------+
| variable_name | variable_value |
+-----------------------------------+----------------+
| admin-stats_credentials | stats:stats |
| admin-stats_mysql_connections | 60 |
| admin-stats_mysql_connection_pool | 60 |
| admin-stats_mysql_query_cache | 60 |
| admin-stats_system_cpu | 60 |
| admin-stats_system_memory | 60 |
| admin-telnet_stats_ifaces | (null) |
| mysql-servers_stats | true |
| mysql-stats_time_backend_query | false |
| mysql-stats_time_query_processor | false |
| mysql-commands_stats | true |
+-----------------------------------+----------------+
11 rows in set (0.00 sec)
# netstat -tulnp |grep "proxysql"
tcp 0 0 0.0.0.0:6080 0.0.0.0:* LISTEN 1081/proxysql
tcp 0 0 0.0.0.0:6032 0.0.0.0:* LISTEN 1081/proxysql
tcp 0 0 0.0.0.0:6033 0.0.0.0:* LISTEN 1081/proxysql
问题:已经设置开启了,但是用浏览器无法访问,有待进一步研究解决
访问地址:http://x.x.x.x:6080/
账号和密码都是 stats,这个页面只能供查看,不能修改proxysql的运行配置。