Saturday, December 26, 2015

Delete mysql user and revoke all privileges properly in mysql

If you want to remove all the privileges and start totally from scratch do the following:

    Revoke all privileges on database level:

    REVOKE ALL PRIVILEGES ON dbname.* FROM 'username'@'hostname';

    Drop the user:

    DROP USER 'username'@'hostname';

Above procedure will entirely remove mysql user from your instance, this means you can recreate him from scratch.

Wednesday, December 16, 2015

Attribute options are not deleting in magento

It may happen due to lesser php value of max_input_variable.

To fix this problem open .htaccess file of magento's document root and write this in it:

php_value max_input_vars 2500
You can also do the same by adding/changing max_input_vars value from active php.ini of your server.
max_input_vars = 2500