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.
Jump to PostYou've set up user garrett previously? You've granted garrett the correct permissions?
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.