CentOS7安装MySQL 5.7

最新推荐文章于 2024-07-20 15:38:46 发布

cezildonte

最新推荐文章于 2024-07-20 15:38:46 发布

阅读量442

点赞数

文章标签： mysql 数据库服务器

本文链接：https://blog.csdn.net/qq_38662415/article/details/126934835

版权

安装前的准备

安装Oracle JDK(省略)

如果你系统已经有mysql，如一般centos自带mysql5.1系列，那么你需要删除它，先检查一下系统是否自带mysql

yum list installed | grep mysql

删除系统自带的MySQL及其依赖命令

yum -y remove mysql-xxxxx

给CentOS添加rpm源，并且选择较新的源命令

wget https://repo.mysql.com/mysql-community-release-el7-7.noarch.rpm
yum localinstall mysql-community-release-el7-7.noarch.rpm
yum repolist all | grep mysql
yum-config-manager --disbale mysql57-community
yum-config-manager --disbale mysql56-community
yum-config-manager --enable mysql57-community
yum repolist enabled | grep mysql

MySQL rpm源迁移到https,需要编辑/etc/yum.repos.d/mysql-community.repo

[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=https://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql-tools-community]
name=MySQL Tools Community
baseurl=https://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Enable to use MySQL 5.5
[mysql55-community]
name=MySQL 5.5 Community Server
baseurl=https://repo.mysql.com/yum/mysql-5.5-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=https://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

[mysql57-community]
name=MySQL 5.7 Community Server
baseurl=https://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

开始安装

安装MySQL服务器命令

yum install mysql-community-server

CentOS7上安装MySQL需要先卸载掉mariadb，以下为卸载mariadb步骤

rpm -qa| grep mariadb
rpm -e -- nodeps mariadb-xxxx

启动MySQL命令

systemctl start mysqld

查看mysql是否自启动,并且设置开启自启动命令

systemctl list-unit-files | grep mysqld

开始使用

开启远程
1. 停止MySQL服务并使用mysqld safe启动

systemctl stop mysqld
mysqld --user=mysql --skip-grant-tables --skip-networking &

登录MySQL

mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.7.39 MySQL Community Server (GPL)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

更改MySQL安全密码

update mysql.user set authentication_string=password('123456') where user = 'root';

建立可供远程连接的root用户

grant all privileges on *.* to 'root'@'%' identified by 'Root@123456' with grant option;

ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.
解决方法：设置新的密码（规则:大小写+数字+特殊字符）

set password=password('Root@123456');

设置防火墙允许MySQL端口

编辑防火墙配置文件 vi /etc/firewalld/zones/public.xml

<?xml version="1.0" encoding="utf-8"?>
<zone>
  <short>Public</short>
  <description>For use in public areas. You do not trust the other computers on networks to not harm your computer. Only selected incoming connections are accepted.</description>
  <service name="ssh"/>
  <service name="dhcpv6-client"/>
  <port protocol="tcp" port="3306" />
</zone>

重启防火墙服务 systemctl restart firewalld

配置文件/etc/my.conf
查看最大连接数

mysql> show variables like ‘%max_connections%’;

MySQL核心配置文件示例

# For advice on how to change settings please see
# http://dev.mysql.com/doc/refman/5.7/en/server-configuration-defaults.html

[mysqld]
#
# Remove leading # and set to the amount of RAM for the most important data
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
# innodb_buffer_pool_size = 128M
#
# Remove leading # to turn on a very important data integrity option: logging
# changes to the binary log between backups.
# log_bin
#
# Remove leading # to set options mainly useful for reporting servers.
# The server defaults are faster for transactions and fast SELECTs.
# Adjust sizes as needed, experiment to find the optimal values.
# join_buffer_size = 128M
join_buffer_size = 128M
# sort_buffer_size = 2M
sort_buffer_size = 6M
# read_rnd_buffer_size = 2M
read_rnd_buffer_size = 4M

character-set-server=utf-8
# 默认值5000
open_files_limit=10240
# 默认值151
max_connections=500
max_allowed_packet=16M
query_cache_size=384M
table_open_cache=512
key_buffer_size=384M


datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


slow_query_log_file=/var/log/mysqld-slow_query.log
log-short-format
long-query-time=3
log-queries-not-using-indexes