Dean Waldow wrote:
>
> Hello,
>
> I am getting the following error when I try to flush privileges or any
> other flush parameter for that matter. I am trying to set the root
> password which requires a 'flush privileges' afterwards.
>
> mysql> flush privileges;
> ERROR 1064: parse error near 'flush privileges' at line 1
>
> Additional, if I try to set the password with mysqladmin I get the following:
>
> # mysqladmin -u root password example
> mysqladmin: unable to change password; error: 'parse error near
> 'password' at line 1'
>
> The mysql tables see setup fine with reload for user root set to 'Y'.
>
> The system is a SGI with IRIX 6.5. I installed mysql from irix binaries.
>
> >From what I can tell all of the basic function does work. I have go
> through many learning examples and they seem to work. I thought I
> should start securing things and this is when I noticed the problem.
>
> Any ideas would be greatly appreciated.
>
> Dean
>
> Also:
>
> >Server: ./mysqladmin Ver 6.9 Distrib 3.21.33b, for sgi-irix6.3 on mips
> TCX Datakonsult AB, by Monty
>
> Server version 3.21.33b
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 13 min 6 sec
>
> Running threads: 1 Questions: 36 Opened_tables: 4 Flush tables: 1
> Open tables: 4
> >Environment:
> <machine, os, target, libraries (multiple lines)>
> System: IRIX64 rainier 6.5 07271714 IP26
>
> Some paths: /bin/perl /bin/make /usr/freeware/bin/gcc /bin/cc
> GCC: Reading specs from /usr/freeware/lib/gcc-lib/mips-sgi-irix6.2/2.8.1/specs
> gcc version 2.8.1
> Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='-O3' LDFLAGS=''
>
> Perl: This is perl, version 5.004_04 built for irix-n32
>
Hi Dean
'flush priviledges' and 'mysqladmin -u root password ...' are 3.22.xx features.
If you want to use them you have to upgrade.
Else use 'mysqladmin -u root reload'.
Tschau
Christian
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
