This is the error I get and yes uma is a user and listed in my.ini file actually
C:\mysql\bin>SHOW GRANTS FOR uma; 'SHOW' is not recognized as an internal or external command, operable program or batch file. C:\mysql\bin> Albert ----- Original Message ----- From: "Fortuno, Adam" <[EMAIL PROTECTED]> To: "'Albert'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 9:38 AM Subject: RE: Show database problem > 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]
