- 修改主机图板
update dashboard set data = replace(data,'$host','$ip')
update dashboard set data = replace(data,'instance','ip')
- 修改MySQL图板
update dashboard set data = replace(data,'instance="$host"','ip="$ip",port="$port"') where slug like 'mysql%' and plugin_id='pmm-app';
replace函数
: http://www.mysqltutorial.org/mysql-string-replace-function.aspx