ユーザー管理

create user create user {user} identified by ‘{password}’; apply priviledge grant all privileges on {databse}.* to ‘{user}’ set password set password = password(‘{password}’) or set password for {user} = password(‘{password}’) List Users select User from mysql.user;  

mysql-table

create table create table items(id int primary key auto_increment,name text); add column alter table {tablename} add {columname} {columtype} show column show columns from {tablename}

mysql-db

create database create database {database} delete database drop database {database} delete database only data truncate database {database} or delete database {database} show databases show databases backup and restore database #backup mysqldump -u {user} -p {database name}>{filename} #restore mysql -u {user} -p {database name}<{filename}