-
卸载本机自带的MySQL(mariadb)
1. rpm - qa|grep mariadb 2. rpm -qa|grep java(补充:卸载本机自带的openjdk) 3. rpm -e --nodeps .........
-
安装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
-
开启MySQL服务并查看服务
1. systemctl enable mysqld 2. systemctl strat mysqld 3. systemctl status mysqld 4. grep 'temporary password' /var/log/mysql.log(查看MySQL密码)
-
登录并修改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
Hadoop集群MySQL搭建
最新推荐文章于 2021-12-13 10:51:13 发布