2、若依项目本地开发环境可以正常运行,部署到Nginx之后总是报500错误,原因是没有配置生产环境路由,在nginx.conf中添加以下代码:
1、Mysql无法通过Navicat远程连接数据库,于是参考网上给用户授权的SQL:
授权法。例如,你想myuser使用mypassword从任何主机连接到mysql服务器的话。
GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;
参考:解决ERROR 1130: Host '192.168.1.3' is not allowed to connect to this MySQL server 方法_july_2的博客-CSDN博客
但报如下异常:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IDENTIFIED BY 'test123' WITH GRANT OPTION' at line 1
问题原因:新版的的mysql版本已经将创建账户和赋予权限的方式分开了。
解决方法:
create user 'username'@'%' identified by 'password';
GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' ;