Linux mysql5.7.20 二进制文件安装 添加服务为自启动

mysql安装

1、解压mysql安装包

tar -xzvf mysql-5.7.20-linux-glibc2.12-x86_64.tar.gz

2、将解压的安装包拷贝到usr/local下

mv mysql-5.7.20-linux-glibc2.12-x86_64 /usr/local/

3、建别名

ln -s mysql-5.7.20-linux-glibc2.12-x86_64 mysql

4、添加用户mysql

groupadd mysql

useradd -r -g mysql mysql

5、添加默认的my.cnf文件

vi /etc/my.cnf

[mysqld]

character-set-server = utf8mb4

default_storage_engine = innodb

log_timestamps = SYSTEM

socket = /tmp/mysql.sock

basedir =/usr/local/mysql 

datadir =/data/mysql/data # 数据路径

pid-file = /data/mysql/mysql.pid

max_connections = 1000

max_connect_errors = 1000

table_open_cache = 1024

max_allowed_packet = 128M

open_files_limit = 65535

explicit_defaults_for_timestamp=true

#####====================================[innodb]==============================

innodb_buffer_pool_size = 1024M

innodb_file_per_table = 1

innodb_write_io_threads = 4

innodb_read_io_threads = 4

innodb_purge_threads = 2

innodb_flush_log_at_trx_commit = 1

innodb_log_file_size = 512M

innodb_log_files_in_group = 2

innodb_log_buffer_size = 16M

innodb_max_dirty_pages_pct = 80

innodb_lock_wait_timeout = 30

innodb_data_file_path=ibdata1:1024M:autoextend

#####====================================[log]==============================

log_error = /data/mysql/log/mysql-error.log 

slow_query_log = 1

long_query_time = 1 

slow_query_log_file = /data/mysql/log/mysql-slow.log

6、创建data文件夹并赋权

创建完data和log目录后将mysql文件夹的读写权限给mysql用户和组

cd /data

chmod 750 mysql

chown -R mysql mysql

chgrp -R mysql mysql

操作完成后在data目录敲ll，会发现mysql以及mysql以下的目录所有者已经是mysql这个用户了：

drwxr-xr-x. 2 mysql mysql 6 Nov 1 02:00 mysql

7、初始化数据库

bin/mysqld --initialize --user=mysql

如果碰到如下错误，说明没有安装libaio

bin/mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory

7.1、安装libaio

yum search libaio

yum install libaio

8、记录初始化后root的临时密码

由于cnf里配置了log_error所以在该文件里查看A temporary password is generated for root@localhost: .dEqlQs%%1n1

8、添加服务

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

9、启动服务

service mysqld start

10、本地登录，修改root的初始密码

bin/mysql -uroot -p

alter user 'root'@'localhost' identified by 'newpswd'

11、mysql服务设置为自启动

chmod +x /etc/init.d/mysqld    赋予可执行权限

chkconfig --add mysqld        添加服务

chkconfig --list             显示服务列表

如果看到mysql的服务，并且3,4,5都是on的话则成功，如果是off，则键入

chkconfig --level 345 mysqld on

reboot重启电脑

netstat -na | grep 3306，如果看到有监听说明服务启动了