Databases – My IT Engineer

Fleet – Error creating DB connection

Problem You receive the following error Error creating db connection: this authentication plugin is not supported when running command: sudo

Problem You need to bind multiple IP addresses to your elastic search host, following the documentation network.bind_host: “IP Address” Solution

Problem You get the following error when executing scripts ERROR 1820 (HY000) at line 20: You must reset your password

Problem Immediately after installing MySQL you attempt to log in with the system root or admin account but it fails,

Problem You need to use SQL management or other tools and need to sign in but you have no access

Problem You need to upgrade PHP from 5.5 to 5.6 or 7.0 Solution From the command line type # add-apt-repository

Problem You upgraded PHP and now have the following error: Your PHP installation appears to be missing the MySQL extension

To quickly view your status try the following commands sudo /etc/init.d/mysql status To stop or start issue one of the

Repair and optimize all tables After upgrading the MySQL server there are times when weird bugs would be seen with

How to Backup and or Restore your MySQL Database Using phpMyAdmin Backup your MySQL Database Log into your hosting or