mysql学习笔记

--创建ambari数据库和ambari用户

CREATE DATABASE ambari DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

CREATE USER 'ambari'@'%'IDENTIFIED BY 'ambari';

GRANT ALL PRIVILEGES ON *.* TO 'ambari'@'%';

FLUSH PRIVILEGES;

--ambari数据库建表:
mysql –uambari –pambari

use ambari;

source /var/lib/ambari-server/resources/Ambari-DDL-MySQL-CREATE.sql;

show tables;

--建示例表
CREATE TABLE workflow.users (

id INT(11) NOT NULL AUTO_INCREMENT,

name VARCHAR(100) NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--时间戳，获取系统当前时间

create table workflow.customer(

id int auto_increment,

name varchar(20),

last_mod timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

primary key(`id`)

) ENGINE=InnoDB default charset=utf8;