Host '127.0.0.1' is not allowed to connect to this MySQL server using node js

Asked Jul 04 '20 at 13:59

Active Jul 04 '20 at 14:02

Viewed 1,205 times

i am using Mac Machine. and using Bitnami MAMP stack 7.2 for create Database in MYSQL , here is link for that Mysql database access : http://localhost:8080/phpmyadmin/db_structure.php?server=1&db=liodb

its working fine , my requirement is connect this local database to my node application here is my connection code in node js

    var mysql = require('mysql');
    var con = mysql.createConnection({
    host: "localhost",
    port: '3306',
    user: "lio_user",
    password: "lio123456",
    database:  'liodb'
   });

but i am not able to connect getting error

  code: 'ER_HOST_NOT_PRIVILEGED',
  errno: 1130,
  sqlMessage: "Host '127.0.0.1' is not allowed to connect to this 
  MySQL server",
  sqlState: undefined,
  fatal: true

edited Jul 04 '20 at 14:02

xMayank

1,875
2
5
19

asked Jul 04 '20 at 13:59

Deepak Goud

but mysql port is `3306` – xMayank Jul 04 '20 at 14:02
Yes and i am using same – Deepak Goud Jul 04 '20 at 14:03
now i got the solution : we should add adapter: 'sails-mysql', socketPath : '/Applications/mampstack-7.2.22-0/mysql/tmp/mysql.sock' in our connection code in js – Deepak Goud Jul 04 '20 at 15:13
I was also looking for such an error and found a good answer here: https://stackoverflow.com/a/67574175 – zubovd Jan 10 '22 at 08:56

Host '127.0.0.1' is not allowed to connect to this MySQL server using node js

0 Answers0