Re: mysql_error: Access denied for user: 'snort@localhost

[Jeff Price <misterunix () cox net>]

gsrao () cdacindia com wrote:

> Hi friends,
>
> I have installed Snort on RH9.0 with MYSQL,ACID,PHP as per the document
> available at internetguru.comI am getting following error while configuring acid:
>
> ERROR: database: mysql_error: Access denied for user: 'snort@localhost' (Using
> p                                             assword: YES)
>
> This error is not getting if i use "root" instead of "snort" as $alert_user
> and "root password" for $alert_password.
>
>  
What commands did you use to allow the user "snort"  to access the data 
base?

It should be something similar to this at the mysql prompt without the 
quotes;

use "database name"

grant all on * to snort@localhost identified by 'password'


Now rarely will you ever want to grant "all" permissions to anyone other 
than the database owner so modify this to suit your needs. the password 
needs to be entered with the single quotes.

Hope this helps :-) .

Jeff Price



-------------------------------------------------------
This SF.Net email is sponsored by: IBM Linux Tutorials
Free Linux tutorial presented by Daniel Robbins, President and CEO of
GenToo technologies. Learn everything from fundamentals to system
administration.http://ads.osdn.com/?ad_id=1470&alloc_id=3638&op=click
_______________________________________________
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