Related
Join the DigitalOcean Community
Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Install MySQL on New Droplet
Question
Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
Question
Question
Question
Remove only_full_group_by from sql mode
Hello.
I’m trying to remove onlyfullgroupby from sql mode but in the MySQL droplet settings UI
there is no onlyfullgroupby to remove.
Although when I connect to the DB from command line and I run command
SELECT @@sql_mode;
which outputs
REALASFLOAT,PIPESASCONCAT,ANSIQUOTES,IGNORESPACE,ONLYFULLGROUPBY,NOZEROINDATE,NOZERODATE,ERRORFORDIVISIONBYZERO,NOENGINESUBSTITUTION
Which HAS the onlyfullgroup_by !
Any ideas?
Related
Join the DigitalOcean Community
Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
Install MySQL on New Droplet
Question
Question
How can I solve error "SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"
Question
Question
I have the same problem, weird how nobody has responded to this yet…