Lost Connection to MySQL Server During Query Error
If my.cnf is set to bind to 127.0.0.1 as the IP address, it means access is only possible from localhost. To solve this, open the my.cnf file and either comment out the bind-address = 127.0.0.1 line or change 127.0.0.1 to 0.0.0.0. This allows external access but remember to be cautious about security.
Client Does Not Support Authentication Protocol Requested by Server; Consider Upgrading MySQL Client
This error occurs when the version of MySQL referenced by the compiled Apache is different from the version of the MySQL daemon currently running. This isn’t just any error; it's because the password function in MySQL has changed between old and newer versions. To use the old password function in a newer version, you would need to reset the password using old_password.
To reset the password as old_password, use the following command:
SET PASSWORD FOR username@host = OLD_PASSWORD('password');
Example) SET PASSWORD FOR abc@'%' = OLD_PASSWORD('123123');