• 卸载Centos7自带的mariadb

  [root@node1 ~]# rpm -qa|grep mariadb
  mariadb-libs-5.5.64-1.el7.x86_64
  [root@node1 ~]# rpm -e mariadb-libs-5.5.64-1.el7.x86_64 --nodeps
  [root@node1 ~]# rpm -qa|grep mariadb
  [root@node1 ~]#

• 安装mysql

  mkdir /export/software/mysql
  #上传mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar 到上述文件夹下 解压
  tar -xvf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar
  #执行安装
  yum -y install libaio
  [root@node1 mysql]# 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
  warning: mysql-community-common-5.7.29-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
  Preparing… ################################# [100%]
  Updating / installing…
  1:mysql-community-common-5.7.29-1.e################################# [ 25%]
  2:mysql-community-libs-5.7.29-1.el7################################# [ 50%]
  3:mysql-community-client-5.7.29-1.e################################# [ 75%]
  4:mysql-community-server-5.7.29-1.e################ ( 49%)

• 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

• 修改root密码 授权远程访问 设置开机自启动

[root@node1 ~]# mysql -u root -p
Enter password: #这里输入在日志中生成的临时密码
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.7.29
Copyright © 2000, 2020, 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>
#更新root密码 设置为hadoop
mysql> alter user user() identified by “123456”;
Query OK, 0 rows affected (0.00 sec)
#授权
mysql> use mysql;
mysql> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
mysql> FLUSH PRIVILEGES;
#mysql的启动和关闭 状态查看 （这几个命令必须记住）
systemctl stop mysqld
systemctl status mysqld
systemctl start mysqld
#建议设置为开机自启动服务
[root@node1 ~]# systemctl enable mysqld
Created symlink from /etc/systemd/system/multi-user.target.wants/mysqld.service to /usr/lib/systemd/system/mysqld.service.
#查看是否已经设置自启动成功
[root@node1 ~]# systemctl list-unit-files | grep mysqld
mysqld.service enabled