<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">
<style>
<!--
span.GramE
{}
span.MsoHyperlink
{color:blue;
text-decoration:underline;
text-underline:single;}
table.MsoNormalTable
{mso-style-parent:"";
font-size:10.0pt;
font-family:"Times New Roman";
}
span.quote
{}
li.MsoNormal
{mso-style-parent:"";
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:宋体;
color:black; margin-left:0cm; margin-right:0cm; margin-top:0cm}
div.Section1
{page:Section1;}
-->
</style>
</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-administrati
tomcat
需积分: 0 168 浏览量
2008-04-09
11:21:46
上传
评论
收藏 1.32MB RAR 举报
07095514281.rar （38个子文件） 
mysql电子书 
26章.html 847KB 附录B.html 173KB 附录D.html 10KB 7章.html 719KB 16章.html 104KB 6章.html 236KB 4章.html 77KB 17章.html 374KB 附录I.html 31KB 13章.html 682KB 9章.html 122KB 附录F.html 6KB 3章.html 390KB 20章.html 96KB 附录E.html 44KB 附录J.html 20KB 21章.html 25KB 附录A.html 163KB 25章.html 399KB 附录K.html 11KB 23章.html 117KB 12章.html 531KB 27章.html 59KB 2章.html 936KB 14章.html 17KB 10章.html 219KB 18章.html 146KB 24章.html 37KB 19章.html 139KB 附录G.html 20KB 附录C.html 78KB 附录H.html 2KB 22章.html 29KB 8章.html 466KB 1章.html 185KB 11章.html 254KB 15章.html 548KB 5章.html 1.31MB
评论0