如何使我的Node.js MySQL connection as promise正常工作？

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'password',
  database: 'mydatabase'
});

connection.connect((error) => {
  if (error) {
    throw error;
  }
  console.log('Connected to MySQL database');
});

function executeQuery(query) {
  return new Promise((resolve, reject) => {
    connection.query(query, (error, results) => {
      if (error) {
        reject(error);
      } else {
        resolve(results);
      }
    });
  });
}

executeQuery('SELECT * FROM users')
  .then((results) => {
    console.log(results);
  })
  .catch((error) => {
    console.error(error);
  });