• 修改主机图板
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