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!