Advertisement
Guest User

Untitled

a guest
Feb 28th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.82 KB | None | 0 0
  1. `enter code here`const express = require('express');
  2. `enter code here`const app = express();
  3. `enter code here`const mysql = require('mysql');
  4.  
  5. `enter code here`const mysqlConnection = mysql.createConnection({
  6. `enter code here` host: 'localhost',
  7. `enter code here`user: 'root',
  8. `enter code here`password: 'Allah786Ah1',
  9. `enter code here`database: 'movielist'
  10.  
  11. `enter code here`});
  12.  
  13. `enter code here`mysqlConnection.connect(err=>{
  14. `enter code here` if (err) {
  15. `enter code here` throw err;
  16. `enter code here`}
  17. `enter code here`console.log("Its connected");
  18. `enter code here`});
  19.  
  20. `enter code here`app.get("/", (req, res) => {
  21. `enter code here` console.log("I am here");
  22. `enter code here` res.send("Welcome to the API");
  23. `enter code here`});
  24.  
  25. `enter code here`app.post("/name", (req, res) => {
  26. `enter code here` res.send("the name is frank");
  27. `enter code here`});
  28. `enter code here`// localhost:3000
  29. `enter code here`app.listen(3000,() => {
  30. `enter code here` console.log('We got it running');
  31. `enter code here`});
  32.  
  33. `enter code here`module.exports = app;
  34.  
  35. Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
  36. at Handshake.Sequence._packetToError (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibprotocolsequencesSequence.js:47:14)
  37. at Handshake.ErrorPacket (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibprotocolsequencesHandshake.js:124:18)
  38. at Protocol._parsePacket (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibprotocolProtocol.js:278:23)
  39. at Parser.write (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibprotocolParser.js:76:12)
  40. at Protocol.write (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibprotocolProtocol.js:38:16)
  41. at Socket.<anonymous> (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibConnection.js:91:28)
  42. at Socket.<anonymous> (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibConnection.js:502:10)
  43. at emitOne (events.js:116:13)
  44. at Socket.emit (events.js:211:7)
  45. at addChunk (_stream_readable.js:263:12)
  46. --------------------
  47. at Protocol._enqueue (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibprotocolProtocol.js:144:48)
  48. at Protocol.handshake (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibprotocolProtocol.js:51:23)
  49. at Connection.connect (C:UsersAdil AliclientServernodejs_restapinode_modulesmysqllibConnection.js:118:18)
  50. at Object.<anonymous> (C:UsersAdil AliclientServernodejs_restapiapp.js:13:17)
  51. at Module._compile (module.js:652:30)
  52. at Object.Module._extensions..js (module.js:663:10)
  53. at Module.load (module.js:565:32)
  54. at tryModuleLoad (module.js:505:12)
  55. at Function.Module._load (module.js:497:3)
  56. at Function.Module.runMain (module.js:693:10)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement