MySQL Bugs: #71756: MySQL installation issue

Bug #71756	MySQL installation issue
Submitted:	18 Feb 2014 8:51	Modified:	18 Feb 2014 12:14
Reporter:	Mahesh Patil	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S1 (Critical)
Version:	5.6.16 ENT	OS:	Linux (Ubuntu 12.04)
Assigned to:		CPU Architecture:	Any
Tags:	mysql5.6

Description:
I am trying to install MySQL like and getting error as :

mahesh@mahesh-OptiPlex-990:~/mysql_related/MySQL-Enterprise/mysql-ent$ ./scripts/mysql_install_db --basedir=/home/mahesh/mysql_related/MySQL-Enterprise/mysql-ent --datadir=/home/mahesh/mysql_related/MySQL-Enterprise/mysql-ent/data/ 
error: Found option without preceding group in config file: /home/mahesh/mysql_related/MySQL-Enterprise/mysql-ent/my.cnf at line: 1
Fatal error in defaults handling. Program aborted
Installing MySQL system tables...2014-02-18 14:14:59 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-02-18 14:14:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-02-18 14:14:59 8366 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
2014-02-18 14:14:59 8366 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2014-02-18 14:14:59 8366 [Warning] Buffered warning: Changed limits: table_cache: 431 (requested 2000)

2014-02-18 14:14:59 8366 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-02-18 14:14:59 8366 [Note] InnoDB: The InnoDB memory heap is disabled
2014-02-18 14:14:59 8366 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-02-18 14:14:59 8366 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-02-18 14:14:59 8366 [Note] InnoDB: Using Linux native AIO
2014-02-18 14:14:59 8366 [Note] InnoDB: Using CPU crc32 instructions
2014-02-18 14:14:59 8366 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-02-18 14:14:59 8366 [Note] InnoDB: Completed initialization of buffer pool
2014-02-18 14:14:59 8366 [Note] InnoDB: Highest supported file format is Barracuda.
2014-02-18 14:14:59 8366 [Note] InnoDB: 128 rollback segment(s) are active.
2014-02-18 14:14:59 8366 [Note] InnoDB: Waiting for purge to start
2014-02-18 14:14:59 8366 [Note] InnoDB: 5.6.16 started; log sequence number 1600627
2014-02-18 14:14:59 8366 [ERROR] Aborting

2014-02-18 14:14:59 8366 [Note] Binlog end
2014-02-18 14:14:59 8366 [Note] InnoDB: FTS optimize thread exiting.
2014-02-18 14:14:59 8366 [Note] InnoDB: Starting shutdown...
2014-02-18 14:15:01 8366 [Note] InnoDB: Shutdown completed; log sequence number 1600637
2014-02-18 14:15:01 8366 [Note] 

Why installation is getting Aborted and why there is no specific solution to it?

Also after these errors I am trying to run :
 ./support-files/mysql.server start
Starting MySQL
. * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).

How to repeat:
1) Just install using ./scripts/mysql-db-install script and you will get errors 

2) start mysql.server script you will get PID issue 

and there is no solution.

Suggested fix:
There are errors logged but no solution how a user will know how to fix these specific problems.

Hi Mahesh,

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.

As a side note: Fix the issue of your conf file

mahesh@mahesh-OptiPlex-990:~/mysql_related/MySQL-Enterprise/mysql-ent$ ./scripts/mysql_install_db --basedir=/home/mahesh/mysql_related/MySQL-Enterprise/mysql-ent --datadir=/home/mahesh/mysql_related/MySQL-Enterprise/mysql-ent/data/ 
error: Found option without preceding group in config file: /home/mahesh/mysql_related/MySQL-Enterprise/mysql-ent/my.cnf at line: 1
Fatal error in defaults handling. Program aborted

^^ most likely, mysqld or other group is missing here.. Alternatively, if a program does not start because it is reading unknown options from an option file, --no-defaults can be used to prevent the program from reading them