Problem You receive the following error Error creating db connection: this authentication plugin is not supported when running command: sudo
Category: MySQL
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,
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
MySQL – Dump all databases
If you ever need to backup all your MySQL databases at the same time use the following command mysqldump -u
MySQL – “unknown” architecture (Windows)
Problem You need to upgrade your MySQL but the state/status is MySQL 5.x has “unknown” architecture Solution Download and run