程序在调用到数据库的视图时报错,直接在数据库中打开视图时也报错,相似:mysql
经查,是权限问题,解决办法:sql
运行:grant all privileges on *.* to monitor@"%" identified by ".";数据库
以后打开视图时便不会报错,程序调用也不会报错。ide
权限问题,受权 给 root ?全部sql 权限spa
mysql> grant all privileges on *.* to root@"%" identified by ".";ci
Query OK, 0 rows affected (0.00 sec)get
mysql> flush privileges;it
Query OK, 0 rows affected (0.00 sec)权限