I already have a mysqld running on port 3306 on my linux system and want a second instance on a different port. This is a totally different instance, I don't want it to share data tables or anything else with the first instance. I tried running mysqld --defaults-file=config.conf where config.conf is my other config file with the new port and datadir, tried using absolute paths, everything, and kept getting this error: Could not open required defaults file: /PATH_TO_FILE/config.conf Fatal error in defaults handling. Program aborted Can anyone please help me? Everything about --defaults-file I find is about windows, how do I specify a custom config file on linux? Or is it possible to use the --datadir command line option (is there a command line option to specify the port also?) and would that create a totally unrelalted instance of mysqld?

  • Out of curiosity, why do you need to run a separate instance of mysqld? – molecularbear Dec 5 '09 at 6:09
  • Not sure if this helps or hinders his case, but it's a fairly standard practice in the MS SQL Server world; two disparate systems from different vendors that have no need to share data, and might be administered by different employees or supported by different third (fourth? fifth?) parties that don't need to play in each others' sandboxes. An example would be the payroll and patient-data systems in a healthcare environment. – Adrien Aug 31 '10 at 23:31

Does your path contain a tilde (~)? http://bugs.mysql.com/bug.php?id=20597

Alternately, does the user MySQL runs as have permission to access the file?

  • Could SELINUX be blocking access? – Roy Dec 5 '09 at 12:42
  • I don't really know anything about SELinux. I just meant that if your config file isn't owned by mysql you might need to change the owner: sudo chown mysql filename (I don't actually know what user MySQL runs as on your system) – Brendan Long Dec 7 '09 at 4:49

take a look at mysql sandbox. it seems this might be a solution you're looking for.


are you providing the complete /path/to/config.conf ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy