<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Chapter 5. Database Administration</title><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="prev" href="using-mysql-programs.html" title="Chapter 4. Using MySQL Programs"><link rel="next" href="replication.html" title="Chapter 6. Replication in MySQL">
</head><body><div class="chapter"><div class="titlepage"><div><div><h2 class="title"><a name="database-administration"></a>
第5章：数据库管理</h2></div></div></div><div class="toc"><p><b>目录</b></p><dl><dt><span class="section"><a href="database-administration.html#server-side-scripts">
5.1. MySQL服务器和服务器启动脚本</a></span></dt><dd><dl><dt><span class="section"><a href="database-administration.html#server-side-overview">
5.1.1. 服务器端脚本和实用工具概述</a></span></dt><dt><span class="section"><a href="database-administration.html#mysqld-max">
5.1.2. mysq<span><strong class="command">ld-max扩展My</strong></span>SQL服务器</a></span></dt><dt><span class="section"><a href="database-administration.html#mysqld-safe">
5.1.3. mysqld_safe：MySQL服务器启动脚本</a></span></dt><dt><span class="section"><a href="database-administration.html#mysql-server">
5.1.4. mysql.server：MySQL服务器启动脚本</a></span></dt><dt><span class="section"><a href="database-administration.html#mysqld-multi">
5.1.5. mysqld_multi：管理多个MySQL服务器的程序</a></span></dt></dl></dd><dt><span class="section"><a href="database-administration.html#instance-manager">
5.2. mysqlmanager：MySQL实例管理器</a></span></dt><dd><dl><dt><span class="section"><a href="database-administration.html#instance-manager-startup-process">
5.2.1. 用MySQL实例管理器启动MySQL服务器</a></span></dt><dt><span class="section"><a href="database-administration.html#instance-manager-security">
5.2.2. 连接到MySQL实例管理器并创建用户账户</a></span></dt><dt><span class="section"><a href="database-administration.html#instance-manager-command-line-options">
5.2.3. MySQL实例管理器命令行选项</a></span></dt><dt><span class="section"><a href="database-administration.html#instance-manager-configuration-files">
5.2.4. MySQL实例管理器配置文件</a></span></dt><dt><span class="section"><a href="database-administration.html#instance-manager-commands">
5.2.5. MySQL实例管理器识别的命令</a></span></dt></dl></dd><dt><span class="section"><a href="database-administration.html#mysqld">
5.3. mysqld：MySQL服务器</a></span></dt><dd><dl><dt><span class="section"><a href="database-administration.html#server-options">5.3.1. <span><strong class="command">
mysqld</strong></span>命令行选项</a></span></dt><dt><span class="section"><a href="database-administration.html#server-sql-mode">
5.3.2. SQL服务器模式</a></span></dt><dt><span class="section"><a href="database-administration.html#server-system-variables">
5.3.3. 服务器系统变量</a></span></dt><dt><span class="section"><a href="database-administration.html#server-status-variables">
5.3.4. 服务器状态变量</a></span></dt></dl></dd><dt><span class="section"><a href="database-administration.html#mysql-fix-privilege-tables">
5.4. mysql_fix_privilege_tables：升级MySQL系统表</a></span></dt><dt><span class="section"><a href="database-administration.html#server-shutdown">
5.5. MySQL服务器关机进程</a></span></dt><dt><span class="section"><a href="database-administration.html#security">
5.6. 一般安全问题</a></span></dt><dd><dl><dt><span class="section"><a href="database-administration.html#security-guidelines">
5.6.1. 通用安全指南</a></span></dt><dt><span class="section"><a href="database-administration.html#security-against-attack">
5.6.2. 使MySQL在攻击者面前保持安全</a></span></dt><dt><span class="section"><a href="database-administration.html#privileges-options">
5.6.3. Mysqld安全相关启动选项<span><strong class="command"></strong></span></a></span></dt><dt><span class="section"><a href="database-administration.html#load-data-local">
5.6.4. LOAD DATA LOCAL安全问题<code class="literal"></code></a></span></dt></dl></dd><dt><span class="section"><a href="database-administration.html#privilege-system">
5.7. MySQL访问权限系统</a></span></dt><dd><dl><dt><span class="section"><a href="database-administration.html#what-privileges">
5.7.1. 权限系统的作用</a></span></dt><dt><span class="section"><a href="database-administration.html#privileges">
5.7.2. 权限系统工作原理</a></span></dt><dt><span class="section"><a href="database-administration.html#privileges-provided">
5.7.3. MySQL提供的权限</a></span></dt><dt><span class="section"><a href="database-administration.html#connecting">
5.7.4. 与MySQL服务器连接</a></span></dt><dt><span class="section"><a href="database-administration.html#connection-access">
5.7.5. 访问控制, 阶段1：连接核实</a></span></dt><dt><span class="section"><a href="database-administration.html#request-access">
5.7.6. 访问控制, 阶段2：请求核实</a></span></dt><dt><span class="section"><a href="database-administration.html#privilege-changes">
5.7.7. 权限更改何时生效</a></span></dt><dt><span class="section"><a href="database-administration.html#access-denied">
5.7.8. 拒绝访问错误的原因<code class="literal"></code></a></span></dt><dt><span class="section"><a href="database-administration.html#password-hashing">
5.7.9. MySQL 4.1中的密码哈希处理</a></span></dt></dl></dd><dt><span class="section"><a href="database-administration.html#user-account-management">
5.8. MySQL用户账户管理</a></span></dt><dd><dl><dt><span class="section"><a href="database-administration.html#user-names">
5.8.1. MySQL用户名和密码</a></span></dt><dt><span class="section"><a href="database-administration.html#adding-users">
5.8.2. 向MySQL增加新用户账户</a></span></dt><dt><span class="section"><a href="database-administration.html#removing-users">
5.8.3. 从MySQL删除用户账户</a></span></dt><dt><span class="section"><a href="database-administration.html#user-resources">
5.8.4. 限制账户资源</a></span></dt><dt><span class="section"><a href="database-administration.html#passwords">
5.8.5. 设置账户密码</a></span></dt><dt><span class="section"><a href="database-administration.html#password-security">
5.8.6. 使你的密码安全</a></span></dt><dt><span class="section"><a href="database-administration.html#secure-connections">
5.8.7. 使用安全连接</a></span></dt></dl></dd><dt><span class="section"><a href="database-administration.html#disaster-prevention">
5.9. 备份与恢复</a></span></dt><dd><dl><dt><span class="section"><a href="database-administration.html#backup">
5.9.1. 数据库备份</a></span></dt><dt><span class="section"><a href="database-administration.html#backup-strategy-example">
5.9.2. 示例用备份与恢复策略</a></span></dt><dt><span class="section"><a href="database-administration.html#point-in-time-recovery">
5.9.3. 自动恢复</a></span></dt><dt><span class="section"><a href="database-administration.html#table-maintenance">
5.9.4. 表维护和崩溃恢复</a></span></dt><dt><span class="section"><a href="database-administration.html#myisamchk">
5.9.5. myisamchk：MyISAM表维护实用工具</a></span></dt><dt><span class="section"><a href="database-administration.html#maintenance-schedule">
5.9.6. 建立表维护计划</a></span></dt><dt><span class="section"><a href="database-administration.html#table-info">
5.9.7. 获取关于表的信息</a></span></dt></dl></dd><dt><span class="section"><a href="database-administration.html#localisation">
mysql-refman-5.1-zh.html-chapter.zip
需积分: 10 65 浏览量
2013-12-20
11:06:56
上传
评论
收藏 2.45MB ZIP 举报
refman-5.1-zh.html-chapter.zip （61个子文件） 
refman-5.1-zh.html-chapter 
limits.html 2KB sql-syntax.html 622KB triggers.html 24KB installing.html 558KB column-types.html 131KB stored-procedures.html 83KB error-handling.html 158KB spatial-extensions-in-mysql.html 128KB images 
custom-engine-overview.png 212KB cluster-components-1.png 73KB mydsn-options.png 15KB mydsn-icon.png 3KB blackhole-1.png 25KB multi-comp-1.png 42KB pluggable-storage-overview.png 86KB mydsn-test-fail.png 7KB mydsn-trace.png 110KB mydsn-example.png 15KB multi-comp-1-reduced.png 28KB myaccess.png 125KB myflowchart.png 27KB myaccess-odbc.png 18KB mydsn-test-success.png 7KB pluggable-storage-choosing.png 51KB mydll-properties.png 11KB myarchitecture.png 8KB mydsn-setup.png 15KB mydsn.png 105KB custom-engine.html 101KB restrictions.html 25KB replication.html 144KB apis.html 387KB preface.html 2KB functions.html 346KB gpl-license.html 18KB precision-math.html 36KB environment-variables.html 6KB database-administration.html 796KB index.html 115KB problems.html 155KB extending-mysql.html 59KB charset.html 129KB storage-engines.html 393KB tutorial.html 152KB language-structure.html 63KB credits.html 57KB views.html 26KB connectors.html 789KB ix01.html 259KB pluggable-storage.html 16KB introduction.html 164KB ndbcluster.html 338KB news.html 9KB client-side-scripts.html 211KB mysql-floss-license-exception.html 10KB optimization.html 349KB regexp.html 18KB partitioning.html 129KB porting.html 43KB information-schema.html 81KB using-mysql-programs.html 40KB资源评论
