Anwar

Posts

MySQL How to remove and purge old MySQL binary log files

https://www.casesup.com/category/knowledgebase/howtos/how-to-remove-and-purge-old-mysql-binary-log-files   Contents Step 1: Check  binary  logs  size under the dump directory Step 2:Connect  DB and show  MySQL  binary logs Step 3: Remove  old ...

MySQL How to fix the mysqldump access denied process privilege error

https://dba.stackexchange.com/questions/271981/access-denied-you-need-at-least-one-of-the-process-privileges-for-this-ope   1 Resolve by adding: –column-statistics=0 –no-tablespaces Solution 2: Use the –no-tablespaces option If you cannot assign global level privileges to your user, for example, when...

Mysql ERROR 1419 (HY000) You do not have the SUPER privilege and binary logging is enabled

  ERROR 1419 (HY000) at line 2100: You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the...

Mysql ERROR 1227 (42000) Access denied you need (at least one of) the SUPER, SYSTEM VARIABLES ADMIN or SESSION VARIABLES ADMIN privilege(s) for this operation

aws aurora ERROR 1227 (42000) at line 9311: Access denied; you need (at least one of) the SUPER privilege(s) for this operation   https://stackoverflow.com/questions/44015692/access-denied-you-need-at-least-one-of-the-super-privileges-for-this-operat  ...

Mysql DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled

https://stackoverflow.com/questions/26015160/deterministic-no-sql-or-reads-sql-data-in-its-declaration-and-binary-logging-i   There are two ways to fix this: Execute the following in the MySQL console: SET GLOBAL log_bin_trust_function_creators = 1; Add the following to...

Mysql Access denied; you need (at least one of) the PROCESS privilege(s) for this operation

https://dba.stackexchange.com/questions/271981/access-denied-you-need-at-least-one-of-the-process-privileges-for-this-ope mysqldump requires at least the SELECT privilege for dumped tables, SHOW VIEW for dumped views, TRIGGER for dumped triggers, LOCK TABLES if the –single-transaction option...

MI 3 Router Reset

https://c.mi.com/thread-2109621-1-0.html You just need to reflash the R3P: 1) Copy the ROM (bin file) to a USB key. Latest english ROM : miwifi_r3p_all_b9683_2.10.46_INT.bin Latest stable...

Memcached or Redis for WordPress caching

https://blog.kernl.us/2020/02/should-i-use-memcached-or-redis-for-wordpress-caching/#:~:text=Memcached%20Performance&text=The%20Memcached%20response%20time%20is,it’s%20likely%20a%20configuration%20problem

Magento ver. 1.9.2.0 to 1.9.2.2 update

http://www.webcitz.org/magento-tips/ This Magento upgrade tutorial will help guide you through the process of updating / upgrading your Magento installation from 1.4+ to 1.9.2.1. which was...