MySQL 5.5.28 with mysql5.6.17 configuration start difference

Download a new mysql.5.6.17 from mysql.com after installation, because the original machine installed MySQL, start always error

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/28/5F/wKioL1N4Rx7QBz_AAAAykPCF0ck190.png "title=" Mysql_ Error_20140518.png "alt=" Wkiol1n4rx7qbz_aaaaykpcf0ck190.png "/>

Check out MySQL's original installation directory there is a new myql-new.conf.

Compared with the/etc/my.conf and mysql-net.conf in the mysql.5.6.17 this version of a very different

Original MY.CONF configuration Content

[Email protected] bin]# CAT/ETC/MY.CNF

[Mysqld]

Datadir=/var/lib/mysql

Socket=/var/lib/mysql/mysql.sock

User=mysql

# Disabling Symbolic-links is recommended to prevent assorted security risks

Symbolic-links=0

[Mysqld_safe]

Log-error=/var/log/mysqld.log

Pid-file=/var/run/mysqld/mysqld.pid

Mysql_enable= "YES"

mysql_args= "--skip-grant-tables--skip-networking"

New configuration of my.conf

[Email protected] mysql]# CAT/ETC/MY.CNF

# for advice The change settings

# http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html

[Mysqld]

# Remove Leading # and set to the amount of RAM for the most important data

# Cache in MySQL. Start at 70% of all RAM for dedicated server, else 10%.

# innodb_buffer_pool_size = 128M

# Remove Leading # to turn on a very important data integrity option:logging

# Changes to the binary log between backups.

# Log_bin

# These is commonly set, remove the # and set as required.

# Basedir = ...

# DataDir = ...

# port = .....

# server_id = ...

# socket = .....

# Remove Leading # To set options mainly useful for reporting servers.

# The server defaults is faster for transactions and fast selects.

# Adjust sizes as needed, experiment to find the optimal values.

# join_buffer_size = 128M

# sort_buffer_size = 2M

# read_rnd_buffer_size = 2M

Sql_mode=no_engine_substitution,strict_trans_tables

Where this URL http://dev.mysql.com/doc/refman/5.6/en/server-configuration-defaults.html is the latest configuration of mysql.5.6.17

After overwriting this file under the installation directory

Restart MySQL

[Email protected] bin]#/mysqld_safe--user=mysql &

[1] 30069

[Email protected] bin]# 140518 11:21:42 mysqld_safe Logging to '/usr/local/mysql/data/nginx01.err '.

140518 11:21:42 Mysqld_safe starting mysqld daemon with databases From/usr/local/mysql/data

[Email protected] bin]# Netsat-atnp|grep 3306

-bash:netsat:command not found

[Email protected] bin]# Netstat-antp|grep 3306

TCP 0 0::: 3306:::* LISTEN 30173/mysqld

Startup success

This article is from the "Linux-php-user" blog, make sure to keep this source http://wangsheng219.blog.51cto.com/2147741/1413102