Ok so I have been trying to upgrade MySQL 5.5 to 5.6. I have been given this set my.cnf file (see below). I was able to uninstall the MySQL 5.5 rpms and install the 5.6. When I reload the back up my.cnf file the mysql server does not want to start. Is there something wrong with this file? I have ran mysql_install_db. However, I cannot get the server to start up with my my.cnf file. I have looked in the error log, but it hasn't been copying anything recent to it. The my.cnf works when it is blank. This is what my my.cnf file from MySQL 5.5 looks like (see below). I need this my.cnf file to work on the 5.6 version. Anyone have any incite?# You can copy this to one of:# - /etc/mysql/my.cnf to set global options,# - ~/.my.cnf to set user-specific options.## One can use all long options that the program supports.# Run program with --help to get a list of available options and with# --print-defaults to see which it would actually understand and use.## For explanations see# http://dev.mysql.com/doc/mysql/en/server-system-variables.html# This will be passed to all mysql clients# It has been reported that passwords should be enclosed with ticks/quotes# escpecially if they contain # chars...# Remember to edit /etc/mysql/debian.cnf when changing the socket location.[client]port            = 3306socket          = /u02/mysqldata1/mysqld_3306.sock##[mysqld_safe]socket          = /u02/mysqldata1/mysqld_3306.socknice            = 0##[mysqld]#performance_schema=1user            = mysqlsocket          = /u02/mysqldata1/mysqld_3306.sockport            = 3306basedir         = /usrdatadir         = /u02/mysqldata1/data/3306tmpdir          = /u02/mysqldata/tmpskip-external-lockingcharacter_set_server    = utf8lower_case_table_names  = 1## Instead of skip-networking the default is now to listen only on# localhost which is more compatible and is not less secure.# bind-address            = 0.0.0.0max_allowed_packet              = 64Mmax_connections                 = 500max_connect_errors              = 100max_heap_table_size             = 256Mtmp_table_size                  = 256Mnet_buffer_length               = 8Ksort_buffer_size                = 4Mread_buffer_size                = 1Mread-rnd-buffer-size    = 2Mtable_cache                     = 1024table-definition-cache  = 512thread_stack                    = 256Kthread_cache_size               = 256sql-mode                        = NO_AUTO_CREATE_USERquery_cache_size                = 64Mquery_cache_limit               = 4M## MyISAM Configuration#key_buffer_size                 = 512Mmyisam_sort_buffer_size         = 128Mft_min_word_len                 = 3myisam_recover_options          = BACKUP,FORCEmyisam_repair_threads           = 6myisam_use_mmap                 = 1## General Logging#log_error                       = /u02/mysqldata/mysqllog/3306/err/error.loglong_query_time                 = 1slow_query_log                  = 1slow_query_log_file             = /u02/mysqldata/mysqllog/3306/slow/mysql_slow.loggeneral_log                     = 0general_log_file                = /u02/mysqldata/mysqllog/3306/general/mysql_general.log## Binary Log and Replication Configuration#log_bin                        = /u02/mysqldata/mysqllog/3306/bin/mysql-bin.loglog-bin-index         = /u02/mysqldata/mysqllog/3306/bin/mysql_bin.indexbinlog-cache-size     = 256Kbinlog_format         = ROW#binlog_do_db           = include_database_name#binlog_ignore_db       = include_database_namerelay-log               = /u02/mysqldata/mysqllog/3306/relay/mysql_bin.logrelay-log-index         = /u02/mysqldata/mysqllog/3306/relay/mysql_bin.indexexpire-logs-days        = 7max_binlog_size         = 100Msync_binlog             = 0## Replication#server-id=129206#log-slave-updates#replicate-ignore-db = mysql#replicate-ignore-table=slave_transaction_retries = 20#slave-skip-errors = 1062#auto_increment_increment = 3#auto_increment_offset = 3## InnoDB Configuration#innodb_file_format                      = Barracudainnodb_file_format_max                  = Barracudainnodb_data_home_dir                    = /u02/mysqldata1/innodb/3306/datainnodb_log_group_home_dir               = /u02/mysqldata1/innodb/3306/loginnodb_file_per_tableinnodb_data_file_path                   = ibdata1:10M:autoextendtransaction-isolation                   = READ-COMMITTEDinnodb_flush_log_at_trx_commit          = 0innodb_log_buffer_size                  = 8Minnodb_log_file_size                    = 512Minnodb_buffer_pool_size                 = 500Minnodb_additional_mem_pool_size         = 128Minnodb_flush_method                     = O_DSYNCinnodb_thread_concurrency               = 0innodb_lock_wait_timeout                = 60innodb-open-files                       = 500innodb-support-xa                       = 0### For generating SSL certificates I recommend the OpenSSL GUI tinyca.## ssl-ca=/etc/mysql/cacert.pem# ssl-cert=/etc/mysql/server-cert.pem# ssl-key=/etc/mysql/server-key.pem[mysqldump]quickquote-namesmax_allowed_packet      = 128M[mysql]#no-auto-rehash # faster start of mysql but no tab completition[isamchk]key_buffer              = 1G
Can't use my old my.cnf from MySQL 5.5.38 in newer 5.6.19
centos;mysql