I’m building a Next.js application that needs user authentication.
I’m trying to set up a MySQL db in CPanel for that. I am currently mainly interested testing this locally on my laptop.
In CPanel, I used the MySQL wizard, created a user, gave all permissions, then went to the PHPMyAdmin dashboard. Here I imported a .sql file, that adds a “user” table with two users. All this worked well.