Linux安装mysql-5.7

一、安装前准备

1.检测系统是否自带mysql

[root@localhost /]# rpm -qa | grep mysql

2.如是则进行删除

[root@localhost /]# rpm -e --nodeps ‘上一步查找的名称’

3.删除成功后，查询所有Mysql对应的文件夹，并删除

[root@localhost ~]# whereis mysql
mysql: /usr/bin/mysql /usr/local/mysql
[root@localhost ~]# find / -name mysql
/run/lock/subsys/mysql
/etc/rc.d/init.d/mysql
/usr/bin/mysql
/usr/local/mysql
/usr/local/mysql/bin/mysql
/usr/local/mysql/include/mysql
/usr/local/mysql/data/mysql

二、安装

1.上传mysql文件至  /usr/local/

2.解压并将解压后的文件夹名修改为mysql

[root@localhost local]# tar -zxvf mysql-5.7.30-el7-x86_64.tar.gz
[root@localhost local]# mv mysql-5.7.30-el7-x86_64/ mysql

3.在/usr/local/mysql目录下创建data目录

[root@localhost local]# mkdir mysql/data

4.检查mysql用户组和用户是否存在，没有则创建

[root@localhost local]# cat /etc/group | grep mysql
[root@localhost local]# cat /etc/passwd | grep mysql
[root@localhost local]# groupadd mysql
[root@localhost local]# useradd -r -g mysql mysql

5.更改mysql目录下所属的用户组和用户及权限

[root@localhost local]# chown -R mysql:mysql /usr/local/mysql/
[root@localhost local]# chmod -R 755 /usr/local/mysql

6.编译安装并初始化mysql，记住安装完成后的初始密码

[root@localhost local]# cd mysql/bin/
[root@localhost bin]# ./mysqld --initialize --user=mysql --datadir=/usr/local/mysql/data/ --basedir=/usr/local/mysql/

7.编辑配置文件my.cnf

[root@localhost bin]# vi /etc/my.cnf

添加配置如下：

[mysqld]
datadir=/usr/local/mysql/data
port=3306
# 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/data/mysql.log
pid-file=/usr/local/mysql/data/mysql.pid

8.启动mysql服务

[root@localhost bin]# /usr/local/mysql/support-files/mysql.server start

9.添加软连接并重启服务

[root@localhost bin]# ln -s /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
[root@localhost bin]# ln -s /usr/local/mysql/bin/mysql /usr/bin/mysql
[root@localhost bin]# service mysql restart
Shutting down MySQL.. SUCCESS! 
Starting MySQL. SUCCESS!

10.用刚才的初始密码登录mysql并修改密码

[root@localhost bin]# mysql -u root -p
Enter password:
mysql>ALTER USER USER() IDENTIFIED BY '123456';

11.开放远程连接

mysql>use mysql;
msyql>update user set user.Host='%' where user.User='root';
mysql>flush privileges;

三、测试

Navicat连接测试