Custom DB MySQL for WordPress. Login script is adding a new user instead of login in

Help
1

When I login to wordpress using the Auth0 Plugin and the Auth0 interface it creates a new user instead of login in with the provided email and password. I am using a Custom DB with MySQL. This is my script. Any ideas why? Thanks!

function login(email, password, callback) {
console.log("Executing Get User script...");
var connectionConfiguration = {
host: configuration.DB_HOST,
user: configuration.DB_USER,
password: configuration.DB_PASSWORD,
database: configuration.DB_NAME,
};
console.log("Preparing connection to DB...");
var mysql_b = require('mysql');
var connection = mysql_b.createConnection(connectionConfiguration);

```
connection.connect();
```

var query = "SELECT id, user_email, user_pass, user_nicename " +
"FROM wp_users WHERE user_email = user_email";

connection.query(query, [email], function (err, results) {
if (err) return callback(err);
if (results.length === 0) return callback(new WrongUsernameOrPasswordError(email));
var user = results[0];

```
bcrypt.compare(password, user.user_pass, function (err, isValid) {
  if (err) {
    callback(err);
  } else if (!isValid) {
    callback(new WrongUsernameOrPasswordError(email));
  } else {
    callback(null, {
      id: user.id.toString(),
      nickname: user.user_nicename,
      email: user.user_email
    });
  }
});
```

});
}
2

Hey there!

Sorry for such delay in response! We’re doing our best in providing the best developer support experience out there, but sometimes the number of incoming questions is just too big for our bandwidth. Sorry for such inconvenience!

Do you still require further assistance from us?