1. bhawanisingh


    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...
  2. bhawanisingh

    [RESOLVED] MySQL Error : "Your Password does not satisfy the Current Policy Requirements"

    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...
  3. bhawanisingh

    How To Secure MySQL Server On Cpanel?

    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...
  4. bhawanisingh

    How to check MySQL version ?

    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...