长期维护,集中收集一些错误:
集成fly way时启动项目,mysql报:
SELECT command denied to user 'yc_program'@'xxxxxxxxx' for table '4user_variables_by_thread'
意思是:要操作4user_variables_by_thread
这张表,但是没权限。
解决办法:
mysql -uroot -hxxx.xxx.xxx.xxx -p3306
登陆mysql客户端use mysql;
使用mysql db
select * from user where user = 'xxx';
查看当前xxx
的用户权限
update user set Select_priv = 'Y' where user = xxx';
将Select_priv
设置为Y