差分
この文書の現在のバージョンと選択したバージョンの差分を表示します。
|
linux:mysql [2008/09/23 16:40] miyako |
linux:mysql [2008/09/26 02:00] (現在) miyako |
||
|---|---|---|---|
| ライン 1: | ライン 1: | ||
| このwikiでは基本的にＣｅｎｔＯＳなどＲＥＤＨＡＴ系ＯＳでの操作方法をまとめています。 | このwikiでは基本的にＣｅｎｔＯＳなどＲＥＤＨＡＴ系ＯＳでの操作方法をまとめています。 | ||
| + | |||
| + | ====== MySQL ====== | ||
| ===== インストール ===== | ===== インストール ===== | ||
| ライン 8: | ライン 10: | ||
| ===== 設定 ===== | ===== 設定 ===== | ||
| * 文字コードをUTF-8にする | * 文字コードをUTF-8にする | ||
| - | |||
| # vi /etc/my.cnf | # vi /etc/my.cnf | ||
| - | [mysqld]\\ | + | [mysqld]\\ |
| - | datadir=/var/lib/mysq\\l | + | datadir=/var/lib/mysq\\l |
| - | socket=/var/lib/mysql/mysql.sock\\ | + | socket=/var/lib/mysql/mysql.sock\\ |
| - | # Default to using old password format for compatibility with mysql 3.x\\ | + | # Default to using old password format for compatibility with mysql 3.x\\ |
| - | # clients (those using the mysqlclient10 compatibility package).\\ | + | # clients (those using the mysqlclient10 compatibility package).\\ |
| - | old_passwords=1\\ | + | old_passwords=1\\ |
| - | default-character-set = utf8 ←追加\\ | + | default-character-set = utf8 ←追加\\ |
| - | [mysql] ←追加\\ | + | [mysql] ←追加\\ |
| - | default-character-set = utf8 ←追加\\ | + | default-character-set = utf8 ←追加\\ |
| ===== 起動 ===== | ===== 起動 ===== | ||
| # service mysqld start | # service mysqld start | ||
| - | <code> | ||
| - | MySQL データベースを初期化中: Installing MySQL system tables... | ||
| - | OK | ||
| - | Filling help tables... | ||
| - | OK | ||
| - | To start mysqld at boot time you have to copy | + | MySQL データベースを初期化中: Installing MySQL system tables...\\ |
| - | support-files/mysql.server to the right place for your system | + | OK\\ |
| + | Filling help tables...\\ | ||
| + | OK\\ | ||
| - | PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! | + | To start mysqld at boot time you have to copy\\ |
| - | To do so, start the server, then issue the following commands: | + | support-files/mysql.server to the right place for your system\\ |
| - | /usr/bin/mysqladmin -u root password 'new-password' | + | |
| - | /usr/bin/mysqladmin -u root -h fedora9.fedorasrv.com password 'new-password' | + | |
| - | Alternatively you can run: | + | PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !\\ |
| - | /usr/bin/mysql_secure_installation | + | To do so, start the server, then issue the following commands:\\ |
| + | /usr/bin/mysqladmin -u root password 'new-password'\\ | ||
| + | /usr/bin/mysqladmin -u root -h fedora9.fedorasrv.com password 'new-password'\\ | ||
| - | which will also give you the option of removing the test | + | Alternatively you can run:\\ |
| - | databases and anonymous user created by default. This is | + | /usr/bin/mysql_secure_installation\\ |
| - | strongly recommended for production servers. | + | |
| - | See the manual for more instructions. | + | which will also give you the option of removing the test\\ |
| + | databases and anonymous user created by default. This is\\ | ||
| + | strongly recommended for production servers.\\ | ||
| - | You can start the MySQL daemon with: | + | See the manual for more instructions.\\ |
| - | cd /usr ; /usr/bin/mysqld_safe & | + | |
| - | You can test the MySQL daemon with mysql-test-run.pl | + | You can start the MySQL daemon with:\\ |
| - | cd mysql-test ; perl mysql-test-run.pl | + | cd /usr ; /usr/bin/mysqld_safe &\\ |
| - | Please report any problems with the /usr/bin/mysqlbug script! | + | You can test the MySQL daemon with mysql-test-run.pl\\ |
| + | cd mysql-test ; perl mysql-test-run.pl\\ | ||
| + | |||
| + | Please report any problems with the /usr/bin/mysqlbug script!\\ | ||
| + | |||
| + | The latest information about MySQL is available on the web at\\ | ||
| + | http://www.mysql.com\\ | ||
| + | Support MySQL by buying support/licenses at http://shop.mysql.com\\ | ||
| + | [ OK ]\\ | ||
| + | MySQL を起動中: [ OK ]\\ | ||
| - | The latest information about MySQL is available on the web at | ||
| - | http://www.mysql.com | ||
| - | Support MySQL by buying support/licenses at http://shop.mysql.com | ||
| - | [ OK ] | ||
| - | MySQL を起動中: [ OK ] | ||
| - | </code> | ||
| * 自動起動するように設定しておく | * 自動起動するように設定しておく | ||
| 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!\\ | ||
| + | |||
