Join 1M+ other developers and:
- Get help and share knowledge in Q&A
- Subscribe to topics of interest
- Get courses & tools that help you grow as a developer or small business owner
ERROR 1006 (HY000): Can't create database
I run mysql using mysql -u root -p
And then try to create database using : create database acp;
But then I get an error saying : ERROR 1006 (HY000): Can’t create database ‘acp’ .
I changed the permission and owner:group of /var/lib/mysql and all it’s sub directories to mysql:mysql and gave permissions 755 and even tried once with 777 but still the same error :(.
Request some one to please guide me in the right direction. Thank you!
P.S - I followed the LAMP installation tutorial on Digital Ocean and everything else has been setup properly!
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.×