源码安装

卸载Centos7自带mariadb

rpm -qa|grep mariadb
mariadb-libs-5.5.64-1.el7.x86_64
rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps

创建mysql安装包存放点

mkdir /export/software/mysql

上传mysql-5.7.29安装包到上述文件夹下、解压

tar xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar

执行安装

yum -y install libaio
rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm mysql-community-libs-5.7.29-1.el7.x86_64.rpm mysql-community-client-5.7.29-1.el7.x86_64.rpm mysql-community-server-5.7.29-1.el7.x86_64.rpm

初始化mysql

mysqld --initialize

更改所属组

chown mysql:mysql /var/lib/mysql -R

启动mysql

systemctl start mysqld.service

查看生成的临时root密码

cat  /var/log/mysqld.log

这行日志的最后就是随机生成的临时密码

[Note] A temporary password is generated for root@localhost: o+TU+KDOm004

修改mysql root密码、授权远程访问

mysql -u root -p

Enter password: #这里输入在日志中生成的临时密码

更新root密码 设置为hadoop

mysql> alter user user() identified by "hadoop";
Query OK, 0 rows affected (0.00 sec)

授权

mysql> use mysql;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'hadoop' WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;

mysql的启动和关闭 状态查看

systemctl stop mysqld
systemctl status mysqld
systemctl start mysqld

建议设置为开机自启动服务

systemctl enable  mysqld

查看是否已经设置自启动成功

systemctl list-unit-files | grep mysqld

---

包管理器安装

sudo apt-get install mysql-server -y

改密码

先su 切换到 root # 用户权限 这样就可以直接 登录MySQL控制台来修改密码

1） 第一次切换会要求设置密码

su passwd

2） 登录到MySQL控制台

mysql

use mysql; 

update user set authentication_string='' where user='root'; --将字段置为空

alter user 'root'@'localhost' identified with mysql_native_password by '123456';

--修改密码为123456