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
[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 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
[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. basedir=/usr/local/mysql5.5.8 datadir=/var/lib/mysql/mysql5.5.8 -----------
[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 http://bugs.mysql.com/bug.php?id=59880
[23 May 2011 2:54]
ws lee
Thanks. It seems to fix in 5.5.12. By the way, please check http://bugs.mysql.com/bug.php?id=59880
[23 May 2011 3:08]
Valeriy Kravchuk
Not repeatable with 5.5.12.