Snort mailing list archives
Re: Access Denied when logging to MySQL database
From: Steve Suehring <snort () braingia org>
Date: Wed, 4 Dec 2002 16:00:21 -0600
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
Current thread:
- Access Denied when logging to MySQL database Zymophideth (Dec 04)
- Re: Access Denied when logging to MySQL database twig les (Dec 04)
- Re: Access Denied when logging to MySQL database Steve Suehring (Dec 04)
- Re: Access Denied when logging to MySQL database Robby Desmond (Dec 04)
- Re: Access Denied when logging to MySQL database Steve Suehring (Dec 04)
- Re: Access Denied when logging to MySQL database shrek-m () gmx de (Dec 04)
- Re: Access Denied when logging to MySQL database Steve Suehring (Dec 04)
- Re: Access Denied when logging to MySQL database twig les (Dec 04)