安装流程
1.下载安装包
rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
2.安装
yum install mysql-community-server -y
3.如果报公钥未安装错误
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
4.启动mysql
systemctl start mysqld.service
5.获取临时密码
grep 'temporary password' /var/log/mysqld.log
6.输入指令,使用临时密码登录后，不能进行其他的操作，否则会报错，这时候我们进行修改密码操作
mysql -uroot -p
7.修改密码规则
mysql> set global validate_password_policy=0;
mysql> set global validate_password_length=1;
8.输入自己的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '你自己的密码';
9.授权其他机器远程登录
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '你自己的密码' WITH GRANT OPTION;
10.刷新权限
FLUSH PRIVILEGES;
11.开机自动启动
systemctl enable mysqld
systemctl daemon-reload
12.设置MySQL的字符集为UTF-8，令其支持中文
vim /etc/my.cnf
改成如下：
# 2023-03-01
[mysql]
default-character-set=utf8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
default-storage-engine=INNODB
character_set_server=utf8
symbolic-links=0
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
13.重启MySQL让命令生效
service mysqld restart
14.卸载mysql仓库
rpm -qa | grep mysql
yum -y remove mysql57-community-release-el7-10.noarch
更改数据库目录
由于软件安装的是系统盘所以需要更改目录
vim /etc/my.cnf
# 2023-03-01
[mysql]
default-character-set=utf8
[mysqld]
#datadir=/var/lib/mysql
#socket=/var/lib/mysql/mysql.sock
datadir=/db/mysql
socket=/db/mysql/mysql.sock
default-storage-engine=INNODB
character_set_server=utf8
symbolic-links=0
#log-error=/var/log/mysqld.log
log-error=/db/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
赋予权限
chown mysql:mysql -R /db/log/
chown mysql:mysql -R /db/mysql/
数据库操作
1.查看mysql是否启动：
service mysqld status
2.启动mysql:
service mysqld start
3.停止mysql:
service mysqld stop
4.重启mysql：
service mysqld restart
