关于hive里安装mysql出现错误,如何删除指定的主机或用户?(解决Access denied)
前期博客
你可以按照我写的这篇博客去,按照hive的mysql。
1 复习ha相关 + weekend110的hive的元数据库mysql方式安装配置(完全正确配法)(CentOS版本)(包含卸载系统自带的MySQL)
出现如下问题
ERROR 1045 (28000): Access denied for user 'hive'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'hive'@'master' (using password: YES)
ERROR 1045 (28000): Access denied for user 'hive'@'%' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'master' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'%' (using password: YES)
ERROR 1045 (28000): Access denied for user 'root'@'127.0.0.1' (using password: YES)
最后要达到这个目的(才可以解决问题!!!)
进入root用户
mysql> select user,host,password from mysql.user;
mysql> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | master | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| hive | localhost | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |
| hive | master | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |
| hive | % | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |
| root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------+-----------+-------------------------------------------+
关键是hive用户下的这三个配置出来就好, hive@% hive@master hive@localhost
我的这里,是root对各个主机下密码都是root。hive对各个主机密码都是hive。
或者
mysql> select user,host,password from mysql.user;
+------+-----------+-------------------------------------------+
| user | host | password |
+------+-----------+-------------------------------------------+
| root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| root | djt11 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
| hive | localhost | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |
| hive | djt11 | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |
| hive | % | *4DF1D66463C18D44E3B001A8FB1BBFBEA13E27FC |
| root | % | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B |
+------+-----------+-------------------------------------------+
rows in set (0.00 sec)
关键是hive用户下的这三个配置出来就好, hive@% hive@master hive@localhost
我的这里,是root对各个主机下密码都是root。hive对各个主机密码都是hive。
怎么来解决问题?
进入root用户,执行
[root@master native]# mysql -uroot -p
Enter password:(默认是回车)
MySQL> use mysql
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> select host,user from user;
+-----------+------+
| host | user |
+-----------+------+
| % | Hive |
| % | root |
| 127.0.0.1 | root |
| localhost | |
| localhost | root |
| master | |
| master | root |
+-----------+------+
7 rows in set (0.00 sec)
mysql> delete from user where user=' ';
Query OK, 2 rows affected (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from user;
+-----------+------+
| host | user |
+-----------+------+
| % | hive |
| % | root |
| 127.0.0.1 | root |
| localhost | root |
| master | root |
+-----------+------+
5 rows in set (0.00 sec)
mysql> delete from user where host='127.0.0.1';
Query OK, 1 row affected (0.00 sec)
mysql> delete from user where host='localhost';
Query OK, 1 row affected (0.00 sec)
mysql> commit;
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from user;
+--------+------+
| host | user |
+--------+------+
| % | hive |
| % | root |
| master | root |
+--------+------+
3 rows in set (0.00 sec)
mysql> delete from user where user='hive';
Query OK, 1 row affected (0.00 sec)
mysql> select host,user from user;
+--------+------+
| host | user |
+--------+------+
| % | root |
| master | root |
+--------+------+
2 rows in set (0.00 sec)
mysql> grant all privileges on hive.* to hive@'%' identified by 'hive' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from user;
+--------+------+
| host | user |
+--------+------+
| % | hive |
| % | root |
| master | root |
+--------+------+
3 rows in set (0.00 sec)
mysql> grant all privileges on hive.* to hive@'master' identified by 'hive' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from user;
+--------+------+
| host | user |
+--------+------+
| % | hive |
| % | root |
| master | hive |
| master | root |
+--------+------+
4 rows in set (0.00 sec)
mysql> grant all privileges on hive.* to hive@'localhost' identified by 'hive' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> select host,user from user;
+--------+------+
| host | user |
+--------+------+
| % | hive |
| % | root |
| master | hive |
| master | root |
| master | localhost|
进入root用户查看database的效果
[root@master native]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.1.61 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| hive |
| mysql |
| test |
+--------------------+
4 rows in set (0.00 sec)
进入hive用户查看database的效果
[root@master native]# mysql -uhive -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 14
Server version: 5.1.61 Source distribution
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| hive |
| test |
+--------------------+
3 rows in set (0.00 sec)
mysql> use hive;
Database changed
mysql> show tables;
Empty set (0.00 sec)
mysql>
同时,大家可以关注我的个人博客:
http://www.cnblogs.com/zlslch/ 和 http://www.cnblogs.com/lchzls/ http://www.cnblogs.com/sunnyDream/
详情请见:http://www.cnblogs.com/zlslch/p/7473861.html
人生苦短,我愿分享。本公众号将秉持活到老学到老学习无休止的交流分享开源精神,汇聚于互联网和个人学习工作的精华干货知识,一切来于互联网,反馈回互联网。
目前研究领域:大数据、机器学习、深度学习、人工智能、数据挖掘、数据分析。 语言涉及:Java、Scala、Python、Shell、Linux等 。同时还涉及平常所使用的手机、电脑和互联网上的使用技巧、问题和实用软件。 只要你一直关注和呆在群里,每天必须有收获
对应本平台的讨论和答疑QQ群:大数据和人工智能躺过的坑(总群)(161156071)
最新文章
- NYOJ----776删除元素
- WinForm------GridControl合并单元格
- C++中的类访问控制
- centos 正确 安装 jdk
- Python学习(四) Python数据类型:序列(重要)
- VS2013+MFC串口控件的简单上位机
- Spring Boot面试题
- 【Qt编程】Qt学习之状态栏
- CMake set 语法
- Spotlight LGWR1 一直告警
- linux | 网卡驱动
- mysql基础讲解
- Linux内核源码分析--内核启动之(5)Image内核启动(rest_init函数)(Linux-3.0 ARMv7)【转】
- C#Listview添加数据,选中最后一行,滚屏
- Java面试题基础知识(收集)
- 十天精通CSS3(11)
- python打印ms
- 解决oninput在输入中文时,会获取拼音的问题
- Spring 如何在 WEB 应用中使用
- LINQ 学习之筛选条件
热门文章
- django项目所遇问题总结
- 从2014年D2前端技术论坛看前端发展趋势
- js实现table排序(jQuery下的jquery.sortElements)
- [Python] String Join
- POJ 1328 Radar Installation 贪心题解
- git 回滚到任意版本
- 深入理解Android(4)——理解Android中的JNI(下)
- [ Java ] [ Spring ] [ Spring MVC ] Tutorial
- C#List<;string>;和string[]之间的相互转换
- OpenCV —— 视频播放控制