Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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?

share|improve this question
    
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

3 Answers 3

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?

share|improve this answer
    
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.

share|improve this answer

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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.