止语博客

2020-8-6阅读(2161)评论(2)

框架内查询一条数据，发现只要有unique这个字段，就会查询失败，报: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB ...

2018-12-29阅读(1120)评论(0)

需要开启远程连接权限首先在虚拟机中连接你的MySQL：mysql -uroot -p密码 GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION; 运行完命令后，你可以选择重启mysql或者运行下面的命令使上条命令生效： flush privilege...