SQL

■ﾕｰｻﾞｰ作製
grant all privileges on *.* to admin@localhost identified by 'vfrtyhnbg' ;
FLUSH PRIVILEGES;
■パスワード変更
SET PASSWORD FOR admin@"%"=PASSWORD('pass');
■ﾃﾞｰﾀﾍﾞｰｽ作成
create database [ﾃﾞｰﾀﾍﾞｰｽ名] character set utf8;
■ﾃｰﾌﾞﾙ作成
CREATE TABLE IF NOT EXISTS `t1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`text` text,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;