When I try to create a database with a non root user of MySQL I get this error.

-> MariaDB [(none)]> create database cl_db;
-> ERROR 1044 (42000): Access denied for user 'garrett'@'localhost' to database 'cl_db'

How do I allow my recular username to create databases? Thanks.

Member Avatar

You've set up user garrett previously? You've granted garrett the correct permissions?

Yes, the user garrett is a user that I have already created. How do I change permissions so that my user can create databases?