[[DataBase]] mysql.txt にファイルがあるとして $ mysql -u root -D study -p < mysql.txt mysql> CREATE DATABASE study DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,CREATE TEMPORARY TABLES, DROP,INDEX,ALTER ON study.* to root@localhost IDENTIFIED BY 'te2309'; use study; show tables; show fields from type1;