cdh_mysql
来源:互联网 发布:kindle jivo套淘宝 编辑:程序博客网 时间:2024/06/02 21:09
1、安装mysql
sudo yum install mysql-server
2、查看mysql的运行状态
sudo service mysqld status
3、开机启动
sudo chkconfig mysqld on
sudo chkconfig --list mysqld
4、连接mysql
mysql -h localhost -u root -p (默认密码为空)
5、修改root密码
sudo /usr/bin/mysql_secure_installation (password:123456)
6、安装jdbc dirver
tar zxvf mysql-connector-java-5.1.31.tar.gz
sudo cp mysql-connector-java-5.1.31/mysql-connector-java-5.1.31-bin.jar /usr/share/java/mysql-connector-java.jar
sudo mkdir -p /usr/share/java/ (如不存在需要创建)
7、创建dbcreate database database DEFAULT CHARACTER SET utf8;grant all on database.* TO 'user'@'%' IDENTIFIED BY 'password';
create database amon default character utf8;
grant all on amon.* to 'amon'@'%' identified by 'amon_password';
create database rman default character utf8;
grant all on rman.* to 'rman'@'%' identified by 'rman_password';
8、HUE
create database hue default character utf8;
grant all on hue.* to 'hue'@'%' identified by 'secretpassword';
9、OOZIE
create database OOZIE default character utf8;
grant all on oozie.* to 'oozie'@'%' identified by 'oozie';
0 0
- cdh_mysql
- 欢迎使用CSDN-markdown编辑器
- BeanUtils和PropertyUtils的区别
- POJ 3259 Wormholes(BellmanFord判负环)
- 设计模式前言
- Ubuntu安装Apache,PHP,MySQL,PHPMyAdmin,SSH服务
- cdh_mysql
- 【Qt开发】【VS开发】VS2010+Qt开发环境搭建
- centos中安装配置ftp服务器
- enterprise architect 12生成DDL问题
- android安全学习之1—什么是数字签名、数字证书
- C++输入输出函数的用法(转载)
- 安卓NDK开发中遇到的坑
- 2016.08.16【初中部 NOIP提高组 】模拟赛C题解
- CSS之盒子模型