Albert, This may sound minuscule. You're certain that 'uma' is a user account and not a database or table?
Normally, you use "SHOW GRANTS FOR <user_account>". See example: mysql> SHOW GRANTS FOR test_usr; +------------------------------------------------------+ | Grants for [EMAIL PROTECTED] +------------------------------------------------------+ | GRANT USAGE ON *.* TO 'test_usr'@'% | GRANT ALL PRIVILEGES ON 'tempdb'.* TO 'test_usr'@'%' | GRANT ALL PRIVILEGES ON 'test'.* TO 'test_usr'@'%' +------------------------------------------------------+ However, if you attempt to show grants on an object with "SHOW GRANTS FOR <object_name>" you get the following error. See example: mysql> SHOW GRANTS FOR tempdb; ERROR 1141: There is no such grant defined for user 'tempdb' on host '%' Albert, one suggestion. Next time provide the exact error message. It makes it easier to assist. Regards, Adam -----Original Message----- From: Albert [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 8:46 AM To: [EMAIL PROTECTED] Subject: Re: Show database problem 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
