随笔分类 -  mysql

hive-连接查询
摘要：内连接查询hive> select * from customer as c , orderInfo as o where c.id = o.cid;11 tom1 1 cc price1 1112 tom2 2... 阅读全文
posted @ 2018-08-28 17:21 crr121 阅读(373) 评论(0) 推荐(0)
beeline执行insert命令时报错Permission denied: user=anonymous, access=EXECUTE, inode="/tmp/hadoop-yarn":xiao
摘要：0: jdbc:hive2://localhost:10000/cr> insert into student values(4,'sunny');WARNING: Hive-on-MR is deprecated in Hive 2 and may not be a... 阅读全文
posted @ 2018-08-19 11:26 crr121 阅读(2031) 评论(0) 推荐(0)
hive初始化元数据 Access denied for user 'xiaoqiu'@'%' to database 'hive_metastore'
摘要：[xiaoqiu@s150 /soft/hive/conf]$ schematool -initSchema -dbType mysqlSLF4J: Class path contains multiple SLF4J bindings.SLF4J: Found bi... 阅读全文
posted @ 2018-08-19 11:25 crr121 阅读(511) 评论(0) 推荐(0)
MySQL新建用户无法登录
摘要：Access denied for user xiaoqiu@localhost (using password :NO) resolution:删除匿名用户（mysql.user表中user为空的用户）delete from user where mysql.us... 阅读全文
posted @ 2018-08-19 11:25 crr121 阅读(206) 评论(0) 推荐(0)
ERROR 1133 (42000): Can't find any matching row in the user table
摘要：当执行下面的命令时出现上述errorMariaDB [(none)]> grant all privileges on hive_meta.* to 'xiaoqiu'@'%';ERROR 1133 (42000): Can't find any matching r... 阅读全文
posted @ 2018-08-19 11:25 crr121 阅读(1677) 评论(0) 推荐(0)
Failed to stop mariadb.service: Interactive authentication required.
摘要：换成root用户就可以了[root@s150 /home/xiaoqiu]# systemctl stop mariadb.service 阅读全文
posted @ 2018-08-19 11:24 crr121 阅读(2231) 评论(0) 推荐(0)
Underlying cause: java.sql.SQLException : Access denied for user 'root'@'s150' (using password: YES)
摘要：hive初始化元数据的时候出错，该root用户没有权限[xiaoqiu@s150 /soft/hive/conf]$ schematool -initSchema -dbType mysqlSLF4J: Class path contains multiple SLF... 阅读全文
posted @ 2018-08-19 11:23 crr121 阅读(1618) 评论(0) 推荐(0)
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
摘要： 阅读全文
posted @ 2018-08-19 11:23 crr121 阅读(109) 评论(0) 推荐(0)
java.net.ConnectException: Call From s150/192.168.109.150 to s150:8020 failed on connection excepti
摘要：启动hive遇到连接的问题：Exception in thread "main" java.lang.RuntimeException: java.net.ConnectException: Call From s150/192.168.109.150 to s150... 阅读全文
posted @ 2018-08-19 11:23 crr121 阅读(1451) 评论(0) 推荐(0)
MariaDB [(none)]> drop user cr; ERROR 1396 (HY000): Operation DROP USER failed for 'cr'@'%'
摘要：首先查看mysql.user表中是否存在该用户如果存在，更新权限MariaDB [(none)]> flush privileges;重新执行删除操作（注意删除的时候要写全称）MariaDB [(none)]> drop user 'cr'@'localhost';查... 阅读全文
posted @ 2018-07-04 09:09 crr121 阅读(615) 评论(0) 推荐(0)
mysqld_safe A mysqld process already exists
摘要：解决办法： 阅读全文
posted @ 2018-07-04 08:59 crr121 阅读(693) 评论(0) 推荐(0)
centos7自带数据库MariaDB重启和修改密码
摘要：1：MariaDB和mysql差不多是mysql的一个分支，完全兼容mysql的命令。2：centos 7 中自带MariaDB， 需要在centos中安... 阅读全文
posted @ 2018-07-04 08:19 crr121 阅读(2006) 评论(0) 推荐(0)
MySQL创建用户，并设置指定访问数据库
摘要：一、创建用户并授权1. 登录mysql mysql -u root -q输入密码2. 创建数据库(已有数据库就不需要建立)create database newDB;//以创建newDB为例3. 创建用户创建userone,只能本地访问　create u... 阅读全文
posted @ 2018-07-03 18:47 crr121 阅读(360) 评论(0) 推荐(0)
Mysql中新建用户，设置密码
摘要：Mysql中新建用户，设置密码新建用户step 1.创建用户： CREATE USER 'aaa'@'%' IDENTIFIED BY '123456';表示创建... 阅读全文
posted @ 2018-07-03 18:41 crr121 阅读(1066) 评论(0) 推荐(0)
navicat连接Linux数据报错can't connect server error 2003
摘要：linux配置防火墙打开3306端口 安装完MYSQL服务器后在本机所有操作都正常, 但在其它机器上... 阅读全文
posted @ 2018-05-07 17:08 crr121 阅读(529) 评论(0) 推荐(0)
MySQL存储过程以及Java调用ca'llablestatment
摘要：1、创建存储过程SQL语句#创建存储过程create procedure mysql_add(in x1 int,in x2 int , out y int) begin set y := x1 + x2; end#调用存储过程call mysql_add(2,3... 阅读全文
posted @ 2018-03-06 17:09 crr121 阅读(137) 评论(0) 推荐(0)
mysql函数
摘要：1、创建函数#创建函数create function fun_add(x1 int,x2 int) returns INT begin return x1 + x2; end#查看函数show function status;show function stat... 阅读全文
posted @ 2018-03-06 17:06 crr121 阅读(130) 评论(0) 推荐(0)
jdbc事务并发现象
摘要：1、脏读1.1避免脏读现象#避免脏读#开启事务Astart transaction;#关闭自动提交set @@autocommit = 0show variables like '%autocommit%'update student set name = 'kang... 阅读全文
posted @ 2018-03-06 17:06 crr121 阅读(260) 评论(0) 推荐(0)