ER_NOT_SUPPORTED_AUTH_MODE - sails 1.0 and MySQL 8.0

Question

I'm trying to connect SailsJS with MySQL

default: {
  adapter: require('sails-mysql'),
  url: 'mysql://root:root@localhost/ventas'
},

But whenever I do a 'sails lift' I get the following error:

error: A hook (`orm`) failed to load!
error:
error: { error:
   { Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Handshake.Sequence._packetToError (C:\ticket\node_modules\mysql\lib\protocol\sequences\Sequence.js:48:14) }

I'm just using the web app template that comes with sails with no added code.

Any ideas?

score 2 · Answer 1 · answered Dec 19 '19 at 11:13

2

The problem may be with encrypting the password. MySQL 8.0 uses caching_sha2_password. You need change it to mysql_native_password:

ALTER USER 'user' identified with mysql_native_password BY 'password';

answered Dec 19 '19 at 11:13

Aliaksei

1,094
11
20

score 0 · Accepted Answer · answered Apr 27 '18 at 09:31

0

The problem is coming from mysql, you need to change the plugin to mysql_native_password and then flush privileges;, see here and here.

answered Apr 27 '18 at 09:31

Hamza Fatmi

1,235
8
10

score -2 · Answer 3 · answered Aug 26 '19 at 16:51

-2

Set your password to one with Upper case , lower case, numeric and a special character in it with 8 letters long .

answered Aug 26 '19 at 16:51

Sudheesh A.S

1

ER_NOT_SUPPORTED_AUTH_MODE - sails 1.0 and MySQL 8.0

3 Answers3