mysql_install_db: Can't create test file *.lower-test

When I install MySQL on an Ubuntu machine, I tend to move MySQL's data and temp directories to another locations on a bigger partition that the root's.

 But even after setting the correct user permissions to the new data directory, attempting to initialize the data directory to have mysql and information_schema schemas will fail, not due to not enough direcotry permissions as the error suggests, but for the security application apparmor that is installed by default with Ubuntu.

 I have no interest in using this application but you probably do so you may no want to apply this solution.

/etc/init.d/apparmor stop/etc/init.d/apparmor update-rc.d -f apparmor removeapt-get purge apparmorreboot
>> Apply this solution at your own risk  <<

Comments

Post a Comment

Popular posts from this blog

Hosting Apache Tapestry5.1 on GAE (Google App Engine)

Image
Assalam Alikom In this post, I'll try to explain the steps I took to host Tapestry5.1 on google app engine. First of all here is my application . A very good place to start is here . This page will help you know what will, won't or will partially work on Google app engine. Now straight to tapestry5.1 stuff .. 1)AppModule.java public class AppModule { public static void contributeApplicationDefaults(MappedConfiguration config)   {   config.add(SymbolConstants.PRODUCTION_MODE, "false"); // This mainly affects how exceptions are reported, I'm   not sure - and I don't think - its vital to host tapestry   on GAE.   config.add("tapestry.thread-pool-enabled", "false"); //Now this is a must !, GAE restriction.   config.add(SymbolConstants.APPLICATION_VERSION, "0.1"); // This is to override the random number generated by tapestry in assets paths  } } 2)There as a compatibility issue between tapestry5 and GAE, that's wh...
Read more

Testing SOAP services using pingdom

This post  gives half the answer I needed to test SOAP services . The other half of the answer was to override the default Content-Type HTTP header added by pingdom  (Check the 11th point in the Optional Parameters section). To override the header, just add one with a blank space. This worked for me and may be for you too. Also another thing I had to do while testing web services developed using Apache Axis (I don't know which version), is that I had to specify a SOAPAction header with the value ""  (The value is 2 double quotes, not an empty value) Generally, you need successfully send a POST request to the service and find out what HEADER you are missing (i.e. to add it) or adding (i.e. to remove it). You can use SOAP UI to do that. But SOAP UI doesn't show sent HEADER by default, so you'll need to download TCPMon (Which records and displays communications), start it, and let it proxy connections on a specific port, then configure SOAP UI to use that po...
Read more