MySQL Bugs: #56779: Warning produced when running mysqld --version

Bug #56779	Warning produced when running mysqld --version
Submitted:	14 Sep 2010 20:56	Modified:	14 Sep 2010 22:54
Reporter:	Dimitriy A	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.1.50-enterprise-gpl-advanced	OS:	Linux (SuSE 9)
Assigned to:		CPU Architecture:	Any
Tags:	server, version, warning

Description:
Running "mysqld --version" should not be producing any warnings.

The following output is produced:
100914 13:47:01 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead.
./mysqld  Ver 5.1.50-enterprise-gpl-advanced for unknown-linux-gnu on x86_64 (MySQL Enterprise Server - Advanced Edition (GPL))

How to repeat:
Untar MySQL for Linux distribution. Change directory to "mysql-advanced-gpl-5.1.50-linux-x86_64-glibc23/bin". Run "./mysqld --version".

Suggested fix:
Output should only contain the following:
./mysqld  Ver 5.1.50-enterprise-gpl-advanced for unknown-linux-gnu on x86_64 (MySQL Enterprise Server - Advanced Edition (GPL))

Do you have a my.cnf? If yes please print here. Thanks in advance,

[miguel@tikal ~]$ dbs/5.1/libexec/mysqld --version
dbs/5.1/libexec/mysqld  Ver 5.1.51-debug for unknown-linux-gnu on x86_64 (Source distribution)
[miguel@tikal ~]$

Thanks for quick reply. I do see that there is /etc/my.cnf file that was probably put in by installing MySQL 5.0.44sp1 from rpm and that is what is causing the warning. I am also using non-rpm MySQL 5.1.50 as I am running multiple MySQL versions on the same server.

mysqld should not be trying to parse any my.cnf files, since all I'm asking is just the version.

In my case I see a workaround - delete /etc/my.cnf file. I do not use /etc/my.cnf for configuration, I use custom location for that file regardless of version of MySQL. Other people might still be using /etc/my.cnf file.

Hewe is a snippet of /etc/my.cnf.

================== Start of /etc/my.cnf ==================
# Example mysql config file for medium systems.
# 
# This is for a system with little memory (32M - 64M) where MySQL plays
# a important part and systems up to 128M very MySQL is used together with
# other programs (like a web server)
#
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /var/lib/mysql) or
# ~/.my.cnf to set user-specific options.
#
# One can in this file use all long options that the program supports.
# If you want to know which options a program support, run the program
# with --help option.

# The following options will be passed to all MySQL clients
[client]
#password       = your_password
port            = 3306
socket          = /var/lib/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 16M
max_allowed_packet = 1M
table_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
myisam_sort_buffer_size = 8M

Thank you for the feedback.

This is duplicate of bug #30970