How to remove ONLY_FULL_GROUP_BY using mysql terminal
When you are running a multiple PHP applications around the same Database you might get this error which results in not rendering the block. Here is a quick fix for it.
How to Fix MySQL Unknown collation error utf8mb4_0900_ai_ci
Unknown Collation error usually arrises when you try to move a DB from a higher mysql version e.x, 8.0 to a lower mysql version e.x, 5.7
How To upgrade MySQL 5.4 to MySQL 8.0 on Ubuntu Server
Upgrading to MySQL 8.0 from MySQL 5.7 offers several benefits such as improved performance, better security, and better support for JSON and spatial data. The upgrade process is straightforward, and you can follow the steps outlined in this blog