This is my first use of mySQL, so forgive my ignorance.
My problem is that I am not allowed to do anything as the new user I
just created.
The mysql utility refuses to allow access. Note that I did run
"mysqladmin reload" after granting privileges.
I have the mysql daemon running. I've created a root password.
Then I added a user to the mysql user table giving the user
access from any host with a '%' and a password.
Then I created a database and gave the user almost all priviledges
on the data base.
Here is the ouput from mysql
ncasi% mysql -u pvandeus -p
Enter password:
ERROR 1045: Access denied for user: 'pvandeus@localhost' (Using
password: YES)
ncasi%
Heres is output from mysqlaccess
ncasi% mysqlaccess \* pvandeus mysql -U root -P ************
Could not open outputfile ~/mysqlaccess.log for debugging-info
mysqlaccess Version 2.06, 20 Dec 2000
By RUG-AIV, by Yves Carlier ([EMAIL PROTECTED])
Changes by Steve Harvey ([EMAIL PROTECTED])
This software comes with ABSOLUTELY NO WARRANTY.
Unknown option: --brief
Access-rights
for USER 'pvandeus', from HOST '%', to DB 'mysql'
+-----------------+---+ +-----------------+---+
| Select_priv | Y | | Shutdown_priv | N |
| Insert_priv | N | | Process_priv | N |
| Update_priv | N | | File_priv | N |
| Delete_priv | N | | Grant_priv | N |
| Create_priv | N | | References_priv | N |
| Drop_priv | N | | Index_priv | N |
| Reload_priv | N | | Alter_priv | N |
+-----------------+---+ +-----------------+---+
NOTE: A password is required for user `pvandeus' :-(
The following rules are used:
db : 'No matching rule'
host : 'Not processed: host-field is not empty in db-table.'
user :
'%','pvandeus','0180d720766fdcfb','Y','N','N','N','N','N','N','N','N','N','N','N','N','N'
BUGs can be reported by email to [EMAIL PROTECTED]
ncasi%
===mysqlbug output====
>Submitter-Id: <submitter ID>
>Originator: Paul Van Deusen
>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-3.23.30-gamma (Official MySQL binary)
>Server: /opt/mysql/bin/mysqladmin Ver 8.13 Distrib 3.23.30-gamma, for
sun-solaris2.7 on sparc
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 3.23.30-gamma-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 17 min 14 sec
Threads: 1 Questions: 25 Slow queries: 0 Opens: 11 Flush tables: 1
Open tables: 0 Queries per second avg: 0.024
>Environment:
<machine, os, target, libraries (multiple lines)>
System: SunOS ncasi 5.7 Generic_106541-11 sun4u sparc SUNW,Ultra-5_10
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/ccs/bin/make /usr/local/bin/gcc
/usr/ucb/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs
gcc version 2.8.1
Compilation info: CC='gcc' CFLAGS='-O3 -fomit-frame-pointer'
CXX='gcc' CXXFLAGS='-O3 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1693992 May 19 2000 /lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 1 2000 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 bin bin 1115532 May 19 2000 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1693992 May 19 2000 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 1 2000 /usr/lib/libc.so
-> ./libc.so.1
-rwxr-xr-x 1 bin bin 1115532 May 19 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL binary' --with-extra-charsets=complex
--enable-assembler --disable-shared
Perl: This is perl, version 5.005_03 built for sun4-solaris
---------------------------------------------------------------------
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
