Linux安装mysql后所进行的一些配置包括修改密码

1.[oracle@hadoop100 ~]$ sudo systemctl status mysqld.service
 

2.[oracle@hadoop100 ~]$ sudo systemctl start mysqld.service

3.[oracle@hadoop100 ~]$ sudo vim /var/log/mysqld.log
#进入查看原密码是多少，一般在前几行数字有个唯一的1后面，复制密码

4.[oracle@hadoop100 ~]$ mysql -uroot -p    #粘贴刚才复制的密码然后回车

**set password = password('112233aA~')**#在这里随便输入一个临时密码
**;**

---

**show variables like 'validate_password%';**#查看密码栏

• 我们将密码长度设为6，以方便记忆

**set global validate_password_length = 6;**
**set global validate_password_policy=LOW;**#设为低级
**set password=password('******')**#括号里设为自己的密码

cd /opt/software/
tar -zxvf mysql-connector-java-5.1.48.tar.gz

ll查看会看到多了一个，进去查看内容

接下来进入到hive中，修改一个文档

cd /opt/modules/hive/
cd conf/
vim hive-site.xml

1. 将以下代码粘贴到xml中

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://**hadoop102:3306**/metastore?createDatabaseIfNotExist=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>
 
<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
  <description>Driver class name for a JDBC metastore</description>
</property>
 
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>root</value>
  <description>username to use against metastore database</description>
</property>
 
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>**000000**</value>
  <description>password to use against metastore database</description>
</property>
</configuration>

将加粗的Hadoop改为自己刚才虚拟机的名称，还有下面的六个0改为自己的密码

mysql -uroot -p #输入刚才自己设好的密码
create database metastore
;

use mysql;
show tables;
select User ,Host from user;

update user set Host='%' where Host='localhost'; #这一步是将localhost改为%

select User ,Host from user;
--------------
delete from user where User = 'mysql.session';
delete from user where User = 'mysql.sys';
#删除掉mysql.session和mysql.sys的两条记录

到这里就基本完事了，重新启动虚拟机，在Hadoop100中输入start-dfs.sh,hadoop101中输入start-yarn.sh,开启hive查看是否成功