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, the

Re: Show database problem

2003-09-02 Thread Albert
When I enter : mysql\binSHOW 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

RE: Show database problem

2003-09-02 Thread Fortuno, 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\binSHOW GRANTS FOR uma; I get a response that show is not a command etc.. This is on Win32 version 4.x

Re: Show database problem

2003-09-02 Thread Roger Baklund
* Albert When I enter : mysql\binSHOW 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 do you mean

Re: Show database problem

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

Re: Show database problem

2003-09-02 Thread Albert
]; [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 Antony Dovgal
On Tue, 2 Sep 2003 08:45:42 -0400 Albert [EMAIL PROTECTED] wrote: When I enter : mysql\binSHOW 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

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\binSHOW GRANTS FOR uma; I get a response that show is not a command etc

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 General

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... snip 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 I

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