Trouble creating database in step 4 of "Installing Magento 2.3 with Web Server"

In step 4 of “Installing Magento 2.3 with a Web Server”, I am getting an error when creating the database and user in Phpmyadmin:

#1044 - Access denied for user ‘supermysql’@‘localhost’ to database ‘magento-altisimo’

I followed the instructions in “Cannot log into Phpmyadmin as root user” to create the superuser (supermysql), but I cannot figure out why I am getting the error. I did notice that although my “supermysql” user is listed as having “all privileges” in phpmyadmin, the user lacks “grant” privileges. If that is the problem, I cannot figure out how to give the user “grant” privileges in order to grant my “magento-altisimo” user “all privileges”.

Disregard this request…I am not sure what the problem was, but I decided to create the user and database separately in terminal, and then give the user full rights to the database there, and that seemed to do the trick.

1 Like