cd\Program Files\MySQL\MySQL Server 8.0\bin

--export
mysqldump -u root -p invoice -h localhost --port 3306 --skip-lock-tables > c:\as_temp\invoice_dump_demo.sql
ils@admin

--import
mysql -u root -p -h localhost --port 3306 --default-character-set=utf8 invoice < c:\as_temp\invoice_dump_demo.sql
ils@admin

--mysql -u root -p -h 34.97.81.145 --port 3306 --default-character-set=utf8 invoice < c:\as_temp\invoice_dump_0902.sql
--Adm_create_2638

--ログイン
mysql -u root -pils@admin

--ユーザ作成
create user 'admin'@'%' identified by 'ils@admin';
grant all on *.* to 'admin'@'%' with grant option;

--ユーザ削除
drop user 'admin'@'%';

--ユーザ一覧
select user, host from mysql.user;

-- dbの削除

show databases;

drop database invoice;

create database invoice;