MySQLよく使うコマンド

-- Rootユーザーのパスワード変更
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password';

-- ユーザー作成
CREATE USER 'hoge'@'localhost' IDENTIFIED BY 'hogehoge';
GRANT ALL PRIVILEGES ON * . * TO 'hoge'@'localhost';
FLUSH PRIVILEGES;

--Dump
mysqldump -u root -p -h localhost DB_NAME > OUTPUT_FILENAME

-- Restore
mysql -u root -p DB_NAME < SQL_FILE_NAME