Hadoop集群MySQL搭建

1. 卸载本机自带的MySQL（mariadb）

   1.	rpm - qa|grep mariadb
   2.	rpm -qa|grep java（补充：卸载本机自带的openjdk）
   3.	rpm -e --nodeps .........	

2. 安装commeon包

   1.	rpm -ivh --nodeps --force mysql-community-common-5.7.28-1.el7.x86_64.rpm
   2.	rpm -ivh --nodeps --force mysql-community-libs-5.7.28-1.el7.x86_64.rpm
   3.	rpm -ivh --nodeps --force mysql-community-client-5.7.28-1.el7.x86_64.rpm
   4.	rpm -ivh --nodeps --force mysql-community-server-5.7.28-1.el7.x86_64.rpm

3. 开启MySQL服务并查看服务

   1.	systemctl enable mysqld
   2.	systemctl strat mysqld
   3.	systemctl status mysqld
   4.	grep 'temporary password' /var/log/mysql.log（查看MySQL密码）
   

4. 登录并修改root账户的密码

   1.	mysql -u root -p
   2.	set global validate_password_policy=0;(解决密码不符合策略问题，设置密码的强度为最低)
   3.	set global validate_password_length=4;(设置最小长度为4)
   4.	set password for 'root'@'localhost'=password('密码');
   5.	grant all privileges on *.* to 'root'@'%' identified by '密码’ with grant option;
       (允许root账户远程访问)
   6.	create user '用户名' @'%' identified by '密码’(新建用户)
   7.	select host,user from user(查询所有用户)		
   8.	flush privileges(刷新)
   9.	创建数据库并设定编码格式：
       create database dbname default character set utf8;
   10.	ALTER TABLE `table` DEFAULT CHARACTER SET utf8;  修改表的编码格式

   ---

   需要全套搭建最简化的视频与全套安装包的请添加群924338546