mysql

Turn Off SQL_MODE - ONLY_FULL_GROUP_BY SQL standards says that GROUP BY clause should have table columns, not expression. But MYSQL always allows expression in GROUP BY clause. “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘db.table.col’ which is not...

Error Your Password does not satisfy the Current Policy Requirements One can set many variables for validating a password. The password policy has to be strong if not you will get “Your Password does not satisfy the Current Policy Requirements” error when to try to set any password in MYSQL...

MySQL is among the most common database servers majorly used on Linux the operating systems. It is technically very strong. All the modern applications based on Joomla, WordPress, Magneto, or e-commerce, work very well with MySQL. When MySQL is integrated with Cpanel it is even easier to manage...

Are you trying to check out the MySQL Version on Linux server but dont know exactly how? here is the solution of this problem. MySQL only supports some features in particular version umber only. If you are facing such kind of problem then here are different ways to check MySQL version number...