<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link rel="home" title="HomePage" href="HomePage.html" />
<link rel="help" title="HowToUseWiki" href="HowToUseWiki.html" />
<link rel="copyright" title="GNU General Public License" href="http://www.gnu.org/copyleft/gpl.html#SEC1" />
<link rel="author" title="The PhpWiki Programming Team" href="http://phpwiki.org/ThePhpWikiProgrammingTeam" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Language" content="en" />
<meta name="robots" content="noindex,nofollow" />
<meta name="language" content="en" />
<meta name="document-type" content="Public" />
<meta name="document-rating" content="General" />
<meta name="generator" content="PhpWiki" />
<meta name="PHPWIKI_VERSION" content="1.3.14" />

<link rel="stylesheet" type="text/css" charset="iso-8859-1" href="phpwiki-printer.css" />
<title>PhpWiki - Upgrading MySQL to 4.0.x for SME Server Feedback</title>
</head>
<body>

<div id="header">
  
<!-- Page title -->
<h1>Upgrading MySQL to 4.0.x for SME Server Feedback</h1>
</div>
<div id="content">



<div class="wikitext"><p class="tightenable top bottom">Give your comments on <a href="Upgrading%20MySQL%20to%204.0.x%20for%20SME%20Server.html" class="wiki">Upgrading MySQL to 4.0.x for SME Server</a> here. Thanks in advance!
<br /></p>
<hr />
<p class="tightenable">I just wasted a day trying to get MySQL to work on the network, gave up, UPGRADED to 4.0 and seem to have fixed the problems!</p>
<p class="tightenable">Follow the instructions , there is one bug,</p>
<p class="tightenable">rpm -e --nodeps mysql</p>
<p class="tightenable">seems to be needed!</p>
<p class="tightenable">Apart from that, great</p>
<p class="tightenable">thx</p>
<p class="tightenable">mike</p>
<hr />
<p class="tightenable">PS just did an upgrade on a clean SME6.0.1 machine, did not need the rpm -e mysql, however in step 1, I had to stop mysqld, (note the 'd') ,  mysql was not found!</p>
<p class="tightenable">I gave  it a try: worked like a charm.
I did not use  &quot;rpm -e --nodeps mysql&quot; neither.</p>
<p class="tightenable bottom">I even tried  MySQL-Max :</p>
<pre class="tightenable top">
# rpm -Uhv MySQL-Max-4.0.18-0.i386.rpm
Preparing...                     ########################################### 100%
   1:MySQL-Max              ########################################### 100%
Restarting mysqld.
error: execution of %post scriptlet from MySQL-Max-4.0.18-0 failed, exit status 127   <i>&lt;&lt;------ ?? is it a problem ?</i>
## service mysqld restart
Killing mysqld with pid 27293</pre>
<p class="tightenable">plog99</p>
<hr />
<p class="tightenable">I've discovered that there is on more thing to be done once upgraded to MySQL 4.0.X. It is covered in this link.</p>
<p class="tightenable"><a href="http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html" target="" class="namedurl"><span style="white-space: nowrap"><img src="images/http.png" alt="" class="linkicon" border="0" />http://dev.mysql.com/doc/mysql/en/Upgrading-from-3.23.html</span></a></p>
<p class="tightenable">Quote:
After upgrading, update the grant tables to add new privileges and features. The procedure uses the script mysql_fix_privilege_tables and is described in section</p>
<p class="tightenable bottom">Doug M.
&quot;Rigger&quot;</p>
</div>

<div id="footer">  <hr class="printer" noshade="noshade" />
<p class="editdate">Owner: &quot;Rigger&quot;  Last edited on April 12, 2004  3:06 pm by &quot;Rigger&quot;</p>
</div>

</div>
<!-- Add your Disclaimer here -->
</body>
</html>
