1. インストール
|
1 |
$ sudo yum install mysql57-server |
2. サービス自動起動の設定
|
1 |
$ sudo chkconfig mysqld on |
3. サービスの起動
|
1 |
$ sudo service mysqld start |
4. デフォルトDBへの接続
|
1 2 3 4 5 6 7 |
$ mysql -u root Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.7.20 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. ... 後略 |
5. セキュアな設定への変更
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
$ sudo /usr/libexec/mysql57/mysql_secure_installation Securing the MySQL server deployment. Connecting to MySQL using a blank password. The 'validate_password' plugin is installed on the server. The subsequent steps will run with the existing configuration of the plugin. Please set the password for root here. New password: Re-enter new password: Estimated strength of the password: 100 Do you wish to continue with the password provided?(Press y|Y for Yes, any other key for No) : y By default, a MySQL installation has an anonymous user, allowing anyone to log into MySQL without having to have a user account created for them. This is intended only for testing, and to make the installation go a bit smoother. You should remove them before moving into a production environment. Remove anonymous users? (Press y|Y for Yes, any other key for No) : y Success. Normally, root should only be allowed to connect from 'localhost'. This ensures that someone cannot guess at the root password from the network. Disallow root login remotely? (Press y|Y for Yes, any other key for No) : y Success. By default, MySQL comes with a database named 'test' that anyone can access. This is also intended only for testing, and should be removed before moving into a production environment. Remove test database and access to it? (Press y|Y for Yes, any other key for No) : y - Dropping test database... Success. - Removing privileges on test database... Success. Reloading the privilege tables will ensure that all changes made so far will take effect immediately. Reload privilege tables now? (Press y|Y for Yes, any other key for No) : y Success. All done! |
(註) パスワードには特殊文字を含める必要あり。いつものパスワード + 特殊文字の #
6. データベースとDBユーザーの作成
|
1 2 3 4 5 6 7 8 9 10 11 |
mysql> CREATE USER database_user@localhost IDENTIFIED by 'database_user_password'; Query OK, 0 rows affected (0.01 sec) mysql> CREATE DATABASE `database4wordpress`; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON `database4wordpress`.* TO database_user@localhost; Query OK, 0 rows affected (0.00 sec) mysql> FLUSH PRIVILEGES; Query OK, 0 rows affected (0.00 sec) |