Mysql常用

1,Mysql 安装

yum install mysql mysql-server mysql-devel -y

yum install mysql-connector-java

2,启动

service mysqld start

3，修改root密码
mysql -u root
use mysql;
update user set password = password('welcome1') where user = 'root';
flush privileges;

4，创建用户

mysql -u root -pwelcome1

use mysql;
delete from user where user ='';
create user 'hive' identified by 'welcome1';
grant all on *.* TO 'hive'@'%' with grant option;
flush privileges;

5，创建数据库
mysql -uhive -phive
create database hive_metastore2 DEFAULT CHARACTER SET utf8;