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
--
-----------------------------------------------------------------------------
Dean Waldow, Associate Professor (253) 535-7533
Department of Chemistry (253) 536-5055 (FAX)
Pacific Lutheran University [EMAIL PROTECTED]
Tacoma, WA 98447 USA http://www.chem.plu.edu/waldow.html
-----------------------------------------------------------------------------
---> CIRRUS and the Chemistry homepage: http://www.chem.plu.edu/ <---
-----------------------------------------------------------------------------
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
