Re: Access Denied when logging to MySQL database

[Steve Suehring <snort () braingia org>]

On Wed, Dec 04, 2002 at 11:56:29AM -0800, Robby Desmond wrote:
> <sound of horrible gagging-choking sound> NO! Always flush privileges! 
> Always! There have been numerous occasions where I ran into issues with 
> this.
>
> Just do it. It's easier. Trust me.

Heh.  Nope.  If you use grant, revoke or set password you don't have to
use flush privileges.  I won't bore you with a shameless plug for MySQL
Bible.  :)  I'll cite the MySQL documentation, section 4.3 "When Privilege
Changes Take Effect"

"Modifications to the grant tables that you perform using GRANT, REVOKE, 
or SET PASSWORD are noticed by the server immediately."

http://www.mysql.com/doc/en/Privilege_changes.html

If you're seeing issues when using grant, revoke, or set password with 
changes not taking effect then that's something we should be dealing with 
on a MySQL mailing list because it indicates something else is broken.

Steve



-------------------------------------------------------
This SF.net email is sponsored by: Microsoft Visual Studio.NET 
comprehensive development tool, built to increase your 
productivity. Try a free online hosted session at:
http://ads.sourceforge.net/cgi-bin/redirect.pl?micr0003en
_______________________________________________
Snort-users mailing list
Snort-users () lists sourceforge net
Go to this URL to change user options or unsubscribe:
https://lists.sourceforge.net/lists/listinfo/snort-users
Snort-users list archive:
http://www.geocrawler.com/redir-sf.php3?list=snort-users