この文書の現在のバージョンと選択したバージョンの差分を表示します。
linux:mysql [2008/09/23 16:49] miyako |
linux:mysql [2008/09/26 02:00] (現在) miyako |
||
---|---|---|---|
ライン 1: | ライン 1: | ||
このwikiでは基本的にCentOSなどREDHAT系OSでの操作方法をまとめています。 | このwikiでは基本的にCentOSなどREDHAT系OSでの操作方法をまとめています。 | ||
+ | |||
+ | ====== MySQL ====== | ||
===== インストール ===== | ===== インストール ===== | ||
ライン 58: | ライン 60: | ||
http://www.mysql.com\\ | http://www.mysql.com\\ | ||
Support MySQL by buying support/licenses at http://shop.mysql.com\\ | Support MySQL by buying support/licenses at http://shop.mysql.com\\ | ||
- | [ OK ]\\ | + | [ OK ]\\ |
- | MySQL を起動中: [ OK ]\\ | + | MySQL を起動中: [ OK ]\\ |
* 自動起動するように設定しておく | * 自動起動するように設定しておく | ||
chkconfig mysqld on | chkconfig mysqld on | ||
+ | |||
+ | ===== 初期設定 ===== | ||
+ | # mysql_secure_installation | ||
+ | |||
+ | NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL\\ | ||
+ | SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!\\ | ||
+ | \\ | ||
+ | \\ | ||
+ | In order to log into MySQL to secure it, we'll need the current\\ | ||
+ | password for the root user. If you've just installed MySQL, and\\ | ||
+ | you haven't set the root password yet, the password will be blank,\\ | ||
+ | so you should just press enter here.\\ | ||
+ | \\ | ||
+ | Enter current password for root (enter for none): ← 空ENTER\\ | ||
+ | OK, successfully used password, moving on...\\ | ||
+ | \\ | ||
+ | Setting the root password ensures that nobody can log into the MySQL\\ | ||
+ | root user without the proper authorisation.\\ | ||
+ | \\ | ||
+ | Set root password? [Y/n] ← 空ENTER(rootパスワード設定)\\ | ||
+ | New password: ← rootパスワード応答\\ | ||
+ | Re-enter new password: ← rootパスワード応答(確認)\\ | ||
+ | Password updated successfully!\\ | ||
+ | Reloading privilege tables..\\ | ||
+ | ... Success!\\ | ||
+ | \\ | ||
+ | \\ | ||
+ | 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? [Y/n] ← 空ENTER(匿名ユーザー削除)\\ | ||
+ | ... 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? [Y/n] ← 空ENTER(リモートからのrootログイン禁止)\\ | ||
+ | ... 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? [Y/n] ← 空ENTER(testデータベース削除)\\ | ||
+ | - 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? [Y/n] ← 空ENTER\\ | ||
+ | ... Success!\\ | ||
+ | \\ | ||
+ | Cleaning up...\\ | ||
+ | \\ | ||
+ | \\ | ||
+ | \\ | ||
+ | All done! If you've completed all of the above steps, your MySQL\\ | ||
+ | installation should now be secure.\\ | ||
+ | \\ | ||
+ | Thanks for using MySQL!\\ | ||
+ | |||
+ | |||
+ | |||
+ |