Linux安装MySQL5.7.24

安装前准备

# 检查是否已存在MySQL
rpm -qa|grep -i mysql
# 卸载
rpm -ev MySQL-server-5.5.25a-1.rhel5
# 查询是否存在mysql文件夹
find / -name mysql
# 删除
rm -rf dirpath

1、下载

cd /usr/local
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、重命名

mv mysql-5.7.24-linux-glibc2.12-x86_64/ mysql

4、配置文件

cd /etc
touch my.cnf
# 编辑文件
vim /etc/my.cnf
# 开始编辑
i
# 文件内容如下
# 保存退出
Esc
:
wq
Enter

[mysqld]
character_set_server=utf8
init_connect='SET NAMES utf8'
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
port=3306
socket=/tmp/mysql.sock
log-error=/usr/local/mysql/log/mysqld.log
pid-file=/usr/local/mysql/tmp/mysqld.pid
lower_case_table_names=1
max_connections=5000
explicit_defaults_for_timestamp=true

5、新建数据、日志和进程信息文件

cd /usr/local/mysql
mkdir data
mkdir log
cd log
touch mysqld.log
mkdir tmp
cd tmp
touch mysqld.pid
touch mysql.sock

6、设置用户组

groupadd mysql
useradd -r -g mysql mysql

7、设置文件夹权限

cd /usr/local
chown -R mysql mysql/
chgrp -R mysql mysql/

8、初始化

cd /usr/local/mysql/bin
./mysqld --initialize --user=mysql --basedir=/usr/local/mysql/ --datadir=/usr/local/mysql/data/ --lc_messages_dir=/usr/local/mysql/share --lc_messages=en_US

9、注册服务

cd /usr/local/mysql/support-files/
cp mysql.server /etc/init.d/mysql
# 编辑
vim vi /etc/init.d/mysql
# 开始编辑
i
# 修改如下内容
# 保存退出
Esc
:
wq
Enter
# 授权
chmod +x /etc/init.d/mysql
# 开机启动
chkconfig --add mysql

basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/

10、启动

service mysql start

11、登录

mysql -u root -p
# 查询初始密码
more /usr/local/mysql/log/mysqld.log
# A temporary password is generated for root@localhost：password
# 复制登录

12、修改密码

set password for root@localhost = password('my_password');

13、创建、查询和删除数据库

create database database_name;
show databases;
drop database database_name;

14、开放远程连接

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

15、停止和重启

service mysql stop
service mysql restart

16、开放端口

firewall-cmd --zone=public  --permanent --add-port=3306/tcp
firewall-cmd --reload