List:General Discussion« Previous MessageNext Message »
From:iConnect \(Berlin\) Stefan Hinz Date:January 25 2003 4:19pm
Subject:Re: upgrade mySQL
View as plain text  
Lewell,

>     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

The script your speaking of is a Unix shell script, and there is nothing
like that in the Windows binary dist, AFAIK. The MySQL 4.0.x setup
should set up the new privileges (privilege tables), too. I guess this
will only happen when you delete / rename your old mysql database
beforehand.

I'll send Cc: to Miguel who is in care of setting up the dists at MySQL
AB, AFAIK. He should know what to do best to change the priv tables to
have the new privs available.

Regards,
--
  Stefan Hinz <hinz@stripped>
  Geschäftsführer / CEO iConnect GmbH <http://iConnect.de>
  Heesestr. 6, 12169 Berlin (Germany)
  Tel: +49 30 7970948-0  Fax: +49 30 7970948-3

----- Original Message -----
From: "pazenko" <news@stripped>
To: <mysql@stripped>
Sent: Saturday, January 25, 2003 1:18 PM
Subject: upgrade mySQL


> Greetings
>
>     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?
>
> OS: win98se
> mySQL: version 4.0.9 -gamma
> winMySQLAdmin 1.4: started
>
>
> lewell
>
>
> The content of this email when sent is as full as practical. Due to
the
> settling of the words the contents might not appear as full as it was
but
> the weight remains the same. The contents is being sent by weight and
not by
> volume.
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread130885@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-list_hinz=iconnect.de@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

Thread
upgrade mySQLpazenko25 Jan
  • Re: upgrade mySQLiConnect \(Berlin\) Stefan Hinz25 Jan
  • Re: upgrade mySQLDan Nelson26 Jan