>Description:
Installation has never worked properly - I have re-installed 5 or 6 times,
different versions. Initially Mandrake 7.0 version, then tried to install a
386 rpm - wouldn't install, said it was for the wrong architecture, so tried
the i686 binaries (initially 3.23.33-pc-linux-gnu-i686, then
3.23.49a-pc-linux-gnu-i686); same problem, so re-installed the Mandrake
version (currently on this one - 3.22.32).
MySQL server seems to be working correctly - I can insert rows, grant
privileges using Webmin.
Using the Client however (mysql -h localhost -p -u root), I am able to
create tables, SELECT * FROM user etc, but cannot do the following commands:
SELECT * FROM user WHERE User = 'root'; --> ERROR 1064: You have an error in
your SQL syntax near 'root' at line 1
GRANT ALL ON webdb.* TO webdev@localhost IDENTIFIED BY 'webdevpass'; -->
ERROR 1064: You have an error in your SQL syntax bear 'webdevpass' at line 1
If I use this last command without the IDENTIFIED BY statement, a row gets
added but it doesn't get any privileges.
>How-To-Repeat:
as above
>Fix:
not known
I've searched manual and two books. Please help!! Thanks.
>Submitter-Id:
>Originator: root
>Organization: riversidesa
>MySQL support: [none]
>Synopsis: installation - client queries not working
>Severity: critical
>Priority: medium
>Category: mysql
>Class: support
>Release: mysql-3.22.32 (Source distribution)
>Server: /usr/bin/mysqladmin Ver 8.0 Distrib 3.22.32, for pc-linux-gnu on
i686
TCX Datakonsult AB, by Monty
Server version 3.22.32
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 10 min 58 sec
Threads: 1 Questions: 1 Slow queries: 0 Opens: 6 Flush tables: 1 Open
tables: 2
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux mp.riversidesa.co.za 2.2.15-4mdkfb #1 Wed May 10 15:00:49 CEST
2000 i?86 unknown
Architecture: i?86
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i586-mandrake-linux/2.95.3/specs
gcc version 2.95.3 19991030 (prerelease)
Compilation info: CC='gcc'
CFLAGS='-O3 -fomit-frame-pointer -fno-exceptions -fno-rtti -pipe -s -mpentiu
m -mcpu=pentium -march=pentium -ffast-math -fexpensive-optimizations'
CXX='g++' CXXFLAGS='' LDFLAGS=''
Configure command:
./configure --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql
/mysql.sock --prefix=/ --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdi
r=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/in
fo --includedir=/usr/include --mandir=/usr/man
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
