mysql / mariaDB 文字コードutf8mb4でのデータベース作成、ユーザー作成

2021 Oct. 24.

$ sudo mysql
> CREATE DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
> GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'localhost' IDENTIFIED BY 'yourpassword' ;
> GRANT ALL PRIVILEGES ON dbname.* TO 'username'@'127.0.0.1' IDENTIFIED BY 'yourpassword' ;
> FLUSH privileges;

参考　mysql / mariaDB utf8mb4での照合順序COLLATE設定 - rokkonet