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.
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?
SHOW GRANTS will give you the privileges.
http://dev.mysql.com/doc/refman/5.6/en/user-account-management.html
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.