Bug #59881 my.cnf is not recognized
Submitted: 2 Feb 2011 4:39 Modified: 23 May 2011 3:08
Reporter: ws lee Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.5.8 OS:Solaris (SunOS 5.10)
Assigned to: CPU Architecture:Any

[2 Feb 2011 4:39] ws lee
Becasuse of using multi mysql version same server, my.cnf locate at /usr/local/mysql5.1.51/my.cnf and /usr/local/mysql5.5.8/my.cnf
I am not using /etc/my.cnf.

In mysql 5.5.8, 
my.cnf of /usr/local/mysql5.5.8/ 
is not recognized.

How to repeat:
/usr/local/mysql5.1.51/mysql.server start 
this command no problem.

/usr/local/mysql5.5.8/mysql.server start 
but, this command is error.
my.cnf of /usr/local/mysql5.5.8/ is not recognized.
[7 Feb 2011 16:28] Valeriy Kravchuk
Please, execute mysqld from 5.5.8 with --verbose --help options and send first 20 rows of the output, like this:

bin/mysqld --verbose | head -20
[8 Feb 2011 0:15] ws lee
Thanks Kravchuk!
I send mysqld --verbose result.

./bin/mysqld --verbose --help | head -20
110208  9:14:17 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

./bin/mysqld  Ver 5.5.8 for solaris10 on i386 (MySQL Community Server (GPL))
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Starts the MySQL database server.

Usage: ./bin/mysqld [OPTIONS]

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf /usr/local/mysql/etc/my.cnf ~/.my.cnf 
The following groups are read: mysqld server mysqld-5.5
The following options may be given as the first argument:
--print-defaults        Print the program argument list and exit.
--no-defaults           Don't read default options from any option file.
--defaults-file=#       Only read default options from the given file #.
--defaults-extra-file=# Read this file after the global files are read.

110208  9:14:17 [ERROR] Aborting
[8 Feb 2011 15:04] Valeriy Kravchuk
Looks like basedir is set differently on 5.5.8. Please, compare the output of:

show variables like '____dir';

from 5.1.x and 5.5.8 (if you can start it). 

You can just set basedir to /usr/local/mysql5.5.8 in the mysql.server script (see http://bugs.mysql.com/bug.php?id=51264).
[9 Feb 2011 3:46] ws lee
To. Kravchuk

mysql> show variables like '____dir';
| Variable_name | Value                      |
| basedir       | /usr/local/mysql5.5.8      |
| datadir       | /var/lib/mysql/mysql5.5.8/ |

I have setting already the mysql.server file.
# If you change base dir, you must also change datadir. These may get
# overwritten by settings in the MySQL configuration files.

[22 May 2011 16:45] Valeriy Kravchuk
Please, check if the same problem still happens with a recent version, 5.5.12. If it does, please, check if you have my.cnf in /var/lib/mysql/mysql5.5.8 (datadir).
[23 May 2011 2:50] ws lee
Thanks. this bug is likely to in 5.5.12.

By the way,
please check 
[23 May 2011 2:54] ws lee
Thanks. It seems to fix in 5.5.12.

By the way,
please check 
[23 May 2011 3:08] Valeriy Kravchuk
Not repeatable with 5.5.12.