linux mysql运维_Linux之开源数据库MySQL DBA运维实战

部署MySQL (5.7版本)

防火墙Selinux关闭

# systemctl stop firewalld

# systemctl disable firewalld

# setenforce 0

# vim /etc/selinux/config

SELINUX=disabled

下载软件包

[root@localhost ~]# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-server-5.7.25-1.el7.x86_64.rpm

[root@localhost ~]#wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-client-5.7.25-1.el7.x86_64.rpm

[root@localhost ~]# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-common-5.7.25-1.el7.x86_64.rpm

[root@localhost ~]# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-libs-5.7.25-1.el7.x86_64.rpm

安装相关所需软件

[root@localhost ~]# yum install -y net-tools.x86_64 libaio.x86_64 perl.x86_64

软件包下载后安装软件

[root@localhost ~]# yum install -y mysql-community*

若出现以下异常

解决方法：卸载冲突的软件包，再安装

[root@localhost ~]# yum remove -y mariadb-libs.x86_64

[root@localhost ~]# yum install -y mysql-community*

启动mysql

[root@localhost ~]#systemctl start mysqld

[root@localhost ~]#systemctl enable mysqld

[root@localhost ~]#systemctl status mysqld //查询状态确认

查询mysql默认密码

[root@localhost ~]# grep 'password' /var/log/mysqld.log

2020-03-11T13:04:52.301614Z 1 [Note] A temporary password is generated for root@localhost: o*:Sad%VU7#p

o*:Sad%VU7#p 为密码

修改mysql密码

[root@localhost ~]# mysqladmin -uroot -p'o*:Sad%VU7#p' password 'QianFeng@123'

登录数据库

[root@localhost ~]# mysql -uroot -p'QianFeng@123'

mysql: [Warning] Using a password on the command line interface can be insecure.

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 5

Server version: 5.7.25 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

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>

登录成功