Bug #60661 New Install Fails
Submitted: 26 Mar 2011 20:25 Modified: 26 Mar 2011 21:02
Reporter: Larry D. Wilson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S1 (Critical)
Version:5.5.10 OS:Linux (Ubuntu 10.10)
Assigned to: CPU Architecture:Any
Tags: install quick fail

[26 Mar 2011 20:25] Larry D. Wilson 
Description:
Have a brand new install of 5.5.10 on Ubuntu server 10.10. 

Running scripts/mysql_install_db --user=mysql fails with 

Installing MySQL system tables...
110326 16:24:19 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--quick'
110326 16:24:19 [ERROR] Aborting
110326 16:24:19 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

How to repeat:
Install sql server, set rights, etc. 

Then run:
cd /usr/local/mysql
scripts/mysql_install_db --user=mysql
[26 Mar 2011 20:35] Larry D. Wilson 
This will work, sort of:
scripts/mysql_install_db --user=mysql --no-defaults

Except that it creates the data directory in the mysql basedir, not the datadir defined in my.cnf. Then you have to move the directories into your data directory... 

Then starting with /usr/local/mysql/bin/mysqld_safe --user=mysql & throws:
/usr/local/mysql/bin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
...
110326 16:34:10 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--quick'
110326 16:34:10 [ERROR] Aborting
110326 16:34:10  InnoDB: Starting shutdown...

Which leaves me without a working install fresh out of the box. What gives?
[26 Mar 2011 20:39] Valeriy Kravchuk 
Please, send the content of my.cnf you are planning to use. 

Send also the results of:

find / -name my.cnf 2>/dev/null

I wonder if there is my.cnf coming from Ubuntu that prevents scripts and server from working properly...
[26 Mar 2011 20:46] Larry D. Wilson 
Just uploaded my.cnf file. 

And here are the results of the find:
find / -name my.cnf 2>/dev/null
/usr/local/mysql-5.5.10-linux2.6-x86_64/mysql-test/suite/federated/my.cnf
/usr/local/mysql-5.5.10-linux2.6-x86_64/mysql-test/suite/rpl/my.cnf
/etc/mysql/my.cnf
[26 Mar 2011 20:49] Larry D. Wilson 
Found the reason for 110326 16:24:19 [ERROR] /usr/local/mysql/bin/mysqld: unknown option '--quick'
[26 Mar 2011 20:50] Larry D. Wilson 
Sorry - hit enter - I had inadvertently deleted the line in my.cnf [mysqldump]
[26 Mar 2011 20:52] Valeriy Kravchuk 
OK, so, please, fix it and check what else does not work after that...
[26 Mar 2011 21:02] Larry D. Wilson 
It starts. What's sad is that I ran the install fresh twice, but made the same typo both times. Thanks