<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手册.zip
共61个文件
html:41个
png:20个
需积分: 10 69 下载量 5 浏览量
2007-11-08
15:33:57
上传
评论
收藏 2.45MB ZIP 举报
温馨提示
mysql手册中文版.
资源推荐
资源详情
资源评论
收起资源包目录
mysql手册.zip (61个子文件)
refman-5.1-zh.html-chapter
column-types.html 131KB
information-schema.html 81KB
installing.html 559KB
triggers.html 24KB
gpl-license.html 18KB
problems.html 155KB
database-administration.html 796KB
limits.html 2KB
stored-procedures.html 83KB
ndbcluster.html 338KB
partitioning.html 129KB
regexp.html 18KB
extending-mysql.html 59KB
pluggable-storage.html 16KB
views.html 26KB
client-side-scripts.html 211KB
sql-syntax.html 622KB
optimization.html 351KB
charset.html 129KB
spatial-extensions-in-mysql.html 128KB
restrictions.html 25KB
mysql-floss-license-exception.html 10KB
storage-engines.html 393KB
language-structure.html 63KB
ix01.html 259KB
functions.html 346KB
connectors.html 790KB
custom-engine.html 101KB
news.html 9KB
using-mysql-programs.html 40KB
images
cluster-components-1.png 73KB
myaccess.png 125KB
mydsn-icon.png 3KB
mydll-properties.png 11KB
custom-engine-overview.png 212KB
mydsn-test-fail.png 7KB
multi-comp-1-reduced.png 28KB
myflowchart.png 27KB
pluggable-storage-overview.png 86KB
mydsn.png 105KB
multi-comp-1.png 42KB
mydsn-test-success.png 7KB
myarchitecture.png 8KB
mydsn-example.png 15KB
mydsn-setup.png 15KB
myaccess-odbc.png 18KB
mydsn-trace.png 110KB
pluggable-storage-choosing.png 51KB
mydsn-options.png 15KB
blackhole-1.png 25KB
porting.html 44KB
introduction.html 165KB
tutorial.html 152KB
index.html 109KB
precision-math.html 36KB
credits.html 58KB
preface.html 2KB
replication.html 144KB
error-handling.html 158KB
environment-variables.html 6KB
apis.html 388KB
共 61 条
- 1
资源评论
laowang2
- 粉丝: 163
- 资源: 36
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功