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]