hadoop 搭建mysql数据库

1.首先卸载命令
yum remove mariadb-libs
yum install perl -y

2.在usr中添加mysql目录拖入mysql压缩包 /usr/mysql/

3.在虚拟机中进入mysql目录 cd /usr/mysql
输入tar -zxvf mysql-5.7.28-1.el7.x86_64.rpm-bundle.tar 解压mysql压缩包
输入以下命令
rpm -ivh mysql-community-common-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.28-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.28-1.el7.x86_64.rpm

在输入rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm这条命令出现报错
这是由于yum安装了旧版本的GPG keys造成的

warning: mysql-community-server-5.7.28-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
net-tools is needed by mysql-community-server-5.7.28-1.el7.x86_64

解决方案 输入 rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm –force --nodeps命令就解决了

4.装好mysql后,启动mysql设置为开机启动
systemctl start mysqld
systemctl enable mysqld

这里有报错信息

解决
yum -y install perl net-tools

 rpm -ivh mysql-community-server-5.7.28-1.el7.x86_64.rpm

5.打开/var/log/mysqld.log,找到

A temporary password is generated for root@localhost:你的密码
必须加引号不加引号会报错 ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: YES)
类如 mysql -uroot -p",.VkvATrT0DQ"

6.进入mysql修改密码 修改安全等级,现在长度最低4位数
set global validate_password_policy=low;
set global validate_password_length=8;

7.开启mysql远程连接
mysql>GRANT ALL PRIVILEGES ON . TO root@’%’ IDENTIFIED BY ‘12345678’;

立刻生效
mysql> flush privileges;

8.修改mysql配置 进入 vi /etc/my.cnf
增加 lower_case_table_names=1，即 mysql 不区分大小写.

9.最后重启mysql
systemctl restart mysqld