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_0902_188.sql

--import
mysql -u root -p -h localhost --port 3306 --default-character-set=utf8 invoice < c:\as_temp\invoice_dump_0902.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 admin -p -h 192.168.10.99 --port 3306 --default-character-set=utf8 invoice < c:\as_temp\invoice_dump_0902.sql
ils@admin

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;



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