Linux CentOs7.5 安装Mysql5.7.24

1.在/mnt/目录下下载好5.7.24版本:

wget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

2.解压:

tar zxvf mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz

3.移动到/usr/local/mysql目录下:

mv /mnt/mysql-5.7.24-linux-glibc2.12-x86_64 /usr/local/mysql/

4.新建data文件夹:

mkdir /usr/local/mysql/data

5.创建mysql用户和组

useradd -r -g mysql mysql
groupadd mysql

6.更改mysql目录的用户和组

chown -R mysql:mysql /usr/local/mysql/
chmod -R 755 /usr/local/mysql/

7.配置my.cnf

vim /etc/my.cnf,内容如下：
[mysqld]
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
#socket=/var/lib/mysql/mysql.sock
socket=/tmp/mysql.sock
port=3306
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
max_connections=400
innodb_file_per_table=1
lower_case_table_names=1

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

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

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

8.安装 numactl

yum -y install

9.初始化mysql并记录打印日志最后面的临时登录密码

[Note] A temporary password is generated for root@localhost: :xYLuR/us3Of
/usr/local/mysql/bin/mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data --basedir=/usr/local/mysql

10.建立软链接

ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
ln -s /usr/local/mysql/bin/mysql /usr/bin

11.启动MySQL服务器

service mysql start

12.登录MySQL

 mysql -u root -p
输入之前的密码为   :xYLuR/us3Of

13.修改登录密码

set PASSWORD = PASSWORD('123456');
ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;
FLUSH PRIVILEGES;

14.修改支持远程登陆

use mysql
update user set host = '%' where user = 'root';
FLUSH PRIVILEGES;

15.navicat连接