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.×