Magento: high MySQL load at_is_active.value_id > 0

High MySQL load, queries like

SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_a

run:

php -f shell/indexer.php reindexall –all 

nginx + cloudflare ssl = redirect loop solution

server {
   listen         80;
   server_name    example.com

   if ($http_x_forwarded_proto = "http") {
     return 301 https://$server_name$request_uri;
   }

}

SSH key restrict login

no-port-forwarding,no-agent-forwarding,no-X11-forwarding,command="echo 'Please login as the user \"XYZ\" rather than the user \"root\".';echo;sleep 10" KEY

WHM login without root password

whmapi1 create_user_session user=root service=whostmgrd locale=en

grub2 centos 7 rescue

grub> set prefix=(md/md2)/boot/grub2
grub> set root=(md/md2)
grub> insmod linux
grub> normal

The cPanel user X does not exist in the database map.

The cPanel user X does not exist in the database map.

Mysql::initcache failed: adminbin Cpanel/cpmysql/DBCACHE: exit 255

fix:

/scripts/rebuild_dbmap username

EFI grub centos 7

grub2-mkconfig -o /boot/efi/EFI/centos/grub.cfg
yum reinstall grub2-efi grub2-efi-modules  shim

https://community.centminmod.com/threads/grub-help.12867/page-3

without EFI

grub2-mkconfig –o /boot/grub2/grub.cfg

curl domain on ip

curl -v -H "Host: example.com" http://127.0.0.1

Cloudlinux 7 + cPanel - problem with grub on OVH NVMe dedicated

Create symlink:

/etc/grub2.cfg should point to /boot/efi/EFI/centos/grub.cfg

phpmyadmin root cannot login

mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ service mysql restart