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
After upgrading to Ubuntu20 from Ubuntu18, mysql is not working.
I upgraded from Ubuntu 18 to Ubuntu 20. mySQL upgrade failed during the upgrade.
After the upgrade, I again tried to install mysql-server. I’m getting the below error:
Error while setting value 'STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'.
Command used:
sudo apt install mysql-server
I used the above command after upgrade to Ubuntu20.
I even tried to edit the configuration, but that didn’t help.
[mysqld]
sql_mode="STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION"
Added the above two lines in /etc/mysql/mysql.cnf.
Add a comment
edited by bobbyiliev
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
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×