Ghost crashed for no reason

Developer help
1

We have a new blog on that has been up for two weeks on http://hakeem.meddy.com. All of a sudden, just one day it gives me the following error:
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Here are my versions
Ghost-CLI version: 1.11.0
Ghost version: 2.25.1
mysql Ver 14.14 Distrib 5.7.27, for Linux (x86_64) using EditLine wrapper

I set up ghost on DigitalOcean by myself not through the marketplace.
This is happening on all browsers.

2

Hey there! Would you be able to check if there are any logs or more information within your DigitalOcean dashboard?

3

The logs for MySQL is only showing me this message
2019-07-25T09:22:41.446703Z 276 [Note] Client does not support authentication protocol requested by server; consider upgrading MySQL client

Is there something I can do that would quickly get this back up

4

I checked the MySQL version that I have and it’s 5.7.27 but that was released 3 days ago. It seems like it decided to update on its own.

https://dev.mysql.com/doc/relnotes/mysql/5.7/en/news-5-7-27.html

I didn’t upgrade it, I’m not sure how it upgraded on it’s own, but this seems to be the problem.

5

Error: ER_NOT_SUPPORTED_AUTH_MODE with auth_socket · Issue #1507 · mysqljs/mysql · GitHub this is the reason. I’m unsure why it happened all of a sudden but following this thread fixed everything form me.

2 Likes
6

Hi,
The github solution says:

use mysql;
update user set authentication_string=password(''), plugin='mysql_native_password' where user='root';

What commands to type in terminal? the “user” field should type root or nonrooted-user?
I use docker-compose
I am not professional admin.

7 
command: --default-authentication-plugin=mysql_native_password

solved