Problem You receive the following error Error creating db connection: this authentication plugin is not supported when running command: sudo
Category: Databases
ElasticSearch: Allow binding to multiple addresses
Problem You need to bind multiple IP addresses to your elastic search host, following the documentation network.bind_host: “IP Address” Solution
MySQL – Alter root password – ERROR 1820 (HY000)
Problem You get the following error when executing scripts ERROR 1820 (HY000) at line 20: You must reset your password
MySQL – Root password after new installation
Problem Immediately after installing MySQL you attempt to log in with the system root or admin account but it fails,
SQL – Reset SA password (no other admin access)
Problem You need to use SQL management or other tools and need to sign in but you have no access
PHP Upgrade – PHP 5.5 to 5.6 or 7.0
Problem You need to upgrade PHP from 5.5 to 5.6 or 7.0 Solution From the command line type # add-apt-repository
PHP Upgrade – Missing mysql extension
Problem You upgraded PHP and now have the following error: Your PHP installation appears to be missing the MySQL extension
MySQL – Start and status in Linux/Unix
To quickly view your status try the following commands sudo /etc/init.d/mysql status To stop or start issue one of the
MySQL – Repair and optimize tables
Repair and optimize all tables After upgrading the MySQL server there are times when weird bugs would be seen with
MySQL- Backup and or Restore your MySQL Database Using phpMyAdmin
How to Backup and or Restore your MySQL Database Using phpMyAdmin Backup your MySQL Database Log into your hosting or