Author: mcbrown
Date: 2008-09-08 12:15:11 +0200 (Mon, 08 Sep 2008)
New Revision: 11720
Log:
Adding the topic guide structure
Adding the security topic guide
New security FAQ DynDocs
Added:
trunk/dynamic-docs/faq/mysql-security.xml
trunk/topic-guides/Makefile
trunk/topic-guides/topics-5.0/Makefile
trunk/topic-guides/topics-5.0/Makefile.depends
trunk/topic-guides/topics-5.0/all-entities.ent
trunk/topic-guides/topics-5.0/mysql-security-aspec.xml
trunk/topic-guides/topics-5.0/mysql-security-base.xml
trunk/topic-guides/topics-5.0/mysql-security-faq-core.xml
trunk/topic-guides/topics-5.1/Makefile
trunk/topic-guides/topics-5.1/Makefile.depends
trunk/topic-guides/topics-5.1/all-entities.ent
trunk/topic-guides/topics-5.1/mysql-security-aspec.xml
trunk/topic-guides/topics-5.1/mysql-security-base.xml
trunk/topic-guides/topics-5.1/mysql-security-faq-core.xml
trunk/topic-guides/topics-6.0/Makefile
trunk/topic-guides/topics-6.0/Makefile.depends
trunk/topic-guides/topics-6.0/all-entities.ent
trunk/topic-guides/topics-6.0/mysql-security-aspec.xml
trunk/topic-guides/topics-6.0/mysql-security-base.xml
trunk/topic-guides/topics-6.0/mysql-security-faq-core.xml
Added: trunk/dynamic-docs/faq/mysql-security.xml
===================================================================
--- trunk/dynamic-docs/faq/mysql-security.xml (rev 0)
+++ trunk/dynamic-docs/faq/mysql-security.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 225, Lines Deleted: 0; 5760 bytes
@@ -0,0 +1,225 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE faq SYSTEM "faq.dtd">
+<faq>
+
+ <faqentry>
+
+ <versions>
+ <manual version="5.0"></manual>
+ <manual version="5.1"></manual>
+ <manual version="6.0"></manual>
+ </versions>
+ <faqquestion>
+
+ <para>
+ Where can I find documentation that addresses security issues
+ for MySQL?
+ </para>
+
+ </faqquestion>
+ <faqanswer>
+
+ <para>
+ The best place to start is <xref linkend="security"/>.
+ </para>
+ <remark role="todo">
+ [js] Add descriptive blurbs to the following links.
+ </remark>
+ <para>
+ Other portions of the MySQL Documentation which you may find
+ useful with regard to specific security concerns include the
+ following:
+ <itemizedlist>
+
+ <listitem>
+ <para>
+ <xref linkend="security-guidelines"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="security-against-attack"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="resetting-permissions"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="changing-mysql-user"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="udf-security"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="privileges-options"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="load-data-local"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="post-installation"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="selinux"/>.
+ </para>
+ </listitem>
+
+ <listitem>
+ <para>
+ <xref linkend="secure-basics"/>.
+ </para>
+ </listitem>
+
+ </itemizedlist>
+ </para>
+ <formalpara role="mnmas">
+
+ <title>MySQL Enterprise</title>
+ <para>
+ The MySQL Enterprise Monitor enforces best practices for
+ maximizing the security of your servers. For more information
+ see <ulink url="&base-url-enterprise;advisors.html"/>.
+ </para>
+
+ </formalpara>
+
+ </faqanswer>
+
+ </faqentry>
+ <faqentry>
+
+ <versions>
+ <manual version="5.0"></manual>
+ <manual version="5.1"></manual>
+ <manual version="6.0"></manual>
+ </versions>
+ <faqquestion>
+
+ <para>
+ Does MySQL ¤t-series; have native support for SSL?
+ </para>
+
+ </faqquestion>
+ <faqanswer>
+
+ <para>
+ Most ¤t-series; 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
+ <xref linkend="secure-connections"/>.
+ </para>
+ <para>
+ You can also tunnel a connection via SSH, if (for instance) if
+ the client application doesn't support SSL connections. For an
+ example, see <xref linkend="windows-and-ssh"/>.
+ </para>
+
+ </faqanswer>
+
+ </faqentry>
+ <faqentry>
+
+ <versions>
+ <manual version="5.0"></manual>
+ <manual version="5.1"></manual>
+ <manual version="6.0"></manual>
+ </versions>
+ <faqquestion>
+
+ <para>
+ Is SSL support be built into MySQL binaries, or must I recompile
+ the binary myself to enable it?
+ </para>
+
+ </faqquestion>
+ <faqanswer>
+
+ <para>
+ Most ¤t-series; 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 <xref linkend="secure-connections"/>, for a
+ complete listing of supported and unsupported platforms.
+ </para>
+
+ </faqanswer>
+
+ </faqentry>
+ <faqentry>
+
+ <versions>
+ <manual version="5.0"></manual>
+ <manual version="5.1"></manual>
+ <manual version="6.0"></manual>
+ </versions>
+ <faqquestion>
+
+ <para>
+ Does MySQL ¤t-series; have built-in authentication against
+ LDAP directories?
+ </para>
+
+ </faqquestion>
+ <faqanswer>
+
+ <para>
+ No. Support for external authentication methods is on the MySQL
+ roadmap as a <quote>rolling feature</quote>, which means that we
+ plan to implement it in the future, but we have not yet
+ determined when this will be done.
+ </para>
+
+ </faqanswer>
+
+ </faqentry>
+ <faqentry>
+
+ <versions>
+ <manual version="5.0"></manual>
+ <manual version="5.1"></manual>
+ <manual version="6.0"></manual>
+ </versions>
+ <faqquestion>
+
+ <para>
+ Does MySQL ¤t-series; include support for Roles Based
+ Access Control (RBAC)?
+ </para>
+
+ </faqquestion>
+ <faqanswer>
+
+ <para>
+ No. Support for roles is on the MySQL roadmap as a
+ <quote>rolling feature</quote>, which means that we plan to
+ implement it in the future, but we have not yet determined when
+ this will be done.
+ </para>
+
+ </faqanswer>
+
+ </faqentry>
+
+</faq>
Added: trunk/topic-guides/Makefile
===================================================================
--- trunk/topic-guides/Makefile (rev 0)
+++ trunk/topic-guides/Makefile 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 22, Lines Deleted: 0; 778 bytes
@@ -0,0 +1,22 @@
+# mysqldoc repository
+
+# topic-guides Makefile
+
+# Location of repository root relative to current directory
+REPO_ROOT = ..
+
+# Location of directory containing Makefile components
+MAKE_DIR = $(REPO_ROOT)/make.d
+
+SUBDIRS = \
+ topics-5.0 \
+ topics-5.1 \
+ topics-6.0
+
+all:
+ @echo "Documents maintained in this directory generally each"
+ @echo "have their own directory. To work on a document"
+ @echo "(for example, to edit it or to generate output),"
+ @echo "cd into the document directory first."
+
+include $(MAKE_DIR)/global-targets
Added: trunk/topic-guides/topics-5.0/Makefile
===================================================================
--- trunk/topic-guides/topics-5.0/Makefile (rev 0)
+++ trunk/topic-guides/topics-5.0/Makefile 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 90, Lines Deleted: 0; 2623 bytes
@@ -0,0 +1,90 @@
+# Makefile for MySQL Reference Manual
+
+# Location of repository root relative to current directory
+REPO_ROOT = ../..
+
+# Location of directory containing Makefile components
+MAKE_DIR = $(REPO_ROOT)/make.d
+
+# Set any variables here that should override imported standard variables
+
+DOC_LANG = en
+MAIN_DOC_BASENAME = mysql-security
+
+DOC_URL_BASE = http://dev.mysql.com/doc/mysqld-version-reference/$(DOC_LANG)/
+
+# Set IDMAP and remap variables
+
+IDMAP_LANG = $(DOC_LANG)
+IDMAP_MAIN = topic-guides
+
+IDMAP_URLBASE = $(IDMAP_MAIN)/$(IDMAP_LANG)
+IDMAP_REFS = . $(REPO_ROOT)/refman-5.0 \
+ $(REPO_ROOT)/refman-common \
+ $(REPO_ROOT)/ndbapi
+IDMAP_SRCS = $(call base_xml_files)
+
+# Import standard variables
+
+include $(MAKE_DIR)/vars-layout
+include $(MAKE_DIR)/vars-shell
+include $(MAKE_DIR)/vars-docbook
+
+# Import default target rule (causes help message to print)
+
+include $(MAKE_DIR)/default-target
+
+# Disable TOC for all docs in this directory
+
+GENERATE_TOC = --stringparam generate.toc "book nop,chapter nop"
+
+# Document dependency specifications
+# "make depend" updates the _SRCS variable
+# Set _SRCS_EXTRA variable by hand to any entity files needed
+
+DEPEND_FILES = mysql-security-5.0-excerpt.xml
+
+mysql-security-5.0-excerpt.xml: mysql-security-arbitrary.xml
+ cp $< $@
+
+clean::
+ $(RM) $(DEPEND_FILES)
+
+# Import document dependency specifications
+
+include Makefile.depends
+
+# Import standard target rules
+
+# Need xml-html-dir for formatting the manual itself into a subdir,
+# but also need xml-html for formatting ReadMe.html
+
+include $(MAKE_DIR)/xml-dynxml
+include $(MAKE_DIR)/xml-valid
+include $(MAKE_DIR)/xml-format
+include $(MAKE_DIR)/xml-useless
+include $(MAKE_DIR)/xml-prep
+include $(MAKE_DIR)/xml-html
+include $(MAKE_DIR)/xml-html-dir
+include $(MAKE_DIR)/xml-html-section
+include $(MAKE_DIR)/xml-html-chapter
+include $(MAKE_DIR)/xml-html-web
+include $(MAKE_DIR)/xml-eclipse
+include $(MAKE_DIR)/xml-chm
+include $(MAKE_DIR)/xml-xhtml-dir
+include $(MAKE_DIR)/xml-pdf
+include $(MAKE_DIR)/xml-toc
+include $(MAKE_DIR)/xml-txt
+include $(MAKE_DIR)/xml-info
+include $(MAKE_DIR)/xml-man
+include $(MAKE_DIR)/xml-help
+include $(MAKE_DIR)/xml-remark
+include $(MAKE_DIR)/xml-titles
+include $(MAKE_DIR)/xml-depend
+include $(MAKE_DIR)/xml-listing
+include $(MAKE_DIR)/xml-arbitrary
+
+
+# Import directory specific extensions
+
+include $(MAKE_DIR)/Makefile.ext
Added: trunk/topic-guides/topics-5.0/Makefile.depends
===================================================================
--- trunk/topic-guides/topics-5.0/Makefile.depends (rev 0)
+++ trunk/topic-guides/topics-5.0/Makefile.depends 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 103, Lines Deleted: 0; 7508 bytes
@@ -0,0 +1,103 @@
+dynxml_local_mysql_security_faq_INCLUDES = \
+ ../../common/fixedchars.ent \
+ ../../common/phrases.ent \
+ ../../dynamic-docs/faq/mysql-security.xml \
+ ../../refman-5.0/versions.ent \
+ ../../refman-common/urls.ent \
+ all-entities.ent \
+ mysql-security-faq-core.xml
+dynxml_local_mysql_security_faq_IMAGES =
+dynxml_local_mysql_security_faq_SOURCES = dynxml-local-mysql-security-faq.xml $(dynxml_local_mysql_security_faq_INCLUDES)
+dynxml_local_mysql_security_faq_IDMAPS = \
+ ../../refman-5.0/metadata/dba-core.idmap \
+ ../../refman-5.0/metadata/errors-problems.idmap \
+ ../../refman-5.0/metadata/extending-mysql.idmap \
+ ../../refman-5.0/metadata/installing-cs-core.idmap
+dynxml-local-mysql-security-faq.validpure: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.titles: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.useless: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.valid: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq.validwarn: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-prepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-manprepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-remprepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq.xml: $(dynxml_local_mysql_security_faq_INCLUDES)
+mysql_security_5_0_excerpt_INCLUDES = \
+ ../../common/fixedchars.ent \
+ ../../common/phrases.ent \
+ ../../dynamic-docs/faq/mysql-security.xml \
+ ../../refman-5.0/backup.xml \
+ ../../refman-5.0/dba-core.xml \
+ ../../refman-5.0/installing-cs-core.xml \
+ ../../refman-5.0/legalnotice.en.xml \
+ ../../refman-5.0/versions.ent \
+ ../../refman-common/urls.ent \
+ all-entities.ent \
+ dynxml-local-mysql-security-faq.xml \
+ mysql-security-aspec.xml.backup-and-recovery.none.section.xml \
+ mysql-security-aspec.xml.post-installation.none.section.xml \
+ mysql-security-aspec.xml.privilege-system.none.section.xml \
+ mysql-security-aspec.xml.security.none.section.xml \
+ mysql-security-aspec.xml.user-account-management.none.section.xml \
+ mysql-security-faq-core.xml
+mysql_security_5_0_excerpt_IMAGES =
+mysql_security_5_0_excerpt_SOURCES = mysql-security-5.0-excerpt.xml $(mysql_security_5_0_excerpt_INCLUDES)
+mysql_security_5_0_excerpt_IDMAPS = \
+ ../../refman-5.0/metadata/apis-c.idmap \
+ ../../refman-5.0/metadata/backup.idmap \
+ ../../refman-5.0/metadata/dba-core.idmap \
+ ../../refman-5.0/metadata/errors-problems.idmap \
+ ../../refman-5.0/metadata/extending-mysql.idmap \
+ ../../refman-5.0/metadata/faqs.idmap \
+ ../../refman-5.0/metadata/functions-core.idmap \
+ ../../refman-5.0/metadata/installing-cs-core.idmap \
+ ../../refman-5.0/metadata/internationalization.idmap \
+ ../../refman-5.0/metadata/mysql-cluster-backup.idmap \
+ ../../refman-5.0/metadata/mysql-cluster-configuration.idmap \
+ ../../refman-5.0/metadata/mysql-cluster.idmap \
+ ../../refman-5.0/metadata/optimization.idmap \
+ ../../refman-5.0/metadata/programs-admin-util-core.idmap \
+ ../../refman-5.0/metadata/programs-client-core.idmap \
+ ../../refman-5.0/metadata/programs-installation.idmap \
+ ../../refman-5.0/metadata/programs-server-core.idmap \
+ ../../refman-5.0/metadata/programs-using.idmap \
+ ../../refman-5.0/metadata/programs.idmap \
+ ../../refman-5.0/metadata/replication-configuration.idmap \
+ ../../refman-5.0/metadata/replication.idmap \
+ ../../refman-5.0/metadata/se-bdb-core.idmap \
+ ../../refman-5.0/metadata/se-innodb-core.idmap \
+ ../../refman-5.0/metadata/se-myisam-core.idmap \
+ ../../refman-5.0/metadata/sql-syntax-data-manipulation.idmap \
+ ../../refman-5.0/metadata/sql-syntax-replication.idmap \
+ ../../refman-5.0/metadata/sql-syntax-server-administration.idmap \
+ ../../refman-5.0/metadata/sql-syntax-transactions.idmap \
+ ../../refman-5.0/metadata/sql-syntax.idmap \
+ ../../refman-5.0/metadata/stored-procedures.idmap \
+ ../../refman-common/metadata/apis-php.idmap \
+ ../../refman-common/metadata/bug-reports.idmap
+mysql-security-5.0-excerpt.validpure: $(mysql_security_5_0_excerpt_SOURCES)
+mysql-security-5.0-excerpt.titles: $(mysql_security_5_0_excerpt_SOURCES)
+mysql-security-5.0-excerpt.useless: $(mysql_security_5_0_excerpt_SOURCES)
+mysql-security-5.0-excerpt.valid: $(mysql_security_5_0_excerpt_SOURCES) $(mysql_security_5_0_excerpt_IDMAPS)
+mysql-security-5.0-excerpt.validwarn: $(mysql_security_5_0_excerpt_SOURCES) $(mysql_security_5_0_excerpt_IDMAPS)
+mysql-security-5.0-excerpt-prepped.xml: $(mysql_security_5_0_excerpt_SOURCES) $(mysql_security_5_0_excerpt_IDMAPS)
+mysql-security-5.0-excerpt-manprepped.xml: $(mysql_security_5_0_excerpt_SOURCES) $(mysql_security_5_0_excerpt_IDMAPS)
+mysql-security-5.0-excerpt-remprepped.xml: $(mysql_security_5_0_excerpt_SOURCES) $(mysql_security_5_0_excerpt_IDMAPS)
+
+mysql_security_faq_core_INCLUDES =
+mysql_security_faq_core_IMAGES =
+mysql_security_faq_core_SOURCES = mysql-security-faq-core.xml $(mysql_security_faq_core_INCLUDES)
+mysql_security_faq_core_IDMAPS =
+mysql-security-faq-core.validpure: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.titles: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.useless: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.valid: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core.validwarn: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-prepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-manprepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-remprepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+
+mysql-security-aspec.xml.backup-and-recovery.none.section.xml mysql-security-aspec.xml.post-installation.none.section.xml mysql-security-aspec.xml.privilege-system.none.section.xml mysql-security-aspec.xml.security.none.section.xml mysql-security-aspec.xml.user-account-management.none.section.xml: ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.0/backup.xml ../../refman-5.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.0/installing-cs-core.xml ../../refman-5.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.0/dba-core.xml ../../refman-5.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.0/dba-core.xml ../../refman-5.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phra!
ses.ent ../../refman-5.0/dba-core.xml ../../refman-5.0/versions.ent ../../refman-common/urls.ent all-entities.ent
+ $(RM) mysql-security.xml mysql-security-arbitrary.xml
+ $(MAKE) mysql-security.xml
+
Added: trunk/topic-guides/topics-5.0/all-entities.ent
===================================================================
--- trunk/topic-guides/topics-5.0/all-entities.ent (rev 0)
+++ trunk/topic-guides/topics-5.0/all-entities.ent 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 0; 889 bytes
@@ -0,0 +1,14 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+ This file names all the entity files needed by .xml files in the
+ current directory. All ENTITY declarations should be given
+ first, followed by references to the those entities.
+-->
+<!ENTITY % fixedchars.entities SYSTEM "../../common/fixedchars.ent">
+<!ENTITY % urls.entities SYSTEM "../../refman-common/urls.ent">
+<!ENTITY % phrases.entities SYSTEM "../../common/phrases.ent">
+<!ENTITY % versions.entities SYSTEM "../../refman-5.0/versions.ent">
+%fixedchars.entities;
+%urls.entities;
+%phrases.entities;
+%versions.entities;
Added: trunk/topic-guides/topics-5.0/mysql-security-aspec.xml
===================================================================
--- trunk/topic-guides/topics-5.0/mysql-security-aspec.xml (rev 0)
+++ trunk/topic-guides/topics-5.0/mysql-security-aspec.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 792 bytes
@@ -0,0 +1,11 @@
+<?xml version="1.0" encoding="utf-8"?>
+<book>
+<fragment id="mysql-security-imports">
+
+<include prefix="refman-5.0" src="security" markas="section"/>
+<include prefix="refman-5.0" src="post-installation" markas="section"/>
+<include prefix="refman-5.0" src="privilege-system" markas="section"/>
+<include prefix="refman-5.0" src="user-account-management" markas="section"/>
+<include prefix="refman-5.0" src="backup-and-recovery" markas="section"/>
+</fragment>
+</book>
Added: trunk/topic-guides/topics-5.0/mysql-security-base.xml
===================================================================
--- trunk/topic-guides/topics-5.0/mysql-security-base.xml (rev 0)
+++ trunk/topic-guides/topics-5.0/mysql-security-base.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 62, Lines Deleted: 0; 2982 bytes
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % all.entities SYSTEM "all-entities.ent">
+ %all.entities;
+]>
+<book id="mysql-security-excerpt" lang="en">
+
+
+<title>Security in MySQL</title>
+
+ <title>MySQL 5.0 Reference Manual</title>
+
+ <bookinfo>
+
+ <abstract>
+
+ <para>
+ This is the MySQL Security Guide extract from the MySQL ¤t-series; Reference Manual.
+ </para>
+
+ <para>
+ Document generated on:
+
+<?dbtimestamp format="Y-m-d"?>
+
+ <remark role="repository.revision"/>
+ </para>
+
+ </abstract>
+
+ <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="../../refman-5.0/legalnotice.en.xml"/>
+
+ </bookinfo>
+
+<preface>
+
+ <para>When thinking about security within MySQL you should consider a wide range of possible topics and how they might affect the security of your MySQL server and related applications. </para>
+
+<para>All of the following are issues that you should be aware of:</para>
+
+<itemizedlist>
+ <listitem><para>Security of the installation itself. The data files, log files, and the all the application files of your installation should be protected to ensure that they are not readable or writable by unauthorized parties. For more information, see <xref linkend="post-installation"/>.</para></listitem>
+
+<listitem><para>Access control and security within the database system itself, including the users and databases granted with access to the databases, views and stored programs in use within the database. For more information, see <xref linkend="privilege-system"/>, <xref linkend="user-account-management"/>.</para></listitem>
+
+<listitem><para>Network security of MySQL and your system. The security is related to the grants for individual users, but you may also wish to restrict MySQL so that is only available locally, or to a limited set of hosts.</para></listitem>
+
+<listitem><para>Security of your application to ensure that SQL injections and other corruption of the data does not occur. See <xref linkend="security"/>.</para></listitem>
+
+<listitem><para>Ensure that you have adequate and appropriate backups of your database files, configuration and log files. Also be sure that you have a recovery solution in place and test that you are able to successfully recover the information from your backups. See <xref linkend="backup-and-recovery"/>.</para></listitem>
+
+</itemizedlist>
+
+</preface>
+
+<!--SRCFILE mysql-security-imports-->
+
+<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="dynxml-local-mysql-security-faq.xml"/>
+
+</book>
Added: trunk/topic-guides/topics-5.0/mysql-security-faq-core.xml
===================================================================
--- trunk/topic-guides/topics-5.0/mysql-security-faq-core.xml (rev 0)
+++ trunk/topic-guides/topics-5.0/mysql-security-faq-core.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 784 bytes
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE section PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % all.entities SYSTEM "all-entities.ent">
+ %all.entities;
+]>
+<section id="topic-mysql-security-faq">
+<title>Frequently Asked Questions about Security</title>
+<remark role="dynamic-dependency-list"/>
+<para condition="dynamic:faq" role="5.0:mysql-security:all"/>
+</section>
Added: trunk/topic-guides/topics-5.1/Makefile
===================================================================
--- trunk/topic-guides/topics-5.1/Makefile (rev 0)
+++ trunk/topic-guides/topics-5.1/Makefile 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 90, Lines Deleted: 0; 2623 bytes
@@ -0,0 +1,90 @@
+# Makefile for MySQL Reference Manual
+
+# Location of repository root relative to current directory
+REPO_ROOT = ../..
+
+# Location of directory containing Makefile components
+MAKE_DIR = $(REPO_ROOT)/make.d
+
+# Set any variables here that should override imported standard variables
+
+DOC_LANG = en
+MAIN_DOC_BASENAME = mysql-security
+
+DOC_URL_BASE = http://dev.mysql.com/doc/mysqld-version-reference/$(DOC_LANG)/
+
+# Set IDMAP and remap variables
+
+IDMAP_LANG = $(DOC_LANG)
+IDMAP_MAIN = topic-guides
+
+IDMAP_URLBASE = $(IDMAP_MAIN)/$(IDMAP_LANG)
+IDMAP_REFS = . $(REPO_ROOT)/refman-5.1 \
+ $(REPO_ROOT)/refman-common \
+ $(REPO_ROOT)/ndbapi
+IDMAP_SRCS = $(call base_xml_files)
+
+# Import standard variables
+
+include $(MAKE_DIR)/vars-layout
+include $(MAKE_DIR)/vars-shell
+include $(MAKE_DIR)/vars-docbook
+
+# Import default target rule (causes help message to print)
+
+include $(MAKE_DIR)/default-target
+
+# Disable TOC for all docs in this directory
+
+GENERATE_TOC = --stringparam generate.toc "book nop,chapter nop"
+
+# Document dependency specifications
+# "make depend" updates the _SRCS variable
+# Set _SRCS_EXTRA variable by hand to any entity files needed
+
+DEPEND_FILES = mysql-security-5.1-excerpt.xml
+
+mysql-security-5.1-excerpt.xml: mysql-security-arbitrary.xml
+ cp $< $@
+
+clean::
+ $(RM) $(DEPEND_FILES)
+
+# Import document dependency specifications
+
+include Makefile.depends
+
+# Import standard target rules
+
+# Need xml-html-dir for formatting the manual itself into a subdir,
+# but also need xml-html for formatting ReadMe.html
+
+include $(MAKE_DIR)/xml-dynxml
+include $(MAKE_DIR)/xml-valid
+include $(MAKE_DIR)/xml-format
+include $(MAKE_DIR)/xml-useless
+include $(MAKE_DIR)/xml-prep
+include $(MAKE_DIR)/xml-html
+include $(MAKE_DIR)/xml-html-dir
+include $(MAKE_DIR)/xml-html-section
+include $(MAKE_DIR)/xml-html-chapter
+include $(MAKE_DIR)/xml-html-web
+include $(MAKE_DIR)/xml-eclipse
+include $(MAKE_DIR)/xml-chm
+include $(MAKE_DIR)/xml-xhtml-dir
+include $(MAKE_DIR)/xml-pdf
+include $(MAKE_DIR)/xml-toc
+include $(MAKE_DIR)/xml-txt
+include $(MAKE_DIR)/xml-info
+include $(MAKE_DIR)/xml-man
+include $(MAKE_DIR)/xml-help
+include $(MAKE_DIR)/xml-remark
+include $(MAKE_DIR)/xml-titles
+include $(MAKE_DIR)/xml-depend
+include $(MAKE_DIR)/xml-listing
+include $(MAKE_DIR)/xml-arbitrary
+
+
+# Import directory specific extensions
+
+include $(MAKE_DIR)/Makefile.ext
Added: trunk/topic-guides/topics-5.1/Makefile.depends
===================================================================
--- trunk/topic-guides/topics-5.1/Makefile.depends (rev 0)
+++ trunk/topic-guides/topics-5.1/Makefile.depends 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 103, Lines Deleted: 0; 7499 bytes
@@ -0,0 +1,103 @@
+dynxml_local_mysql_security_faq_INCLUDES = \
+ ../../common/fixedchars.ent \
+ ../../common/phrases.ent \
+ ../../dynamic-docs/faq/mysql-security.xml \
+ ../../refman-5.1/versions.ent \
+ ../../refman-common/urls.ent \
+ all-entities.ent \
+ mysql-security-faq-core.xml
+dynxml_local_mysql_security_faq_IMAGES =
+dynxml_local_mysql_security_faq_SOURCES = dynxml-local-mysql-security-faq.xml $(dynxml_local_mysql_security_faq_INCLUDES)
+dynxml_local_mysql_security_faq_IDMAPS = \
+ ../../refman-5.1/metadata/dba-core.idmap \
+ ../../refman-5.1/metadata/errors-problems-core.idmap \
+ ../../refman-5.1/metadata/extending-mysql.idmap \
+ ../../refman-5.1/metadata/installing-core.idmap
+dynxml-local-mysql-security-faq.validpure: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.titles: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.useless: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.valid: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq.validwarn: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-prepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-manprepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-remprepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq.xml: $(dynxml_local_mysql_security_faq_INCLUDES)
+mysql_security_5_1_excerpt_INCLUDES = \
+ ../../common/fixedchars.ent \
+ ../../common/phrases.ent \
+ ../../dynamic-docs/faq/mysql-security.xml \
+ ../../refman-5.1/backup.xml \
+ ../../refman-5.1/dba-core.xml \
+ ../../refman-5.1/installing-core.xml \
+ ../../refman-5.1/legalnotice.en.xml \
+ ../../refman-5.1/versions.ent \
+ ../../refman-common/urls.ent \
+ all-entities.ent \
+ dynxml-local-mysql-security-faq.xml \
+ mysql-security-aspec.xml.backup-and-recovery.none.section.xml \
+ mysql-security-aspec.xml.post-installation.none.section.xml \
+ mysql-security-aspec.xml.privilege-system.none.section.xml \
+ mysql-security-aspec.xml.security.none.section.xml \
+ mysql-security-aspec.xml.user-account-management.none.section.xml \
+ mysql-security-faq-core.xml
+mysql_security_5_1_excerpt_IMAGES =
+mysql_security_5_1_excerpt_SOURCES = mysql-security-5.1-excerpt.xml $(mysql_security_5_1_excerpt_INCLUDES)
+mysql_security_5_1_excerpt_IDMAPS = \
+ ../../refman-5.1/metadata/apis-c.idmap \
+ ../../refman-5.1/metadata/backup.idmap \
+ ../../refman-5.1/metadata/dba-core.idmap \
+ ../../refman-5.1/metadata/errors-problems-core.idmap \
+ ../../refman-5.1/metadata/extending-mysql.idmap \
+ ../../refman-5.1/metadata/faqs.idmap \
+ ../../refman-5.1/metadata/functions-core.idmap \
+ ../../refman-5.1/metadata/installing-core.idmap \
+ ../../refman-5.1/metadata/internationalization.idmap \
+ ../../refman-5.1/metadata/mysql-cluster-backup.idmap \
+ ../../refman-5.1/metadata/mysql-cluster-configuration.idmap \
+ ../../refman-5.1/metadata/mysql-cluster.idmap \
+ ../../refman-5.1/metadata/optimization.idmap \
+ ../../refman-5.1/metadata/programs-admin-util-core.idmap \
+ ../../refman-5.1/metadata/programs-client-core.idmap \
+ ../../refman-5.1/metadata/programs-installation.idmap \
+ ../../refman-5.1/metadata/programs-server-core.idmap \
+ ../../refman-5.1/metadata/programs-using.idmap \
+ ../../refman-5.1/metadata/programs.idmap \
+ ../../refman-5.1/metadata/replication-configuration.idmap \
+ ../../refman-5.1/metadata/replication.idmap \
+ ../../refman-5.1/metadata/se-innodb-core.idmap \
+ ../../refman-5.1/metadata/se-myisam-core.idmap \
+ ../../refman-5.1/metadata/sql-syntax-data-manipulation.idmap \
+ ../../refman-5.1/metadata/sql-syntax-replication.idmap \
+ ../../refman-5.1/metadata/sql-syntax-server-administration.idmap \
+ ../../refman-5.1/metadata/sql-syntax-transactions.idmap \
+ ../../refman-5.1/metadata/sql-syntax.idmap \
+ ../../refman-5.1/metadata/stored-procedures.idmap \
+ ../../refman-common/metadata/apis-php.idmap \
+ ../../refman-common/metadata/bug-reports.idmap \
+ ../../refman-common/metadata/ha.idmap
+mysql-security-5.1-excerpt.validpure: $(mysql_security_5_1_excerpt_SOURCES)
+mysql-security-5.1-excerpt.titles: $(mysql_security_5_1_excerpt_SOURCES)
+mysql-security-5.1-excerpt.useless: $(mysql_security_5_1_excerpt_SOURCES)
+mysql-security-5.1-excerpt.valid: $(mysql_security_5_1_excerpt_SOURCES) $(mysql_security_5_1_excerpt_IDMAPS)
+mysql-security-5.1-excerpt.validwarn: $(mysql_security_5_1_excerpt_SOURCES) $(mysql_security_5_1_excerpt_IDMAPS)
+mysql-security-5.1-excerpt-prepped.xml: $(mysql_security_5_1_excerpt_SOURCES) $(mysql_security_5_1_excerpt_IDMAPS)
+mysql-security-5.1-excerpt-manprepped.xml: $(mysql_security_5_1_excerpt_SOURCES) $(mysql_security_5_1_excerpt_IDMAPS)
+mysql-security-5.1-excerpt-remprepped.xml: $(mysql_security_5_1_excerpt_SOURCES) $(mysql_security_5_1_excerpt_IDMAPS)
+
+mysql_security_faq_core_INCLUDES =
+mysql_security_faq_core_IMAGES =
+mysql_security_faq_core_SOURCES = mysql-security-faq-core.xml $(mysql_security_faq_core_INCLUDES)
+mysql_security_faq_core_IDMAPS =
+mysql-security-faq-core.validpure: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.titles: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.useless: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.valid: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core.validwarn: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-prepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-manprepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-remprepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+
+mysql-security-aspec.xml.backup-and-recovery.none.section.xml mysql-security-aspec.xml.post-installation.none.section.xml mysql-security-aspec.xml.privilege-system.none.section.xml mysql-security-aspec.xml.security.none.section.xml mysql-security-aspec.xml.user-account-management.none.section.xml: ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.1/backup.xml ../../refman-5.1/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.1/installing-core.xml ../../refman-5.1/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.1/dba-core.xml ../../refman-5.1/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-5.1/dba-core.xml ../../refman-5.1/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases!
.ent ../../refman-5.1/dba-core.xml ../../refman-5.1/versions.ent ../../refman-common/urls.ent all-entities.ent
+ $(RM) mysql-security.xml mysql-security-arbitrary.xml
+ $(MAKE) mysql-security.xml
+
Added: trunk/topic-guides/topics-5.1/all-entities.ent
===================================================================
--- trunk/topic-guides/topics-5.1/all-entities.ent (rev 0)
+++ trunk/topic-guides/topics-5.1/all-entities.ent 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 0; 889 bytes
@@ -0,0 +1,14 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+ This file names all the entity files needed by .xml files in the
+ current directory. All ENTITY declarations should be given
+ first, followed by references to the those entities.
+-->
+<!ENTITY % fixedchars.entities SYSTEM "../../common/fixedchars.ent">
+<!ENTITY % urls.entities SYSTEM "../../refman-common/urls.ent">
+<!ENTITY % phrases.entities SYSTEM "../../common/phrases.ent">
+<!ENTITY % versions.entities SYSTEM "../../refman-5.1/versions.ent">
+%fixedchars.entities;
+%urls.entities;
+%phrases.entities;
+%versions.entities;
Added: trunk/topic-guides/topics-5.1/mysql-security-aspec.xml
===================================================================
--- trunk/topic-guides/topics-5.1/mysql-security-aspec.xml (rev 0)
+++ trunk/topic-guides/topics-5.1/mysql-security-aspec.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 792 bytes
@@ -0,0 +1,11 @@
+<?xml version="1.0" encoding="utf-8"?>
+<book>
+<fragment id="mysql-security-imports">
+
+<include prefix="refman-5.1" src="security" markas="section"/>
+<include prefix="refman-5.1" src="post-installation" markas="section"/>
+<include prefix="refman-5.1" src="privilege-system" markas="section"/>
+<include prefix="refman-5.1" src="user-account-management" markas="section"/>
+<include prefix="refman-5.1" src="backup-and-recovery" markas="section"/>
+</fragment>
+</book>
Added: trunk/topic-guides/topics-5.1/mysql-security-base.xml
===================================================================
--- trunk/topic-guides/topics-5.1/mysql-security-base.xml (rev 0)
+++ trunk/topic-guides/topics-5.1/mysql-security-base.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 62, Lines Deleted: 0; 2982 bytes
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % all.entities SYSTEM "all-entities.ent">
+ %all.entities;
+]>
+<book id="mysql-security-excerpt" lang="en">
+
+
+<title>Security in MySQL</title>
+
+ <title>MySQL 5.1 Reference Manual</title>
+
+ <bookinfo>
+
+ <abstract>
+
+ <para>
+ This is the MySQL Security Guide extract from the MySQL ¤t-series; Reference Manual.
+ </para>
+
+ <para>
+ Document generated on:
+
+<?dbtimestamp format="Y-m-d"?>
+
+ <remark role="repository.revision"/>
+ </para>
+
+ </abstract>
+
+ <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="../../refman-5.1/legalnotice.en.xml"/>
+
+ </bookinfo>
+
+<preface>
+
+ <para>When thinking about security within MySQL you should consider a wide range of possible topics and how they might affect the security of your MySQL server and related applications. </para>
+
+<para>All of the following are issues that you should be aware of:</para>
+
+<itemizedlist>
+ <listitem><para>Security of the installation itself. The data files, log files, and the all the application files of your installation should be protected to ensure that they are not readable or writable by unauthorized parties. For more information, see <xref linkend="post-installation"/>.</para></listitem>
+
+<listitem><para>Access control and security within the database system itself, including the users and databases granted with access to the databases, views and stored programs in use within the database. For more information, see <xref linkend="privilege-system"/>, <xref linkend="user-account-management"/>.</para></listitem>
+
+<listitem><para>Network security of MySQL and your system. The security is related to the grants for individual users, but you may also wish to restrict MySQL so that is only available locally, or to a limited set of hosts.</para></listitem>
+
+<listitem><para>Security of your application to ensure that SQL injections and other corruption of the data does not occur. See <xref linkend="security"/>.</para></listitem>
+
+<listitem><para>Ensure that you have adequate and appropriate backups of your database files, configuration and log files. Also be sure that you have a recovery solution in place and test that you are able to successfully recover the information from your backups. See <xref linkend="backup-and-recovery"/>.</para></listitem>
+
+</itemizedlist>
+
+</preface>
+
+<!--SRCFILE mysql-security-imports-->
+
+<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="dynxml-local-mysql-security-faq.xml"/>
+
+</book>
Added: trunk/topic-guides/topics-5.1/mysql-security-faq-core.xml
===================================================================
--- trunk/topic-guides/topics-5.1/mysql-security-faq-core.xml (rev 0)
+++ trunk/topic-guides/topics-5.1/mysql-security-faq-core.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 784 bytes
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE section PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % all.entities SYSTEM "all-entities.ent">
+ %all.entities;
+]>
+<section id="topic-mysql-security-faq">
+<title>Frequently Asked Questions about Security</title>
+<remark role="dynamic-dependency-list"/>
+<para condition="dynamic:faq" role="5.1:mysql-security:all"/>
+</section>
Added: trunk/topic-guides/topics-6.0/Makefile
===================================================================
--- trunk/topic-guides/topics-6.0/Makefile (rev 0)
+++ trunk/topic-guides/topics-6.0/Makefile 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 91, Lines Deleted: 0; 2651 bytes
@@ -0,0 +1,91 @@
+# Makefile for MySQL Reference Manual
+
+# Location of repository root relative to current directory
+REPO_ROOT = ../..
+
+# Location of directory containing Makefile components
+MAKE_DIR = $(REPO_ROOT)/make.d
+
+# Set any variables here that should override imported standard variables
+
+DOC_LANG = en
+MAIN_DOC_BASENAME = mysql-security
+
+DOC_URL_BASE = http://dev.mysql.com/doc/mysqld-version-reference/$(DOC_LANG)/
+
+# Set IDMAP and remap variables
+
+IDMAP_LANG = $(DOC_LANG)
+IDMAP_MAIN = topic-guides
+
+IDMAP_URLBASE = $(IDMAP_MAIN)/$(IDMAP_LANG)
+IDMAP_REFS = . $(REPO_ROOT)/refman-6.0 \
+ $(REPO_ROOT)/refman-common \
+ $(REPO_ROOT)/refman-5.1 \
+ $(REPO_ROOT)/ndbapi
+IDMAP_SRCS = $(call base_xml_files)
+
+# Import standard variables
+
+include $(MAKE_DIR)/vars-layout
+include $(MAKE_DIR)/vars-shell
+include $(MAKE_DIR)/vars-docbook
+
+# Import default target rule (causes help message to print)
+
+include $(MAKE_DIR)/default-target
+
+# Disable TOC for all docs in this directory
+
+GENERATE_TOC = --stringparam generate.toc "book nop,chapter nop"
+
+# Document dependency specifications
+# "make depend" updates the _SRCS variable
+# Set _SRCS_EXTRA variable by hand to any entity files needed
+
+DEPEND_FILES = mysql-security-6.0-excerpt.xml
+
+mysql-security-6.0-excerpt.xml: mysql-security-arbitrary.xml
+ cp $< $@
+
+clean::
+ $(RM) $(DEPEND_FILES)
+
+# Import document dependency specifications
+
+include Makefile.depends
+
+# Import standard target rules
+
+# Need xml-html-dir for formatting the manual itself into a subdir,
+# but also need xml-html for formatting ReadMe.html
+
+include $(MAKE_DIR)/xml-dynxml
+include $(MAKE_DIR)/xml-valid
+include $(MAKE_DIR)/xml-format
+include $(MAKE_DIR)/xml-useless
+include $(MAKE_DIR)/xml-prep
+include $(MAKE_DIR)/xml-html
+include $(MAKE_DIR)/xml-html-dir
+include $(MAKE_DIR)/xml-html-section
+include $(MAKE_DIR)/xml-html-chapter
+include $(MAKE_DIR)/xml-html-web
+include $(MAKE_DIR)/xml-eclipse
+include $(MAKE_DIR)/xml-chm
+include $(MAKE_DIR)/xml-xhtml-dir
+include $(MAKE_DIR)/xml-pdf
+include $(MAKE_DIR)/xml-toc
+include $(MAKE_DIR)/xml-txt
+include $(MAKE_DIR)/xml-info
+include $(MAKE_DIR)/xml-man
+include $(MAKE_DIR)/xml-help
+include $(MAKE_DIR)/xml-remark
+include $(MAKE_DIR)/xml-titles
+include $(MAKE_DIR)/xml-depend
+include $(MAKE_DIR)/xml-listing
+include $(MAKE_DIR)/xml-arbitrary
+
+
+# Import directory specific extensions
+
+include $(MAKE_DIR)/Makefile.ext
Added: trunk/topic-guides/topics-6.0/Makefile.depends
===================================================================
--- trunk/topic-guides/topics-6.0/Makefile.depends (rev 0)
+++ trunk/topic-guides/topics-6.0/Makefile.depends 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 103, Lines Deleted: 0; 7473 bytes
@@ -0,0 +1,103 @@
+dynxml_local_mysql_security_faq_INCLUDES = \
+ ../../common/fixedchars.ent \
+ ../../common/phrases.ent \
+ ../../dynamic-docs/faq/mysql-security.xml \
+ ../../refman-6.0/versions.ent \
+ ../../refman-common/urls.ent \
+ all-entities.ent \
+ mysql-security-faq-core.xml
+dynxml_local_mysql_security_faq_IMAGES =
+dynxml_local_mysql_security_faq_SOURCES = dynxml-local-mysql-security-faq.xml $(dynxml_local_mysql_security_faq_INCLUDES)
+dynxml_local_mysql_security_faq_IDMAPS = \
+ ../../refman-6.0/metadata/dba-core.idmap \
+ ../../refman-6.0/metadata/errors-problems.idmap \
+ ../../refman-6.0/metadata/extending-mysql.idmap \
+ ../../refman-6.0/metadata/installing-core.idmap
+dynxml-local-mysql-security-faq.validpure: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.titles: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.useless: $(dynxml_local_mysql_security_faq_SOURCES)
+dynxml-local-mysql-security-faq.valid: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq.validwarn: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-prepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-manprepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq-remprepped.xml: $(dynxml_local_mysql_security_faq_SOURCES) $(dynxml_local_mysql_security_faq_IDMAPS)
+dynxml-local-mysql-security-faq.xml: $(dynxml_local_mysql_security_faq_INCLUDES)
+mysql_security_6_0_excerpt_INCLUDES = \
+ ../../common/fixedchars.ent \
+ ../../common/phrases.ent \
+ ../../dynamic-docs/faq/mysql-security.xml \
+ ../../refman-6.0/backup.xml \
+ ../../refman-6.0/dba-core.xml \
+ ../../refman-6.0/installing-core.xml \
+ ../../refman-6.0/legalnotice.en.xml \
+ ../../refman-6.0/versions.ent \
+ ../../refman-common/urls.ent \
+ all-entities.ent \
+ dynxml-local-mysql-security-faq.xml \
+ mysql-security-aspec.xml.backup-and-recovery.none.section.xml \
+ mysql-security-aspec.xml.post-installation.none.section.xml \
+ mysql-security-aspec.xml.privilege-system.none.section.xml \
+ mysql-security-aspec.xml.security.none.section.xml \
+ mysql-security-aspec.xml.user-account-management.none.section.xml \
+ mysql-security-faq-core.xml
+mysql_security_6_0_excerpt_IMAGES =
+mysql_security_6_0_excerpt_SOURCES = mysql-security-6.0-excerpt.xml $(mysql_security_6_0_excerpt_INCLUDES)
+mysql_security_6_0_excerpt_IDMAPS = \
+ ../../refman-6.0/metadata/apis-c.idmap \
+ ../../refman-6.0/metadata/backup.idmap \
+ ../../refman-6.0/metadata/dba-core.idmap \
+ ../../refman-6.0/metadata/errors-problems.idmap \
+ ../../refman-6.0/metadata/extending-mysql.idmap \
+ ../../refman-6.0/metadata/faqs.idmap \
+ ../../refman-6.0/metadata/functions-core.idmap \
+ ../../refman-6.0/metadata/installing-core.idmap \
+ ../../refman-6.0/metadata/internationalization.idmap \
+ ../../refman-6.0/metadata/optimization.idmap \
+ ../../refman-6.0/metadata/programs-admin-util-core.idmap \
+ ../../refman-6.0/metadata/programs-client-core.idmap \
+ ../../refman-6.0/metadata/programs-installation.idmap \
+ ../../refman-6.0/metadata/programs-server-core.idmap \
+ ../../refman-6.0/metadata/programs-using.idmap \
+ ../../refman-6.0/metadata/programs.idmap \
+ ../../refman-6.0/metadata/replication.idmap \
+ ../../refman-6.0/metadata/restrictions.idmap \
+ ../../refman-6.0/metadata/se-innodb-core.idmap \
+ ../../refman-6.0/metadata/se-myisam-core.idmap \
+ ../../refman-6.0/metadata/sql-syntax-data-manipulation.idmap \
+ ../../refman-6.0/metadata/sql-syntax-replication.idmap \
+ ../../refman-6.0/metadata/sql-syntax-server-administration.idmap \
+ ../../refman-6.0/metadata/sql-syntax-transactions.idmap \
+ ../../refman-6.0/metadata/sql-syntax.idmap \
+ ../../refman-6.0/metadata/stored-procedures.idmap \
+ ../../refman-5.1/metadata/mysql-cluster-backup.idmap \
+ ../../refman-5.1/metadata/mysql-cluster-configuration.idmap \
+ ../../refman-5.1/metadata/mysql-cluster.idmap \
+ ../../refman-common/metadata/apis-php.idmap \
+ ../../refman-common/metadata/bug-reports.idmap \
+ ../../refman-common/metadata/ha.idmap
+mysql-security-6.0-excerpt.validpure: $(mysql_security_6_0_excerpt_SOURCES)
+mysql-security-6.0-excerpt.titles: $(mysql_security_6_0_excerpt_SOURCES)
+mysql-security-6.0-excerpt.useless: $(mysql_security_6_0_excerpt_SOURCES)
+mysql-security-6.0-excerpt.valid: $(mysql_security_6_0_excerpt_SOURCES) $(mysql_security_6_0_excerpt_IDMAPS)
+mysql-security-6.0-excerpt.validwarn: $(mysql_security_6_0_excerpt_SOURCES) $(mysql_security_6_0_excerpt_IDMAPS)
+mysql-security-6.0-excerpt-prepped.xml: $(mysql_security_6_0_excerpt_SOURCES) $(mysql_security_6_0_excerpt_IDMAPS)
+mysql-security-6.0-excerpt-manprepped.xml: $(mysql_security_6_0_excerpt_SOURCES) $(mysql_security_6_0_excerpt_IDMAPS)
+mysql-security-6.0-excerpt-remprepped.xml: $(mysql_security_6_0_excerpt_SOURCES) $(mysql_security_6_0_excerpt_IDMAPS)
+
+mysql_security_faq_core_INCLUDES =
+mysql_security_faq_core_IMAGES =
+mysql_security_faq_core_SOURCES = mysql-security-faq-core.xml $(mysql_security_faq_core_INCLUDES)
+mysql_security_faq_core_IDMAPS =
+mysql-security-faq-core.validpure: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.titles: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.useless: $(mysql_security_faq_core_SOURCES)
+mysql-security-faq-core.valid: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core.validwarn: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-prepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-manprepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+mysql-security-faq-core-remprepped.xml: $(mysql_security_faq_core_SOURCES) $(mysql_security_faq_core_IDMAPS)
+
+mysql-security-aspec.xml.backup-and-recovery.none.section.xml mysql-security-aspec.xml.post-installation.none.section.xml mysql-security-aspec.xml.privilege-system.none.section.xml mysql-security-aspec.xml.security.none.section.xml mysql-security-aspec.xml.user-account-management.none.section.xml: ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-6.0/backup.xml ../../refman-6.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-6.0/installing-core.xml ../../refman-6.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-6.0/dba-core.xml ../../refman-6.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases.ent ../../refman-6.0/dba-core.xml ../../refman-6.0/versions.ent ../../refman-common/urls.ent all-entities.ent ../../common/fixedchars.ent ../../common/phrases!
.ent ../../refman-6.0/dba-core.xml ../../refman-6.0/versions.ent ../../refman-common/urls.ent all-entities.ent
+ $(RM) mysql-security.xml mysql-security-arbitrary.xml
+ $(MAKE) mysql-security.xml
+
Added: trunk/topic-guides/topics-6.0/all-entities.ent
===================================================================
--- trunk/topic-guides/topics-6.0/all-entities.ent (rev 0)
+++ trunk/topic-guides/topics-6.0/all-entities.ent 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 14, Lines Deleted: 0; 889 bytes
@@ -0,0 +1,14 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+ This file names all the entity files needed by .xml files in the
+ current directory. All ENTITY declarations should be given
+ first, followed by references to the those entities.
+-->
+<!ENTITY % fixedchars.entities SYSTEM "../../common/fixedchars.ent">
+<!ENTITY % urls.entities SYSTEM "../../refman-common/urls.ent">
+<!ENTITY % phrases.entities SYSTEM "../../common/phrases.ent">
+<!ENTITY % versions.entities SYSTEM "../../refman-6.0/versions.ent">
+%fixedchars.entities;
+%urls.entities;
+%phrases.entities;
+%versions.entities;
Added: trunk/topic-guides/topics-6.0/mysql-security-aspec.xml
===================================================================
--- trunk/topic-guides/topics-6.0/mysql-security-aspec.xml (rev 0)
+++ trunk/topic-guides/topics-6.0/mysql-security-aspec.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 11, Lines Deleted: 0; 792 bytes
@@ -0,0 +1,11 @@
+<?xml version="1.0" encoding="utf-8"?>
+<book>
+<fragment id="mysql-security-imports">
+
+<include prefix="refman-6.0" src="security" markas="section"/>
+<include prefix="refman-6.0" src="post-installation" markas="section"/>
+<include prefix="refman-6.0" src="privilege-system" markas="section"/>
+<include prefix="refman-6.0" src="user-account-management" markas="section"/>
+<include prefix="refman-6.0" src="backup-and-recovery" markas="section"/>
+</fragment>
+</book>
Added: trunk/topic-guides/topics-6.0/mysql-security-base.xml
===================================================================
--- trunk/topic-guides/topics-6.0/mysql-security-base.xml (rev 0)
+++ trunk/topic-guides/topics-6.0/mysql-security-base.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 62, Lines Deleted: 0; 2982 bytes
@@ -0,0 +1,62 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE book PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % all.entities SYSTEM "all-entities.ent">
+ %all.entities;
+]>
+<book id="mysql-security-excerpt" lang="en">
+
+
+<title>Security in MySQL</title>
+
+ <title>MySQL 6.0 Reference Manual</title>
+
+ <bookinfo>
+
+ <abstract>
+
+ <para>
+ This is the MySQL Security Guide extract from the MySQL ¤t-series; Reference Manual.
+ </para>
+
+ <para>
+ Document generated on:
+
+<?dbtimestamp format="Y-m-d"?>
+
+ <remark role="repository.revision"/>
+ </para>
+
+ </abstract>
+
+ <xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="../../refman-6.0/legalnotice.en.xml"/>
+
+ </bookinfo>
+
+<preface>
+
+ <para>When thinking about security within MySQL you should consider a wide range of possible topics and how they might affect the security of your MySQL server and related applications. </para>
+
+<para>All of the following are issues that you should be aware of:</para>
+
+<itemizedlist>
+ <listitem><para>Security of the installation itself. The data files, log files, and the all the application files of your installation should be protected to ensure that they are not readable or writable by unauthorized parties. For more information, see <xref linkend="post-installation"/>.</para></listitem>
+
+<listitem><para>Access control and security within the database system itself, including the users and databases granted with access to the databases, views and stored programs in use within the database. For more information, see <xref linkend="privilege-system"/>, <xref linkend="user-account-management"/>.</para></listitem>
+
+<listitem><para>Network security of MySQL and your system. The security is related to the grants for individual users, but you may also wish to restrict MySQL so that is only available locally, or to a limited set of hosts.</para></listitem>
+
+<listitem><para>Security of your application to ensure that SQL injections and other corruption of the data does not occur. See <xref linkend="security"/>.</para></listitem>
+
+<listitem><para>Ensure that you have adequate and appropriate backups of your database files, configuration and log files. Also be sure that you have a recovery solution in place and test that you are able to successfully recover the information from your backups. See <xref linkend="backup-and-recovery"/>.</para></listitem>
+
+</itemizedlist>
+
+</preface>
+
+<!--SRCFILE mysql-security-imports-->
+
+<xi:include xmlns:xi="http://www.w3.org/2001/XInclude" href="dynxml-local-mysql-security-faq.xml"/>
+
+</book>
Added: trunk/topic-guides/topics-6.0/mysql-security-faq-core.xml
===================================================================
--- trunk/topic-guides/topics-6.0/mysql-security-faq-core.xml (rev 0)
+++ trunk/topic-guides/topics-6.0/mysql-security-faq-core.xml 2008-09-08 10:15:11 UTC (rev 11720)
Changed blocks: 1, Lines Added: 12, Lines Deleted: 0; 784 bytes
@@ -0,0 +1,12 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<!DOCTYPE section PUBLIC "-//OASIS//DTD DocBook XML V4.3//EN"
+"http://www.oasis-open.org/docbook/xml/4.3/docbookx.dtd"
+[
+ <!ENTITY % all.entities SYSTEM "all-entities.ent">
+ %all.entities;
+]>
+<section id="topic-mysql-security-faq">
+<title>Frequently Asked Questions about Security</title>
+<remark role="dynamic-dependency-list"/>
+<para condition="dynamic:faq" role="6.0:mysql-security:all"/>
+</section>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r11720 - in trunk: . dynamic-docs/faq topic-guides topic-guides/topics-5.0 topic-guides/topics-5.1 topic-guides/topics-... | martin.brown | 8 Sep |
