linux简单配置mysql数据库

下载命令

复制到命令行下载

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

---

安装相关软件

yum  install  -y   net-tools.x86_64  libaio.x86_64   perl.x86_64

---

安装mysql服务器

如果有mariadb，请卸载避免冲突

yum remove -y mariadb-libs.x86_64

没有mariadb，就直接安装

yum install -y mysql-community*

---

启动服务器

systemctl start mysqld    //启动
systemctl enable mysqld   //设置开机自启
systemctl status mysqld   //查询mysql状态

---

查询mysql初始密码

cat /var/log/mysqld.log  | grep 'password'

冒号后除空格外，全是密码。

---

登录mysql

密码直接复制

mysql -uroot -p'edkfT4U=7d#;'

登录成功

---

修改密码

mysqladmin -uroot  -p'es,W;ya(K1Th'  password  '你想修改的密码'

---