500 Internal Server Error - MySQL + CentOS
Here's the content of /var/log/mysqld.log :
2019-01-27T19:21:41.828280Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.14) MySQL Community Server - GPL.
2019-01-27T19:21:43.233106Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.14) starting as process 16038
2019-01-27T19:21:43.789550Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-01-27T19:21:43.824321Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.14' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server - GPL.
2019-01-27T19:21:43.926121Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
I fixed the issue with this :
alter user 'username'@'localhost' identified with mysql_native_password by 'password';
Glad you were able to sort it out. Most 500 errors are server-side errors.
There can be the following probable reasons :
Permission Error : Check permission of files and folders. In most of those cases, an incorrect permission on a PHP and CGI script is to blame.
PHP Timeout : Timeout rules, or better error handling in your script, should help if this is the cause of the 500 error.
Error in .htaccess : Check if .htaccess is structured properly.
I hope that helps if anything comes up in the future.