在线安装(MySQL)
1.验证Centos是否安装MySQL
$>yum list installed | grep mysql
2.删除MySql
$>yum –y remove mysql-libs.X86_64
或
$>yum erase mysql-libs.x86_64
3.验证删除是否成功!
$>yum list installed | grep mysql
4.在线安装MySQL
$>su root
$>yum install mysql
$>yum install mysql-server
5.开启mysql服务
$> service mysqld start
6.验证是否成功
$> service mysqld status
$> netstat –nat (查看3306端口是否开启)
7.root进入Mysql;
$>mysql –u root –p (回车,密码为空,回车),进入到mysql命令行页面
8.创建hive数据库、为hive建立mysql账户
mysql> create user 'hive' identified by '123456';
mysql> CREATE DATABASE hive;
6.MySQL授权
mysql> GRANT ALL PRIVILEGES ON hive.* TO 'hyxy'@'master' IDENTIFIED BY '123456';
mysql> flush privileges;