mysql
lensko
这个作者很懒,什么都没留下…
展开
-
Mac上MySQL报错:ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'
连接MySQL显示mysql -uroot -p ERROR 2002 (HY000): Can’t connect to local MySQLserver through socket ‘/tmp/mysql.sock’这种错误是因为不能通过socket文件连接mysql服务器,先说解决方案,有两种:1、执行 sudo ln -s /Applications/MAMP/Librar...原创 2019-10-15 16:55:40 · 1337 阅读 · 0 评论 -
Syntax error or access violation: 1055 Expression #1 of SELECT list is not in GROUP BY clause and
set global sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION’;set session sql_mode=‘STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,...原创 2019-09-25 08:53:32 · 1864 阅读 · 0 评论