注意：如果使用–initialize参数初始化系统数据库之后，会在~/.mysql_secret文件中生成root用户的一个临时密码，同时也在初始化日志中打印出来了，如下图红圈中所示：
5、配置文件及参数优化
shell> cp support-files/my-default.cnf /etc/my.cnf
shell> vim /etc/my.cnf
[client]
port=3306
socket=/usr/local/mysql/mysql.sock
[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
skip-external-locking
skip-name-resolve
user=mysql
port=3306
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
tmpdir=/usr/local/mysql/temp
# server_id = .....
socket=/usr/local/mysql/mysql.sock
log-error=/usr/local/mysql/logs/mysql_error.log
pid-file=/usr/local/mysql/mysql.pid
open_files_limit=10240
back_log=600
max_connections=500
max_connect_errors=6000
wait_timeout=605800
#open_tables=600
#table_cache = 650
#opened_tables = 630
max_allowed_packet=32M
sort_buffer_size=4M
join_buffer_size=4M
thread_cache_size=300
query_cache_type=1
query_cache_size=256M
query_cache_limit=2M
query_cache_min_res_unit=16k
tmp_table_size=256M
max_heap_table_size=256M
key_buffer_size=256M
read_buffer_size=1M
read_rnd_buffer_size=16M
bulk_insert_buffer_size=64M
lower_case_table_names=1
default-storage-engine=INNODB
innodb_buffer_pool_size=2G
innodb_log_buffer_size=32M
innodb_log_file_size=128M
innodb_flush_method=O_DIRECT
#####################
thread_concurrency=32
long_query_time=2
slow-query-log=on
slow-query-log-file=/usr/local/mysql/logs/mysql-slow.log
[mysqldump]
quick
max_allowed_packet=32M
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
6、配置mysql服务
shell> cp support-
files/mysql.server /etc/init.d/mysqld
shell> chkconfig
--add mysqld
# 添加到系统服务
shell> chkconfig mysqld
on
# 开机启动
7、启动服务
shell> service mysqld start
# 启动mysql服务
shell> service mysqld stop
# 停止mysql服务
shell> service mysqld restart
# 重新启动mysql服务
8、设置数据库密码
shell> /usr/
local/mysql/bin/mysql -e
"grant all privileges on *.* to root@'127.0.0.1' identified by "root
" with grant option;"
shell> /usr/
local/mysql/bin/mysql -e
"grant all privileges on *.* to root@'localhost' identified by "root
" with grant option;"
# 开启远程登录(将host设为%即可)
/usr/
local/mysql/bin/mysql -e
"grant all privileges on *.* to root@'%' identified by "root
" with grant option;"
9、配置mysql环境变量
shell> vim /etc/profile
shell> export PATH=/usr/
local/mysql/bin:$PATH
shell> source /etc/profile
四、其它注意事项
如果中途编译失败了，需要删除cmake生成的预编译配置参数的缓存文件和make编译后生成的文件，再重新编译。
shell> cd /opt/mysql-server
shell> rm -f CMakeCache.txt
shell> make clean
