Bug #29599 mysql_install_db incorrectly quotes arguments
Submitted: 6 Jul 2007 13:59 Modified: 6 Jul 2007 20:43
Reporter: Mathias Gug Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.0.41 OS:Linux
Assigned to: CPU Architecture:Any

[6 Jul 2007 13:59] Mathias Gug
Description:
The mysqld_install_db script fails if extra arguments are passed.
 
Reported in Ubuntu:
https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/107466

How to repeat:
1. Try to make a new database, for example using the following command line:

/usr/bin/mysql_install_db --no-defaults --bind-address=127.0.0.1 --character-set-server=utf8 --console --datadir=/tmp/mysqlfoo.db --port=3307 --log=/tmp/mysqlfoo.log --socket=/tmp/mysqlfoo.socket

Expected results:
 1. Database created in /tmp/mysqlfoo.db, no errors

Actual results:
 1. mysql_install_db script fails with:

Installing MySQL system tables...
070418 13:49:41 [ERROR] /usr/sbin/mysqld: unknown variable 'bind-address\=127.0.0.1'

Installation of system tables failed!

Suggested fix:
The reason is that in the past, this script had to double-quote the args that it was passed, because it then invoked mysqld inside a bash "eval" statement. Now it has been restructured.

https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.0/+bug/107466 has a patch attached to remove unnecessary seddy quotation.
[6 Jul 2007 20:43] Sveta Smirnova
Thank you for the report.

Bug is repeatable with version 5.0.41, but not repeatable with current development sources. Please wait next release.