以 hadoop 用户登录系统,
1. 检测系统是否已经安装过 MySQL 或其依赖, 若已装过要先将其删除, 否则第 4 步使用 yum 安装时会报错:
- # 查看 MySQL 是否安装, 如果已经安装需要卸载, 如果是
- sudo rpm -qa|grep MySQL
2, 如果存在 MySQL, 依次卸载
- sudo yum -y remove MySQL-community-server-5.7.23-1.el6.x86_64
- sudo yum -y remove MySQL-community-libs-5.7.23-1.el6.x86_64
- sudo yum -y remove MySQL-community-common-5.7.23-1.el6.x86_64
- sudo yum -y remove MySQL-community-client-5.7.23-1.el6.x86_64
- find / -name MySQL
- sudo rm -rf /var/lib/MySQL
- sudo rm -rf /var/lib/MySQL/MySQL
- sudo rm -rf /usr/share/MySQL
3, 解压依次安装
- tar -xvf MySQL-5.7.23-1.el6.x86_64.rpm-bundle.tar
- #解压
- sudo rpm -ivh MySQL-community-common-5.7.23-1.el6.x86_64.rpm
- sudo rpm -ivh MySQL-community-libs-5.7.23-1.el6.x86_64.rpm
- sudo rpm -ivh MySQL-community-client-5.7.23-1.el6.x86_64.rpm
- sudo rpm -ivh MySQL-community-server-5.7.23-1.el6.x86_64.rpm
4, 启动服务
sudo service mysqld start #启动 mysqld 服务
5, 修改配置文件无密码登录
sudo vi /etc/my.cnf
在最尾部加上
skip-grant-tables
保存
6, 重启 MySQL 服务
sudo service mysqld restart
7, 修改密码, mysql5.7 用此语法
- use MySQL;
- update MySQL.user set authentication_string=password('1111') where user='root';
- flush privileges;
8, 回到第二步骤去掉加上的
skip-grant-tables
9, 以 root 用户登录
- use MySQL;
- select 'host' from user where user='root';
- update user set host = '%' where user ='root';
- flush privileges;
来源: http://www.bubuko.com/infodetail-2867868.html