喜旎果 发表于 2018-10-7 12:12:37

CentOS7.2安装MySQL 5.7.10-12666595

  1.下载MySQL源
  wget http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm
  2.安装MySQL源
  sudo rpm -ivh mysql57-community-release-el7-7.noarch.rpm
  3.安装mysql-community-server
  sudo yum install mysql-community-server -y
  4.重启mysql
  systemctl restart mysqld
  注:自动启动服务用 systemctl enable mysql
  5.查看临时密码
  grep 'A temporary password' /var/log/mysqld.log
  2015-12-24T08:04:50.296020Z 1 A temporary password is generated for root@localhost: I(eKs9PyklP_
  6.用临时密码登录mysql并修改root密码,新增用户,打开远程访问
  >mysql -uroot -p
  Enter password:
  Welcome to the MySQL monitor.Commands end with ; or \g.

  Your MySQL connection>  Server version: 5.7.10 MySQL Community Server (GPL)
  Copyright (c) 2000, 2015, 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>>  Query OK, 0 rows affected (0.00 sec)
  mysql> flush privileges;
  Query OK, 0 rows affected (0.00 sec)

  mysql> create user hadoop>  Query OK, 0 rows affected (0.00 sec)

  mysql>grant all privileges on *.* to 'root'@'%'>  Query OK, 0 rows affected, 1 warning (0.00 sec)
  7.打开防火墙并重启防火墙,确认端口
  sudofirewall-cmd --permanent --add-service mysql
  systemctl restart firewalld.service
  iptables -L -n|grep 3306

页: [1]
查看完整版本: CentOS7.2安装MySQL 5.7.10-12666595