linux小白自学日记--自己转载一些 仅供自己学习记忆

在线安装(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;