Command, Fix, MySql

MYSQL: Syntax error or access violation: 1055

So upgraded mysql to new version and started seeing these warnings: PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘db.column_name’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible Method 1: We can fix it by…

Continue Reading

phpMyAdmin - HTTP error 404
Command, Fix, phpMyAdmin

Fix phpMyAdmin – HTTP error 404

phpMyAdmin – HTTP error 404 appears when the server does not find the default phpMyAdmin folder. This can be fixed if you manually download phpMyAdmin or by running the following command on SSH. Wait for command to finish, then reload phpMyAdmin page that gave error to confirm its working again.