From: Dan Nelson Date: January 26 2003 3:26am Subject: Re: upgrade mySQL List-Archive: http://lists.mysql.com/mysql/130923 Message-Id: <20030126032625.GA58722@dan.emsphone.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii In the last episode (Jan 25), pazenko said: > I'm currently upgrading mySQL v3.23 to mySQL v4.0, the installation of > v4.0 was a success,I tried to execute mysql_fix_privilege_tables > c:\mysql\bin>mysql -e mysql_fix_privilege_tables > but i keep on getting the error: > > ERROR 1064 at line 1: You have an error in your SQL syntax. Check the > manual that corresponds to your mySQL server version for the right syntax to > use near 'mysql_fix_privilege_tables' at line 1 > > what is the right way of running this script? I don't know if there's a windows version if it. It's a shell script. If you have cygwin installed, try running "sh mysql_fix_privilege_tables" -- Dan Nelson dnelson@stripped