無料PHPプログラム

MySQL 5.1 リファレンスマニュアル :: A Frequently Asked Questions About MySQL 5.1 :: A.10 MySQL 5.1 FAQ ? Security
« A.9 MySQL 5.1 FAQ ? Migration

A.11 MySQL 5.1 FAQ ? MySQL Cluster »
Section Navigation      [Toggle]
  • A Frequently Asked Questions About MySQL 5.1
  • A.1 MySQL 5.1 FAQ ? General
  • A.2 MySQL 5.1 FAQ ? Storage Engines
  • A.3 MySQL 5.1 FAQ ? Server SQL Mode
  • A.4 MySQL 5.1 FAQ ? Stored Procedures
  • A.5 MySQL 5.1 FAQ ? Triggers
  • A.6 MySQL 5.1 FAQ ? Stored Routines, Triggers, and Replication
  • A.7 MySQL 5.1 FAQ ? Views
  • A.8 MySQL 5.0 FAQ ? INFORMATION_SCHEMA
  • A.9 MySQL 5.1 FAQ ? Migration
  • A.10 MySQL 5.1 FAQ ? Security
  • A.11 MySQL 5.1 FAQ ? MySQL Cluster
  • A.12 MySQL 5.1 FAQ ? MySQL Chinese, Japanese, and Korean Character Sets
  • A.13 MySQL 5.1 FAQ ? Connectors & APIs

A.10. MySQL 5.1 FAQ ? Security

Questions

  • 26.10.1: Where can I find documentation that addresses security issues for MySQL?

  • 26.10.2: Does MySQL 5.1 have native support for SSL?

  • 26.10.3: Is SSL support be built into MySQL binaries, or must I recompile the binary myself to enable it?

  • 26.10.4: Does MySQL 5.1 have built-in authentication against LDAP directories?

  • 26.10.5: Does MySQL 5.1 include support for Roles Based Access Control (RBAC)?

Questions and Answers

26.10.1: Where can I find documentation that addresses security issues for MySQL?

The best place to start is 項4.6. 「セキュリティ問題」.

Other portions of the MySQL Documentation which you may find useful with regard to specific security concerns include the following:

  • 項4.6.1. 「セキュリティ ガイドライン」.

  • 項4.6.2. 「MySQL のクラッカー対策」.

  • 項B.1.4.1. 「How to Reset the Root Password」.

  • 項4.6.5. 「ユーザによる MySQL の実行」.

  • 項25.3.4.6. 「User-Defined Function Security Precautions」.

  • 項4.6.3. 「セキュリティ関連の mysqld オプション」.

  • 項4.6.4. 「LOAD DATA LOCAL のセキュリティ関連事項」.

  • 項2.10. 「インストール後の設定とテスト」.

  • 項2.13.1.11. 「SELinux の注釈」.

  • 項4.8.7.1. 「SSL の基本概念」.

26.10.2: Does MySQL 5.1 have native support for SSL?

Most 5.1 binaries have support for SSL connections between the client and server. We can't currently build with the new YaSSL library everywhere, as it's still quite new and does not compile on all platforms yet. See 項4.8.7. 「接続安全」.

You can also tunnel a connection via SSH, if (for instance) if the client application doesn't support SSL connections. For an example, see 項4.8.7.5. 「SSH で Windows からリモート接続」.

26.10.3: Is SSL support be built into MySQL binaries, or must I recompile the binary myself to enable it?

Most 5.1 binaries have SSL enabled for client-server connections that are secured, authenticated, or both. However, the YaSSL library currently does not compile on all platforms. See 項4.8.7. 「接続安全」, for a complete listing of supported and unsupported platforms.

26.10.4: Does MySQL 5.1 have built-in authentication against LDAP directories?

No. Support for external authentication methods is on the MySQL roadmap as a 「rolling feature」, which means that we plan to implement it in the future, but we have not yet determined when this will be done.

26.10.5: Does MySQL 5.1 include support for Roles Based Access Control (RBAC)?

No. Support for roles is on the MySQL roadmap as a 「rolling feature」, which means that we plan to implement it in the future, but we have not yet determined when this will be done.

Copyright c 1997, 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices
Top / Previous / Next / Up / Table of Contents
© 2010, Oracle Corporation and/or its affiliates

無料CGI PHPスクリプト | 新着情報スクリプト | 営業日カレンダー | PHPマニュアル | MySQLマニュアル | PEARマニュアル

Copyright (c) 2010 jmcodex.com All rights reserved.