LoginSignup
0
0

More than 5 years have passed since last update.

mysqlでデータベースとユーザーを作って全ての権限を与える

Posted at

いつも忘れるのでメモ。

CREATE DATABASE `dbname` CHARACTER SET utf8;
GRANT ALL PRIVILEGES ON `dbname`.* TO 'username'@'%' IDENTIFIED BY 'xxxxxxxxxxxx';

xxxxxxxxxxxxはパスワード。

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0