Re: Show database problem

2003-09-03 Thread Victoria Reznichenko
"Joris Beckers" <[EMAIL PROTECTED]> wrote: > > I used the flush privileges command > > There are in total 6 databases > > But only mysql and cehdb are visible. > > The MySQL version is 4.1.0-max-nt > > There are no other hosts configured for that user other then % > > Because it's mysql 4, th

Re: Show database problem

2003-09-02 Thread Albert
Message - From: "Roger Baklund" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Albert" <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 9:36 AM Subject: Re: Show database problem > * Albert > > When I enter : > > > > mysql\bin

Re: Show database problem

2003-09-02 Thread Antony Dovgal
On Tue, 2 Sep 2003 08:45:42 -0400 "Albert" <[EMAIL PROTECTED]> wrote: > 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 > > An

Re: Show database problem

2003-09-02 Thread Albert
o: "'Albert'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, September 02, 2003 9:38 AM Subject: RE: Show database problem .com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Show database problem

2003-09-02 Thread Albert
ortuno, 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'

Re: Show database problem

2003-09-02 Thread Roger Baklund
* Albert > 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? When you say you "try it from mysql>" d

RE: Show database problem

2003-09-02 Thread Fortuno, Adam
;%' 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 :

Re: Show database problem

2003-09-02 Thread Albert
"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 wa

RE: Show database problem

2003-09-01 Thread Joris Beckers
I used the flush privileges command There are in total 6 databases But only mysql and cehdb are visible. The MySQL version is 4.1.0-max-nt There are no other hosts configured for that user other then % Because it's mysql 4, the safe-show-database option is not usefull All the users that exist

Re: Show database problem

2003-09-01 Thread Yves Goergen
On Monday, September 01, 2003 5:19 PM CEST, Joris Beckers wrote: > But, when I log in using that username. That user can access the main > database... > > > > Does anyone know how to fix this? > Only cehdb should be accessable. Did you try to set the safe-show-database flag? Hm, let me see where

Re: Show database problem

2003-09-01 Thread Antony Dovgal
On Mon, 1 Sep 2003 17:19:52 +0200 "Joris Beckers" <[EMAIL PROTECTED]> wrote: > I've got a user, admFrederic > He got the grants shown below. > Those are correct and I configured them that way. don't forget about FLUSH PRIVILEGES; --- WBR, Antony Dovgal aka tony2001 [EMAIL PROTECTED] -- MySQL G

Show database problem

2003-09-01 Thread Joris Beckers
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] | +---