When I enter :

mysql\bin>SHOW GRANTS FOR uma;

I get a response that show is not a command etc.. 

This is on Win32 version 4.x

The same happens when I try it from mysql>
and also after I run mysqld

Any ideas what is wrong here?
Thanks

Albert


----- Original Message ----- 
From: "Joris Beckers" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, September 01, 2003 11:19 AM
Subject: Show database problem


> I've got a user, admFrederic
> He got the grants shown below.
> Those are correct and I configured them that way.
> 
> mysql> SHOW GRANTS FOR admFrederic;
> +-----------------------------------------------------------------------
> ----------------+
> | Grants for [EMAIL PROTECTED]
> |
> +-----------------------------------------------------------------------
> ----------------+
> | GRANT USAGE ON *.* TO 'admFrederic'@'%' IDENTIFIED BY PASSWORD
> '6ddf5e1a1cc75e8a'     |
> | GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, ALTER ON `cehdb`.* TO
> 'admFrederic'@'%' |
> +-----------------------------------------------------------------------
> ----------------+
> 
> 
> But, when I log in using that username. That user can access the main
> database...
> 
> mysql> show databases;
> +----------+
> | Database |
> +----------+
> | cehdb    |
> | mysql    |
> +----------+
> 
> 
> Does anyone know how to fix this?
> Only cehdb should be accessable.
> Also, the user can run SQL commands on the mysql database.
> GRANT commands etc. are not possible.
> 
> This is the version info.
> 
> mysql> status;
> --------------
> mysql  Ver 11.18 Distrib 3.23.53, for Win95/Win98 (i32)
> 
> Connection id:          351
> Current database:
> Current user:           [EMAIL PROTECTED]
> Server version:         4.1.0-alpha-max-nt
> Protocol version:       10
> Connection:             nemesis via TCP/IP
> Client characterset:    latin1
> Server characterset:    latin1
> TCP port:               3333
> Uptime:                 1 hour 6 min 14 sec
> 
> 
> Thanks,
> Joris
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
> 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to