Linux中安装MySQL

在线安装

1.下载mysql并且安装
sudo yum install mysql-server.x86_64

2.启动mysql服务
sudo service mysqld start

3.设置mysql中root密码
mysqladmin -u root password '123456'

4.登陆mysql
mysql -uroot -p123456

5.创建一个账户(hive)和密码(hive) 作为hive的metadata存储
mysql> USE mysql;

删除用户为空数据
mysql> DELETE FROM user WHERE user="";
Query OK, 2 rows affected (0.00 sec)

添加账户和密码
mysql> GRANT ALL ON *.* TO 'hive'@'%' IDENTIFIED BY 'hive';

mysql> FLUSH PRIVILEGES;

6.设置mysql开启自动启动服务
sudo chkconfig mysqld on