いつも忘れるのでメモ。
CREATE DATABASE `dbname` CHARACTER SET utf8;
GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'%' IDENTIFIED BY 'xxxxxxxxxxxx';
xxxxxxxxxxxxはパスワード。
More than 5 years have passed since last update.
いつも忘れるのでメモ。
CREATE DATABASE `dbname` CHARACTER SET utf8;
GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'%' IDENTIFIED BY 'xxxxxxxxxxxx';
xxxxxxxxxxxxはパスワード。
Register as a new user and use Qiita more conveniently