備忘録
mysqladmin -u root password 'the password'
mysql -u root -p
mysql> create database thedb;
mysql> grant all on thedb.* to user@'example.com' identified by "the password";
mysql> flush privileges;
mysql> select user,host from mysql.user;
mysql> select db,host,user from mysql.db;
mysqldump -u user -p 'the password' thedb > db.dump
mysql -u user -p 'the password' thedb < db.dump