mysql

  1. H

    How to change the database engine of a MySQL database table from MyISAM to InnoDB?

    You can run following SQL query in SSH or PhpMyAdmin : ALTER TABLE tablename ENGINE = InnoDB;
  2. Bhawani Singh

    Turn Off SQL_MODE - ONLY_FULL_GROUP_BY

    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...
  3. Bhawani Singh

    [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...
  4. Bhawani Singh

    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...
  5. Bhawani Singh

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