test_utf8-cleate2.sql

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER
ON test_utf8.*
TO test_utf8@localhost
IDENTIFIED BY 'Fetmah!esEr9';
CREATE DATABASE test_utf8 CHARACTER SET utf8mb4;
USE test_utf8;
CREATE TABLE test_utf8.moji(id int, moji text);
INSERT INTO test_utf8.moji(id, moji) values( '1', 'あいうえお' );
INSERT INTO test_utf8.moji(id, moji) values( '2', '寿司🍣susi');

FLUSH PRIVILEGES;