From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Acces rights in 4.1.2
>Description:
Hi , i've installed the packages and created one db user called pm_user.
the host is called pm-spa280. I created GRANTS for [EMAIL PROTECTED] and [EMAIL
PROTECTED]
both grants are with password. accessing the db from the db-server using :
mysql --host pm-spa280 -u pm_user
gives a logon without deny !
mysql> select Host,User,Password from user\g
+------------+----------+-------------------------------------------+
| Host | User | Password |
+------------+----------+-------------------------------------------+
| localhost | root | |
| pm-spa280 | root | |
| % | pm_user | *EC3B747D263E3A98CDBE855B3A8586738CD230A6 |
| localhost | pm_user | *EC3B747D263E3A98CDBE855B3A8586738CD230A6 |
+------------+----------+-------------------------------------------+
7 rows in set (0.00 sec)
It looks as the % is ignored if the host is the dbhost.
>How-To-Repeat:
<code/input/activities to reproduce the problem (multiple lines)>
>Fix:
I added the host pm-spa280 with a third grant
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one line)>
>Release: mysql-4.1.2-alpha-standard (Official MySQL RPM)
>Server: /usr/bin/mysqladmin Ver 8.40 Distrib 4.1.2-alpha, for pc-linux on i686
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 4.1.2-alpha-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 16 days 23 hours 35 min 26 sec
Threads: 1 Questions: 5 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1
Queries per second avg: 0.000
>C compiler: 2.95.3
>C++ compiler: 2.95.3
>Environment:
<machine, os, target, libraries (multiple lines)>
System: Linux linoi430 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386
GNU/Linux
Architecture: i686
Some paths: /usr/local/ActivePerl-5.8/bin/perl /usr/bin/make /usr/bin/gmake
/usr/bin/gcc /usr/bin/cc
GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/3.2/specs
Configured with: ../configure --prefix=/usr --mandir=/usr/share/man
--infodir=/usr/share/info --enable-shared --enable-threads=posix --disable-checking
--host=i386-redhat-linux --with-system-zlib --enable-__cxa_atexit
Thread model: posix
gcc version 3.2 20020903 (Red Hat Linux 8.0 3.2-7)
Compilation info: CC='gcc' CFLAGS='-O2 -mcpu=i486 -fno-strength-reduce' CXX='gcc'
CXXFLAGS='-O2 -mcpu=i486 -fno-strength-reduce -felide-constructors
-fno-exceptions -fno-rtti ' LDFLAGS='' ASFLAGS=''
LIBC:
lrwxrwxrwx 1 root root 14 Okt 28 2002 /lib/libc.so.6 ->
libc-2.2.93.so
-rwxr-xr-x 2 root root 1235468 Sep 6 2002 /lib/libc-2.2.93.so
-rw-r--r-- 1 root root 2233342 Sep 6 2002 /usr/lib/libc.a
-rw-r--r-- 1 root root 178 Sep 6 2002 /usr/lib/libc.so
Configure command: ./configure '--disable-shared' '--with-mysqld-ldflags=-all-static'
'--with-client-ldflags=-all-static' '--with-server-suffix=-standard'
'--without-embedded-server' '--without-berkeley-db' '--with-innodb' '--without-vio'
'--without-openssl' '--enable-assembler' '--enable-local-infile'
'--with-mysqld-user=mysql' '--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--prefix=/' '--with-extra-charsets=complex' '--exec-prefix=/usr'
'--libexecdir=/usr/sbin' '--libdir=/usr/lib' '--sysconfdir=/etc'
'--datadir=/usr/share' '--localstatedir=/var/lib/mysql' '--infodir=/usr/share/info'
'--includedir=/usr/include' '--mandir=/usr/share/man' '--enable-thread-safe-client'
'--with-comment=Official MySQL RPM' '--with-readline' 'CC=gcc' 'CFLAGS=-O2 -mcpu=i486
-fno-strength-reduce' 'CXXFLAGS=-O2 -mcpu=i486 -fno-strength-reduce
-felide-constructors -fno-exceptions -fno-rtti ' 'CXX=gcc'
______________________________________________________
Mit freundlichen Grüßen / Best regards
SIEMENS
Siemens AG Power Generation
IT562, Application Development
Freyeslebenstr. 1
91058 Erlangen / GERMANY
Johannes Hausmann
mailto:[EMAIL PROTECTED]
Fon +49 9131 18 85764
Fax +49 9131 18 2189
______________________________________________________
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
