2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'sha256_password'

2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'mysql_old_password'

2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'mysql_native_password'

2013-04-08 11:12:47 7886 [Note] Shutting downplugin 'binlog'

2013-04-08 11:12:47 7886 [Note]/usr/local/mysql5.5/bin/mysqld: Shutdown complete

130408 11:12:47 mysqld_safe mysqld from pidfile /usr/local/mysql5.5/data/zskw2.pid ended

解决办法：将/usr/local/mysql5.5设为读写即可

…

5.4 设置密码

#/usr/local/mysql/bin/mysqladmin password[new-password]

6数据库初始化

如果想让数据库可远程访问,必须在库中mysql下的user里存在如下用户

Host user password

% root xxx

7附录

7.1参考网址

http://www.centos.bz/2011/09/linux-compile-install-mysql-5-5-15-from-source/

http://blog.csdn.net/sunjingzhi/article/details/6671668

https://github.com/santisaez/powerstack/issues/49

http://heylinux.com/archives/993.html

http://www.mysqlops.com/2011/03/06/mysql_compile_reference.html

http://who0168.blog.51cto.com/253401/469898

7.2所用my.cnf

# Example MySQLconfig file for large systems.

#

# This is for a largesystem with memory = 512M where the system runs mainly

# MySQL.

#

# MySQL programs lookfor option files in a set of

# locations whichdepend on the deployment platform.

# You can copy thisoption file to one of those

# locations. Forinformation about these locations, see:

#http://dev.mysql.com/doc/mysql/en/option-files.html

#

# In this file, youcan use all long options that a program supports.

# If you want to knowwhich options a program supports, run the program

# with the"--help" option.

# The followingoptions will be passed to all MySQL clients

[client]

#password = your_password

port = 3306

#socket = /var/lib/mysql/mysql.sock

socket = /usr/local/mysql5.5/mysqld.sock

#character-set-server= utf8

# Here followsentries for some specific programs

# The MySQL server

[mysqld]

port = 3306

#socket = /var/lib/mysql/mysql.sock

socket = /usr/local/mysql5.5/mysqld.sock

user=mysql

skip-external-locking

key_buffer_size =256M

max_allowed_packet =1M

table_open_cache =256

sort_buffer_size = 1M

read_buffer_size = 1M

read_rnd_buffer_size= 4M

myisam_sort_buffer_size= 64M

thread_cache_size = 8

query_cache_size= 16M

# Try number ofCPU's*2 for thread_concurrency

thread_concurrency =8

#character-set-server= utf8

max_connections =1000

# Don't listen on aTCP/IP port at all. This can be a security enhancement,

# if all processesthat need to connect to mysqld run on the same host.

# All interactionwith mysqld must be made via Unix sockets or named pipes.

# Note that usingthis option without enabling named pipes on Windows

# (via the"enable-named-pipe" option) will render mysqld useless!

#

#skip-networking

# Replication MasterServer (default)

# binary logging isrequired for replication

log-bin=mysql-bin

# binary loggingformat - mixed recommended

binlog_format=mixed

# required unique idbetween 1 and 2^32 - 1

# defaults to 1 ifmaster-host is not set

# but will notfunction as a master if omitted

server-id = 1

# Replication Slave(comment out master section to use this)

#

# To configure thishost as a replication slave, you can choose between

# two methods :

#

# 1) Use the CHANGEMASTER TO command (fully described in our manual) -

# the syntax is:

#

# CHANGE MASTER TO MASTER_HOST=,MASTER_PORT=,

# MASTER_USER=,MASTER_PASSWORD= ;

#