MySQL Bugs: #59881: my.cnf is not recognized

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:	None
Category:	MySQL Server: Installing	Severity:	S3 (Non-critical)
Version:	5.5.8	OS:	Solaris (SunOS 5.10)
Assigned to:		CPU Architecture:	Any

Description:
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.

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

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
owners.

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

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).

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.

basedir=/usr/local/mysql5.5.8
datadir=/var/lib/mysql/mysql5.5.8
-----------

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).

Thanks. this bug is likely to in 5.5.12.

By the way,
please check 
http://bugs.mysql.com/bug.php?id=59880

Thanks. It seems to fix in 5.5.12.

By the way,
please check 
http://bugs.mysql.com/bug.php?id=59880

Not repeatable with 5.5.12.