500 Internal Server Error - MySQL + CentOS

Linode Staff

Hi there,

After running through this guide I am receiving a 500 internal server error for MySQL. Where should I look to find the root cause?

5 Replies

Watching thread closely.

What do the logs say?

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';

Greetings @bernard,

Glad you were able to sort it out. Most 500 errors are server-side errors.

There can be the following probable reasons :

  1. 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.

  2. PHP Timeout : Timeout rules, or better error handling in your script, should help if this is the cause of the 500 error.

  3. Error in .htaccess : Check if .htaccess is structured properly.

I hope that helps if anything comes up in the future.

-Preston

Reply

Please enter an answer
Tips:

You can mention users to notify them: @username

You can use Markdown to format your question. For more examples see the Markdown Cheatsheet.

> I’m a blockquote.

I’m a blockquote.

[I'm a link] (https://www.google.com)

I'm a link

**I am bold** I am bold

*I am italicized* I am italicized

Community Code of Conduct