共计 1523 个字符,预计需要花费 4 分钟才能阅读完成。
测试环境:
CentOS6.5、MySQL5.6.28
yum 安装具有速度快,便捷关键是不用编译,编译时间太久了!
01、下载 mysql
https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/ ### 一般每个都下载下,在同版本下!
http://repo.mysql.com/
02、安装 rpm 文件
yum localinstall -y * ### 把需要安装的 rpm 文件放到一个文件夹中
yum install -y mysql-server ### 利用本地或 yum 源,自动下载安装
03、修改 /etc/my.cnf
[ | ]|
default-character-set=utf8 | |
[ | ]|
auto-rehash | |
default-character-set=utf8 | |
[ | ]|
innodb_buffer_pool_size = 128M | |
join_buffer_size = 128M | |
sort_buffer_size = 2M | |
read_rnd_buffer_size = 2M | |
datadir=/mysql/data | |
socket=/mysql/data/mysql.sock | |
init_connect='SET collation_connection = utf8_unicode_ci' | |
init_connect='SET NAMES utf8' | |
character-set-server=utf8 | |
collation-server=utf8_unicode_ci | |
skip-character-set-client-handshake | |
symbolic-links=0 | |
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES | |
[ | ]|
log-error=/mysql/data/mysqld.log | |
pid-file=/mysql/data/mysqld.pid |
04、修改 /etc/init.d/mysqld
[root@zabbix_proxy ~]# cat /etc/init.d/mysqld
#!/bin/sh
#
# mysqld This shell script takes care of starting and stopping
# the MySQL subsystem (mysqld).
#
# chkconfig: – 64 36
# description: MySQL database server.
# processname: mysqld
config=/etc/my.cnf ### 指定配置文件,启动会优先找 config 的配置项
05、建立 sock 连接文件
ln -sf /mysql/data/mysql.sock /var/lib/mysql/mysql.sock
06、启动测试
service mysqld start
tail -f /mysql/data/mysqld.log ### 查看日志很关键
关键点:
service mysqld start 启 动的实质就是 mysqld_safe 启动,而 mysqld , 只需指定 config=/etc/my.cnf 即可
/usr/bin/mysqld_safe –defaults-file=/etc/my.cnf &
本文永久更新链接地址:http://www.linuxidc.com/Linux/2017-03/141336.htm
