0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 3 years have passed since last update.

MySQLのインストール・ユーザー作成

Posted at

#MySQLをインストール
sudo yum -y install mysql

##データベースの作成(utf8)
CREATE DATABASE データベース名(任意) DEFAULT CHARACTER SET utf8;

##データベースを表示する
SHOW DATABASES;

##データベースにWordPress管理者用のユーザーとパスワードを登録する
CREATE USER 'ユーザー名'@'%' IDENTIFIED BY 'パスワード';

##作成したユーザーにアクセスを付与
GRANT ALL ON aqua_db.* TO 'ユーザー名'@'%';

##権限の反映
FLUSH PRIVILEGES;

#ユーザーが登録されたかの確認
SELECT user , host FROM mysql.user;

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

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?