MYSQL数据库安装
一、准备工作
1.还原快照
2.调整2G内存
3.请关闭防火墙和selinux
# systemctl stop firewalld
# systemctl disable firewalld
# setenforce 0
# vim /etc/selinux/config——>SELINUX=disabled
4.下载必要的工具
# yum -y install lrzsz wget
二、安装Mysql
1.访问国内mysql镜像站
http://mirrors.ustc.edu.cn/(中国科学技术大学开源软件镜像)
2.下载软件包
# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-server-5.7.25-1.el7.x86_64.rpm
# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-client-5.7.25-1.el7.x86_64.rpm
# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-common-5.7.25-1.el7.x86_64.rpm
# wget http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/mysql-community-libs-5.7.25-1.el7.x86_64.rpm
已经有的话,通过rz
上传到服务器。
3.安装相关软件
# yum install -y net-tools.x86_64 libaio.x86_64 perl.x86_64
4.安装Mysql服务器
# yum install -y mysql-community*
若存在报错,卸载冲突的软件包,再安装
# yum remove -y mariadb-libs.x86_64
# yum install -y mysql-community*
5.启动Mysql服务器
#systemctl start mysqld
#systemctl enable mysqld
#systemctl status mysqld
6.查询Mysql服务器默认密码
# grep 'password' /var/log/mysqld.log
注:冒号和空格的后面,全都是密码
7.修改Mysql服务器密码
# mysqladmin -uroot -p'es,W;ya(K1Th' password 'QianFeng@123'
8.登录Mysql系统
# mysql -uroot -p'QianFeng@123'
9.查到默认数据库
10.关机快照
三、扩展:
通过配置文件设置密码强度
[root@mysql-server ~]# vim /etc/my.cnf #在最后添加如下内容
validate_password=off
[root@mysql-server ~]# systemctl restart mysqld #重启mysql生效
可以用第二种方式修改为简单的密码:
[root@mysql-server ~]# mysqladmin -uroot -p'QianFeng@123' password 'qf123'
mysqladmin: [Warning] Using a password on the command line interface can be insecure.
Warning: Since password will be sent to server in plain text, use ssl connection to ensure password safety.
[root@mysql-server ~]# mysql -uroot -pqf123
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 3
Server version: 5.7.27 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> exit
Bye