Centos系统安装mysql-5.7.22

一、安装包下载

下载地址：https://dev.mysql.com/downloads/mysql/5.6.html#downloads

二、安装

1.将下载好的安装到解压到/usr/local目录下(或其他目录,建立软连接指向/usr/local/mysql/)

tar -zxvf mysql-5.7.22-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
cd /usr/local/
#建立软连接
ln -s mysql-5.7.22-linux-glibc2.12-x86_64 mysql

2.为centos添加mysql用户组和mysql用户

groupadd mysql
useradd -r -g mysql -s /bin/false mysql
cd /usr/local/mysql
chown -R mysql:mysql ./

3.安装mysql

#安装成功后会生成随机密码 记录好
./bin/mysqld --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data --initialize
./support-files/mysql.server start

4.开启mysql服务，命令如下：

./support-files/mysql.server start

如果出现如下错误，则说明mysql配置文件/etc/my.cnf中的路径不对,需要手动修改

image.png

[mysqld]
datadir=/usr/local/mysql/data
socket=/usr/local/mysql/mysql.sock
user=mysql
port=3055
lower_case_table_names=1
symbolic-links=0
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
explicit_defaults_for_timestamp=true

# InnoDB settings
default-storage-engine=INNODB
innodb_buffer_pool_size=4G
innodb_log_file_size=256M
innodb_log_buffer_size=4M
innodb_thread_concurrency=8
innodb_max_dirty_pages_pct=75
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=2


#Other
character-set-server=utf8
collation-server=utf8_general_ci
max_connections=1000
max_connect_errors=100000

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/usr/local/mysql/mysqld.pid


[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

5.将mysql进程放入系统进程中，命令如下：

cp support-files/mysql.server /etc/init.d/mysqld
service mysqld restart
#配置mysql环境变量
vi /etc/profile
export PATH=$PATH:/usr/local/mysql/bin
source /etc/profile

6.修改密码为root

alter user 'root'@'localhost' identified by 'root';
use mysql;
update user set user.Host='%' where user.User='root';
flush privileges;