<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns="http://www.w3.org/TR/REC-html40" xml:lang="en">
<head>
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 11">
<meta name=Originator content="Microsoft Word 11">
<link rel=File-List href="application-password-use_archivos/filelist.xml">
<link rel=Edit-Time-Data href="application-password-use_archivos/editdata.mso">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<title> MySQL 3.23, 4.0, 4.1 Reference Manual :: 5.7.9.1 Implications of
Password Hashing Changes for Application Programs</title>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>ENTEL S.A.</o:Author>
<o:LastAuthor>ENTEL S.A.</o:LastAuthor>
<o:Revision>2</o:Revision>
<o:TotalTime>0</o:TotalTime>
<o:Created>2006-04-13T20:45:00Z</o:Created>
<o:LastSaved>2006-04-13T20:45:00Z</o:LastSaved>
<o:Pages>3</o:Pages>
<o:Words>916</o:Words>
<o:Characters>5041</o:Characters>
<o:Company>ENTEL S.A.</o:Company>
<o:Lines>42</o:Lines>
<o:Paragraphs>11</o:Paragraphs>
<o:CharactersWithSpaces>5946</o:CharactersWithSpaces>
<o:Version>11.6568</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:FormsDesign/>
<w:HyphenationZone>21</w:HyphenationZone>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]-->
<link rel=Stylesheet type="text/css" media=all
href="http://dev.mysql.com/doc/docs.css">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;
mso-font-charset:2;
mso-generic-font-family:auto;
mso-font-pitch:variable;
mso-font-signature:0 268435456 0 0 -2147483648 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0cm;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
h1
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
mso-outline-level:1;
font-size:24.0pt;
font-family:"Times New Roman";
font-weight:bold;}
h3
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
mso-outline-level:3;
font-size:13.5pt;
font-family:"Times New Roman";
font-weight:bold;}
h4
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
mso-pagination:widow-orphan;
mso-outline-level:4;
font-size:12.0pt;
font-family:"Times New Roman";
font-weight:bold;}
p
{font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
code
{mso-ansi-font-size:13.5pt;
mso-bidi-font-size:13.5pt;
mso-ascii-font-family:"Courier New";
mso-fareast-font-family:"Times New Roman";
mso-hansi-font-family:"Courier New";
mso-bidi-font-family:"Courier New";}
pre
{margin-top:0cm;
margin-bottom:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
mso-fareast-font-family:"Times New Roman";}
p.guibutton, li.guibutton, div.guibutton
{mso-style-name:guibutton;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
p.s, li.s, div.s
{mso-style-name:s;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 3.0cm 70.85pt 3.0cm;
mso-header-margin:35.4pt;
mso-footer-margin:35.4pt;
mso-paper-source:0;}
div.Section1
{page:Section1;}
/* List Definitions */
@list l0
{mso-list-id:401604757;
mso-list-template-ids:87349874;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1
{mso-list-id:878585672;
mso-list-template-ids:-2122912780;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l2
{mso-list-id:1015576249;
mso-list-template-ids:-1147890850;}
@list l2:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l3
{mso-list-id:1048650035;
mso-list-template-ids:-1466637786;}
@list l3:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l4
{mso-list-id:1516656436;
mso-list-template-ids:1572403290;}
@list l4:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l5
{mso-list-id:1918859320;
mso-list-template-ids:-2090593552;}
@list l5:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Tabla normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0cm 5.4pt 0cm 5.4pt;
mso-para-margin:0cm;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]-->
<link rel=stylesheet type="text/css" media=screen
href="http://dev.mysql.com/common/css/screen.css">
<link rel=stylesheet type="text/css" media=projection
href="http://dev.mysql.com/common/css/screen.css">
<link rel=stylesheet type="text/css" media=print
href="http://dev.mysql.com/common/css/print.css">
<link rel=contents href="http://dev.mysql.com/doc/refman/4.1/en/index.html"
title="MySQL Manual">
<link rel=start href="http://dev.mysql.com/doc/refman/4.1/en/index.html"
title="MySQL Manual">
<link rel=prev
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">
<link rel=next
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing-4-1-0.html?ff=nopfpls"
title="5.7.9.2 Password Hashing in MySQL 4.1.0">
<link rel=up href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">
<link rel="shortcut icon" href="http://dev.mysql.com/common/favicon.ico">
</head>
<body lang=ES link=blue vlink=blue style='tab-interval:35.4pt'>
<div class=Section1>
<div id=container>
<div id=header>
<div id=logo>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><a
href="http://www.mysql.com/"><span style='text-decoration:none;text-underline:
none'><img border=0 width=100 height=52 id="_x0000_i1025"
src="http://dev.mysql.com/common/logos/mysql_100x52-64.gif" alt=MySQL></span></a><o:p></o:p></span></p>
</div>
<div id=tag>
<p><span lang=EN style='mso-ansi-language:EN'>:: DEVELOPER ZONE<o:p></o:p></span></p>
</div>
<form action="http://www.mysql.com/search/" method=get
enctype="application/x-www-form-urlencoded" style='float:none'>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><INPUT TYPE="text" MAXLENGTH="255" SIZE="20" NAME="q"><span
style='display:none;mso-hide:all'><INPUT TYPE="hidden" NAME="charset" VALUE="utf-8"></span><INPUT TYPE="submit" ACTION="http://www.mysql.com/search/" VALUE="Search" METHOD="get"><o:p></o:p></span></p>
</form>
<div>
<p class=s><span lang=EN style='mso-ansi-language:EN'><a
href="http://www.mysql.com/login.php?dest=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F4.1%2Fen%2Fapplication-password-use.html">Login</a>
/ <a href="http://www.mysql.com/register.php">Register</a><o:p></o:p></span></p>
</div>
</div>
</div>
<div id=nav>
<div id=tabs>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l3 level1 lfo1;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://www.mysql.com/">MySQL.com</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l3 level1 lfo1;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/">Developer
Zone</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l3 level1 lfo1;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://solutions.mysql.com/">Partners</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l3 level1 lfo1;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="https://shop.mysql.com/">Online Shop</a><o:p></o:p></span></li>
</ul>
</div>
<div id=menu>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/downloads/">Downloads</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/doc/"><strong>Documentation</strong></a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://forums.mysql.com/">Forums</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://lists.mysql.com/">Lists</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://bugs.mysql.com/">Bugs</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://www.mysql.com/news-and-events/events/">Events</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/user-groups/">User
Groups</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/guilds/">Guilds</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://www.planetmysql.org/">Blogs</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/support/">Support</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/tech-resources/">Resources</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/books/">Books</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l1 level1 lfo2;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/tech-resources/faq.html">FAQ</a><o:p></o:p></span></li>
</ul>
</div>
<div id=subfld>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-outline-level:2'><b><span lang=EN style='font-size:10.0pt;mso-font-kerning:
18.0pt;mso-ansi-language:EN'>MySQL 3.23, 4.0, 4.1 Reference Manual :: 5
Database Administration :: 5.7 The MySQL Access Privilege System :: 5.7.9
Password Hashing as of MySQL 4.1 :: 5.7.9.1 Implications of Password Hashing
Changes for Application Programs<o:p></o:p></span></b></p>
</div>
<div id=submenu>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo3;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/doc/">Overview</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo3;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/5.0/en/">MySQL Reference Manual</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo3;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/4.1/en/"><strong>3.23, 4.0, 4.1</strong></a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo3;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/5.0/en/">5.0</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo3;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/5.1/en/">5.1</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l0 level1 lfo3;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://dev.mysql.com/doc/maxdb/">MaxDB
Documentation</a><o:p></o:p></span></li>
</ul>
</div>
<!--/UdmComment--><!--UdmComment-->
<div id=page>
<div>
<div>
<div>
<h3><span lang=EN style='mso-ansi-language:EN'>Search the MySQL manual:<o:p></o:p></span></h3>
<form action="/doc/mysql/search.php" method=get
enctype="application/x-www-form-urlencoded" id=docsearch>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><SELECT NAME="version">
<OPTION VALUE="site">the whole site
<OPTION SELECTED VALUE="4.1">Manual 3.23, 4.0, 4.1
<OPTION VALUE="5.0">Manual 5.0
<OPTION VALUE="5.1">Manual 5.1
</SELECT><INPUT TYPE="text" SIZE="10" NAME="q"
id=searchq><INPUT TYPE="submit" ACTION="/doc/mysql/search.php" VALUE="Go" METHOD="get"
id=searchsubmit><span style='display:none;mso-hide:all'><INPUT TYPE="hidden" NAME="from" VALUE="/doc/refman/4.1/en/application-password-use.html"></span><span
style='display:none;mso-hide:all'><INPUT TYPE="hidden" NAME="lang" VALUE="en"></span><o:p></o:p></span></p>
</form>
<div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN
style='mso-ansi-language:EN'>
<hr size=2 width="100%" align=center>
</span></div>
</div>
<div id=toc>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l5 level1 lfo4;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/4.1/en/index.html">MySQL 3.23, 4.0,
4.1 Reference Manual</a><o:p></o:p></span></li>
</ul>
<div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN
style='mso-ansi-language:EN'>
<hr size=2 width="100%" align=center>
</span></div>
</div>
<ul type=disc>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l2 level1 lfo5;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html">5.7.9
Password Hashing as of MySQL 4.1</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l2 level1 lfo5;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'>5.7.9.1 Implications of Password Hashing
Changes for Application Programs<o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l2 level1 lfo5;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing-4-1-0.html">5.7.9.2
Password Hashing in MySQL 4.1.0</a><o:p></o:p></span></li>
</ul>
<div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN
style='mso-ansi-language:EN'>
<hr size=2 width="100%" align=center>
</span></div>
</div>
<div id=promo>
<p><span lang=EN style='mso-ansi-language:EN'><a
href="http://www.mysqlpress.com/">Get the MySQL Language Reference and MySQL
Administrator's Guide from MySQL Press!</a><o:p></o:p></span></p>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN
style='mso-ansi-language:EN'>
<hr size=2 width="100%" align=center>
</span></div>
</div>
<div>
<div style='margin-left:3.75pt;margin-top:3.75pt;margin-right:3.75pt;
margin-bottom:3.75pt'>
<p class=MsoNormal style='line-height:120%;background:#FDEFB3'><b><span
lang=EN style='font-size:15.0pt;line-height:120%;color:#E87C00;mso-ansi-language:
EN'>Get Support with MySQL Network today!<o:p></o:p></span></b></p>
</div>
<div style='margin-left:3.75pt'>
<p style='margin-top:11.25pt;margin-right:0cm;margin-bottom:3.75pt;margin-left:
11.25pt;line-height:120%;background:#FDEFB3'><b><span lang=EN style='font-size:
9.0pt;line-height:120%;mso-ansi-language:EN'>Order from our online shop and get
technical support from MySQL engineers today.<o:p></o:p></span></b></p>
<p class=MsoNormal style='background:#FDEFB3'><span lang=EN style='mso-ansi-language:
EN'><o:p> </o:p></span></p>
<div style='margin-left:49.5pt'>
<p class=MsoNormal style='line-height:130%;background:#FF9423'><span lang=EN
style='font-size:13.5pt;line-height:130%;color:white;mso-ansi-language:EN'><a
href="https://shop.mysql.com/?rz=docs"><span style='color:white;text-decoration:
none;text-underline:none'>Get Support Now »</span></a> <o:p></o:p></span></p>
</div>
</div>
</div>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><o:p> </o:p></span></p>
<form action="http://www.mysql.com/register.php" method=post
enctype="application/x-www-form-urlencoded">
<p><span lang=EN style='mso-ansi-language:EN'>Learn about new MySQL releases,
technical articles, events and more.<br>
<br>
<b>Subscribe to the monthly MySQL Newsletter!</b><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><INPUT TYPE="text" NAME="email" VALUE="sakila@example.com"><span
style='display:none;mso-hide:all'><INPUT TYPE="hidden" NAME="newsletter" VALUE="html"></span><br>
<INPUT TYPE="submit" ACTION="http://www.mysql.com/register.php" VALUE="Subscribe" METHOD="post" NAME="submit"><o:p></o:p></span></p>
</form>
<div><!--/UdmComment-->
<div><!--UdmComment-->
<div id=docnav>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">Previous</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing-4-1-0.html?ff=nopfpls"
title="5.7.9.2 Password Hashing in MySQL 4.1.0">Next</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">Up</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/index.html">Table of Contents</a><o:p></o:p></span></p>
</div>
<!--/UdmComment-->
<div>
<div>
<div>
<div>
<h4><a name=application-password-use></a><span lang=EN style='mso-ansi-language:
EN'>5.7.9.1. Implications of Password Hashing Changes for Application
Programs<o:p></o:p></span></h4>
</div>
</div>
</div>
<p><span lang=EN style='mso-ansi-language:EN'>An upgrade to MySQL 4.1 can cause
a compatibility issue for applications that use </span><code><span lang=EN
style='font-size:13.5pt;mso-ansi-language:EN'>PASSWORD()</span></code><span
lang=EN style='mso-ansi-language:EN'> to generate passwords for their own
purposes. Applications really should not do this, because </span><code><span
lang=EN style='font-size:13.5pt;mso-ansi-language:EN'>PASSWORD()</span></code><span
lang=EN style='mso-ansi-language:EN'> should be used only to manage passwords
for MySQL accounts. But some applications use </span><code><span lang=EN
style='font-size:13.5pt;mso-ansi-language:EN'>PASSWORD()</span></code><span
lang=EN style='mso-ansi-language:EN'> for their own purposes anyway. <o:p></o:p></span></p>
<p><span lang=EN style='mso-ansi-language:EN'>If you upgrade to 4.1 and run the
server under conditions where it generates long password hashes, an application
that uses </span><code><span lang=EN style='font-size:13.5pt;mso-ansi-language:
EN'>PASSWORD()</span></code><span lang=EN style='mso-ansi-language:EN'> for its
own passwords breaks. The recommended course of action is to modify the
application to use another function, such as </span><code><span lang=EN
style='font-size:13.5pt;mso-ansi-language:EN'>SHA1()</span></code><span
lang=EN style='mso-ansi-language:EN'> or </span><code><span lang=EN
style='font-size:13.5pt;mso-ansi-language:EN'>MD5()</span></code><span lang=EN
style='mso-ansi-language:EN'>, to produce hashed values. If that is not
possible, you can use the </span><code><span lang=EN style='font-size:13.5pt;
mso-ansi-language:EN'>OLD_PASSWORD()</span></code><span lang=EN
style='mso-ansi-language:EN'> function, which is provided to generate short
hashes in the old format. But note that </span><code><span lang=EN
style='font-size:13.5pt;mso-ansi-language:EN'>OLD_PASSWORD()</span></code><span
lang=EN style='mso-ansi-language:EN'> may one day no longer be supported. <o:p></o:p></span></p>
<p><span lang=EN style='mso-ansi-language:EN'>If the server is running under
circumstances where it generates short hashes, </span><code><span lang=EN
style='font-size:13.5pt;mso-ansi-language:EN'>OLD_PASSWORD()</span></code><span
lang=EN style='mso-ansi-language:EN'> is available but is equivalent to </span><code><span
lang=EN style='font-size:13.5pt;mso-ansi-language:EN'>PASSWORD()</span></code><span
lang=EN style='mso-ansi-language:EN'>. <o:p></o:p></span></p>
<p><span lang=EN style='mso-ansi-language:EN'>PHP programmers migrating their
MySQL databases from version 4.0 or lower to version 4.1 or higher should see <a
href="http://dev.mysql.com/doc/refman/4.1/en/php.html"
title="17.3. MySQL PHP API">Section 17.3, “MySQL PHP API”</a>. <o:p></o:p></span></p>
</div>
<!--UdmComment-->
<div id=docnav>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">Previous</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing-4-1-0.html?ff=nopfpls"
title="5.7.9.2 Password Hashing in MySQL 4.1.0">Next</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">Up</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/index.html">Table of Contents</a><o:p></o:p></span></p>
</div>
<!--/UdmComment-->
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><o:p></o:p></span></p>
<!--UdmComment-->
<div id=comments>
<h2><span lang=EN style='mso-ansi-language:EN'>User Comments<o:p></o:p></span></h2>
<p><span lang=EN style='mso-ansi-language:EN'><a
href="http://dev.mysql.com/doc/mysql/comment.php?sect=application-password-use">Add
your own comment.</a><o:p></o:p></span></p>
</div>
<!--UdmComment-->
<div id=docnav>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><span
style='mso-field-code:" HYPERLINK \0022\0022 "'><span class=MsoHyperlink>Top</span></span>
/ <a href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">Previous</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing-4-1-0.html?ff=nopfpls"
title="5.7.9.2 Password Hashing in MySQL 4.1.0">Next</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/password-hashing.html"
title="5.7.9 Password Hashing as of MySQL 4.1">Up</a> / <a
href="http://dev.mysql.com/doc/refman/4.1/en/index.html">Table of Contents</a><o:p></o:p></span></p>
</div>
</div>
</div>
</div>
<!--/UdmComment-->
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><br
style='mso-special-character:line-break'>
<![if !supportLineBreakNewLine]><br style='mso-special-character:line-break'>
<![endif]><o:p></o:p></span></p>
<!--UdmComment-->
<div id=footer>
<p><span lang=EN style='mso-ansi-language:EN'>© 1995-2006 MySQL AB. All rights
reserved.<o:p></o:p></span></p>
<ul type=disc style='background-position-x:100%;background-position-y:0%'>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://www.mysql.com/company/">About
MySQL</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://www.mysql.com/company/jobs/">Careers</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://www.mysql.com/sitemap.html">Site
Map</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://www.mysql.com/company/contact/">Contact Us</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://www.mysql.com/company/legal/website.html">Legal</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://www.mysql.com/company/legal/privacy.html">Privacy Policy</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a
href="http://www.mysql.com/company/legal/trademark.html">Trademark Info</a><o:p></o:p></span></li>
<li class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;
mso-list:l4 level1 lfo6;tab-stops:list 36.0pt'><span lang=EN
style='mso-ansi-language:EN'><a href="http://www.NoSoftwarePatents.com/"><span
style='text-decoration:none;text-underline:none'><img border=0 width=80
height=15 id="_x0000_i1041"
src="http://dev.mysql.com/common/img/nswpat80x15.gif"
alt="No Software Patents!"></span></a><o:p></o:p></span></li>
</ul>
</div>
<p class=MsoNormal><span lang=EN style='mso-ansi-language:EN'><o:p> </o:p></span></p>
</div>
</div>
</div>
</div>
<!--/UdmComment--></div>
</div>
</body>
</html>