mysql中解决“SELECT command denied to user ‘nature‘@‘192.168.1.49‘ for table ‘user_variables_by_thread‘“

前言

… …

原因

普通mysql用户nature对performance_schema数据库的user_variables_by_thread表没有select权限

解决

mysql> grant select on `performance_schema`.user_variables_by_thread to nature@"%";
mysql> flush privileges;

结语

… …