「MySQLでよくやること」の版間の差分

$ mysqldump --single-transaction -u <USER_NAME> -p <DATABASE_NAME> > <FILE_NAME>

$ mysql -u <USER_NAME> -p <DATABASE_NAME> < <FILE_NAME>

# SELECT Host,User FROM mysql.user;

CREATE USER <USER_NAME> IDENTIFIED BY [PASSWORD] '<PASSWORD>';

# RENAME USER <OLD_USER_NAME> TO <NEW_USER_NAME>;

# DROP USER <USER_NAME>;

# SHOW DATABASES;

# USE <DABASE_NAME>;

# CREATE DATABASE <DABASE_NAME>;

# DROP DATABASE <DATABASE_NAME>;