目录
安装依赖
yum -y install perl autoconf gcc gcc-c++ make cmake lrzsz net-tools libaio
官方地址:https://downloads.mysql.com/archives/community/
mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar:https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
1、查看mariadb数据库是否安装
rpm -qa | grep mariadb
which mysql
whereis mysql
2、卸载mariadb
rpm -e mariadb-server --nodeps
rpm -e mariadb-* --nodeps
rpm -e mariadb-devel --nodeps
rpm -e mariadb-libs --nodeps
3、重新查看
rpm -qa | grep mariadb
4、查看mysql是否有安装过
rpm -qa | grep -i mysql
5、查看mysql相关文件
把所有相关的文件全部删除
find / -name mysql
1、解压缩包
tar xvf mysql-5.7.24-1.el7.x86_64.rpm-bundle.tar
2、安装依赖包和服务(按顺序安装)
rpm -Uvh mysql-community-common-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-libs-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-devel-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-libs-compat-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-client-5.7.24-1.el7.x86_64.rpm
rpm -Uvh mysql-community-server-5.7.24-1.el7.x86_64.rpm
3、查看版本和运行状态
mysql --version
service mysqld status
1、查看磁盘挂载空间
df -h
可以看到,/home目录挂载的磁盘容量有2.7T,所以将MySQL的数据存储路径修改到 /home目录下
2、配置MySQL存储目录
cp /etc/my.cnf /etc/my.cnf.template
vim /etc/my.cnf
3、home目录下创建数据目录,使用软链接链接到默认目录
mkdir -p /home/var/lib/mysql
ln -s /home/var/lib/mysql /var/lib/mysql
ll /var/lib/mysql
1、启动MySQL
service mysqld start
2、查看状态
service mysqld status
3、查看临时密码
grep password /var/log/mysqld.log
4、初始化数据库
sudo /usr/bin/mysql_secure_installation
提示输入密码输入回车键,显示 Disallow root login remotely? [Y/n] 输入n键,其它输入 Y键
如果提示:... Failed! Error: Your password does not satisfy the current policy requirements
将刚刚查询的临时密码输入,作为正式密码
Estimated strength of the password: 25 Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y New password: Re-enter new password: Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Success. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : n Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y All done!
1、查看密码策略
show variables like '%validate_password_policy%';
show variables like '%validate_password_length%';
2、修改密码策略
set global validate_password_policy=0;
set global validate_password_length=1;
3、修改密码为root
set password=password('root');
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('root');
4、 给root用户赋所有权限
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option;
flush privileges;
firewall-cmd --add-port=3306/tcp --permanent
firewall-cmd --reload
firewall-cmd --list-ports
systemctl enable mysqld
chkconfig --add mysqld
rpm -e mysql-community-server
rpm -e mysql-community-client
rpm -e mysql-community-devel
rpm -e mysql-community-libs-compat --nodeps
rpm -e mysql-community-libs --nodeps
rpm -e mysql-community-common
rpm -qa | grep -i mysql
rm -rf /var/lib/mysql/*
rm -rf /var/log/mysql*
rm -rf /var/run/mysqld/*
wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
yum -y localinstall mysql57-community-release-el7-11.noarch.rpm
yum -y install mysql-community-server
mysql --version
systemctl start mysqld