一、环境准备
1. 下载软件包
2. 安装基础软件
yum -y install make gcc-c++ bison-devel ncurses-devel
二、 安装配置MySQL
1. 编译安装cmake
tar zxvf /usr/local/src/cmake-3.4.0.tar.gz
cd /usr/local/src/cmake-3.4.0
./configure && make && make install
2. 编译安装boost(编译时不加boost,可以不用安装此软件)
tar zxvf /usr/local/src/boost_1_59_0.tar.gz -C /usr/local/boost/
cd /usr/local/boost/
./bootstrap.sh
./b2
3. 新增用户用户组
groupadd mysql
useradd mysql -g mysql -M -s /sbin/nologin
4. 编译安装MySQL
tar zxvf /usr/local/src/mysql-5.7.9.tar.gz
cd /usr/local/src/mysql-5.7.9/
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DMYSQL_DATADIR=/usr/local/mysql/data -DSYSCONFDIR=/etc -DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock -DDOWNLOAD_BOOST=1 -DWITH_BOOST=/usr/local/boost -DWITH_INNOBASE_STORAGE_ENGINE=1 -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_ARCHIVE_STORAGE_ENGINE=1 -DWITH_BLACKHOLE_STORAGE_ENGINE=1 -DWITH_READLINE=1 -DWITH_SSL=system -DWITH_ZLIB=system -DWITH_LIBWRAP=0 -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci
make
make install
# cmake参数说明
-DCMAKE_INSTALL_PREFIX=/usr/local/mysql [MySQL安装的根目录]
-DMYSQL_DATADIR=/usr/local/mysql [MySQL数据库文件存放目录]
-DSYSCONFDIR=/etc [MySQL配置文件所在目录]
-DMYSQL_UNIX_ADDR=/usr/local/mysql/mysql.sock [MySQL的UNIX socket文件目录]
-DDOWNLOAD_BOOST=1 [允许下载BOOST]
-DWITH_BOOST=/usr/local/boost [指定BOOST安装路径]
-DWITH_INNOBASE_STORAGE_ENGINE=1 [支持InnoDB存储引擎]
-DWITH_MYISAM_STORAGE_ENGINE=1 [支持MYISAM存储引擎]
-DWITH_ARCHIVE_STORAGE_ENGINE=1 [支持Archive引擎]
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 [支持BLACKHOLE引擎]
-DWITH_READLINE=1[支持readline库]
-DWITH_SSL=system[通讯时支持ssl协议]
-DWITH_ZLIB=system[允许使用zlib library]
-DWITH_LIBWRAP=0 [不支持libwrap库]
-DDEFAULT_CHARSET=utf8[设置默认字符集为utf8]
-DDEFAULT_COLLATION=utf8_general_ci[设置默认字符校对]
5. 修改权限
chown -R mysql.mysql /usr/local/mysql/
6. 初始化MySQL
cd /usr/local/mysql
bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data
# 初始化成功后会生成一个root用户的临时密码,首次登录mysql后需要先修改这个临时密码
7. 配置my.cnf 编译的时候制定在/etc目录下
[client]
port = 3306
default-character-set=utf8
[mysqld]
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=mysql
character-set-server=utf8
symbolic-links=0
open_files_limit = 102400
max_connections=2000
skip-name-resolve
#skip-grant-tables
slow_query_log = 'on'
long_query_time=1
slow_query_log_file=/usr/local/mysql/mysql-slow.log
tmp_table_size=256M
key_buffer_size=512M
read_buffer_size=32M
sort_buffer_size=32M
query_cache_limit=1M
query_cache_size=16M
#INNODB
default-storage-engine=INNODB
innodb_buffer_pool_size=8G
innodb_additional_mem_pool_size = 32M
innodb_buffer_pool_instances=8
innodb_read_io_threads = 8
innodb_write_io_threads = 8
innodb_log_file_size=265M
innodb_log_buffer_size=8M
innodb_log_files_in_group = 3
innodb_lock_wait_timeout=90
innodb_file_per_table=1
innodb_flush_log_at_trx_commit=2
innodb_max_dirty_pages_pct = 90
innodb_thread_concurrency = 16
innodb_file_io_threads=4
innodb_open_files = 1000
read_only
server-id = 1
log-bin=mysql-bin
log-slave-updates
binlog_cache_size = 4M
binlog_format = mixed
max_binlog_cache_size = 1G
max_binlog_size = 1G
auto_increment_offset=1
auto_increment_increment=2
[mysqld_safe]
log-error=/usr/local/mysql/log/mysqld.log
pid-file=/usr/local/mysql/data/mysqld.pid
replicate-do-db =all
8. 配置环境变量
vim /etc/profile
PATH=/usr/local/mysql/bin:${PATH}
export PATH
source /etc/profile
9. 启动mysql,并加入开机自启动
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
chmod 755 /etc/init.d/mysqld
chkconfig mysqld on
service mysqld start
ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
数据库启动时报错找不到pid 这时就要给/usr/local/mysql/data目录加755的权限、
10. 配置root密码,开通root权限
mysql –uroot -p2qP3PlPZiN;s
mysql>alter user 'root'@'localhost' identified by '10jqka@123';(或者下面grant也行)
mysql>grant all privileges on *.* to 'root'@'%' identified by "10jqka@123"
Mysql>flush privileges;
mysql>exit
如果你格式化时候没有保留初始密码 是进不去数据库的 这时你要
/usr/local/mysql/bin/mysqld_safe --user=mysql --skip-grant-tables &
mysql>use mysql
mysql>update mysql.user set password=password('10jqka@123') where user='root' ;
Mysql>flush privileges;
特别注意:mysql5.7以上版本启动默认路径是/usr/local目录下,如果你安装目录更改,那么要修改启动文件:
vim /etc/init.d/mysqld
找到如下二行:
basedir=
datadir=
修改为:
basedir=安装的mysql目录
datadir=mysql的数据目录
然后再启动。不然会报错无法更新pid文件
三、常用配置参数
● “—prefix” :设定安装路径,默认为“ /usr/local” ;
●
“—datadir” :设定MySQL数据文件存放路径;
●
“—with-charset” :设定系统的默认字符集;
●
“—with-collation” :系统默认的校验规则;
●
“—with-extra-charsets” :出了默认字符集之外需要编译安装的字符集;
●
“—with-unix-socket-path” :设定socket文件地址;
●
“—with-tcp-port” :指定特定监听端口,默认为3306;
●
“—with-mysqld-user” :指定运行mysqld的os用户,默认为mysql;
●
“—without-query-cache” :禁用Query Cache功能;
●
“—without-innodb” :禁用Innodb存储引擎;
● “
--with-partition” :在5.1版本中开启partition支持特性;
● “
--enable-thread-safe-client” :以线程方式编译客户端;
●
“—with-pthread” :强制使用pthread 线程库编译;
●
“—with-named-thread-libs” :指定使用某个特定的线程库编译;
●
“—without-debug” :使用非debug模式;
●
“—with-mysqld-ldflags” : mysqld的额外link参数;
●
“—with-client-ldflags” : client的额外link参数;
转载:https://www.cnblogs.com/zhangan/p/10899843.html