Problems connecting Node Express in Mysql

0

I know that my project is correct that there is nothing wrong, I think the problem is my newly installed bank, how can I solve this problem?

Unhandled rejection SequelizeConnectionError: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at Utils.Promise.tap.then.catch.err (C:\SQL\node_modules\sequelize\lib\dialects\mysql\connection-manager.js:149:19)
    at tryCatcher (C:\SQL\node_modules\bluebird\js\release\util.js:16:23)
    at Promise._settlePromiseFromHandler (C:\SQL\node_modules\bluebird\js\release\promise.js:512:31)
    at Promise._settlePromise (C:\SQL\node_modules\bluebird\js\release\promise.js:569:18)
    at Promise._settlePromise0 (C:\SQL\node_modules\bluebird\js\release\promise.js:614:10)
    at Promise._settlePromises (C:\SQL\node_modules\bluebird\js\release\promise.js:689:18)
    at Async._drainQueue (C:\SQL\node_modules\bluebird\js\release\async.js:133:16)
    at Async._drainQueues (C:\SQL\node_modules\bluebird\js\release\async.js:143:10)
    at Immediate.Async.drainQueues [as _onImmediate] (C:\SQL\node_modules\bluebird\js\release\async.js:17:14)
    at runCallback (timers.js:696:18)
    at tryOnImmediate (timers.js:667:5)
    at processImmediate (timers.js:649:5)
    
asked by anonymous 30.07.2018 / 12:48

1 answer

1

According to the answer to the question MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client :

  

Run the following query on MySQL Workbench

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password'
     

Try to reconnect Node.js after doing so

    
30.07.2018 / 13:27