Error connecting mySQL database to nextjs project

I’m trying to connect my MySQL database, set up using this tutorial
https://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial-creating-a-model.html
Along with creating the model, I created a running server using the tutorial listed in the model tutorial. I’ve created a table inside of it and populated it with a few values.

Now I’m trying to use the javascript library mysql, this is my code:

var mysql = require('mysql');

var con = mysql.createConnection({
  host: "localhost",
  user: "admin",
  password: "mypassword",
  database: "album"
});

con.connect(function(err) {
    if (err) throw err;
    console.log("Connected!");
  });

I get the error "Error: ER_DBACCESS_DENIED_ERROR: Access denied for user ‘admin’@’localhost’ to database ‘album’"

I looked into this issue and have tried everything I could find to fix it. I’ve gotten rid of the database field in the call, passed in an empty string as the password, added more users with different ids/passwords and tried to get in that way. I’ve used the
ALTER USER ‘admin’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘mypassword’;
which didn’t seem to change any of the permissions associated with the ‘admin’ user.

"admin" was the name I set for the main user in my DB. The DB is called MyFirstConnection and the Schema is called "album". Any advice helps!