Re: Access denied for user: '@192.168.0.1' -SNORT-

["mike Hughes" <mikehughes013 () hotmail com>]

Hey alright i UN-INSTALLED MYSQL and re-installed it on my windows machine.

Here is the EXACT commands i did and the output:

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>cd mysql

C:\mysql>cd bin

C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 3.23.55-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| test     |
+----------+
2 rows in set (0.00 sec)

mysql> CREATE DATABASE snort;
Query OK, 1 row affected (0.01 sec)

mysql> SHOW DATABASES;
+----------+
| Database |
+----------+
| mysql    |
| snort    |
| test     |
+----------+
3 rows in set (0.00 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.10 sec)

mysql> grant SELECT,INSERT,UPDATE,DELETE,CREATE on snort.* to snort;
Query OK, 0 rows affected (0.03 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye


C:\mysql\bin>mysql -u root mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 3.23.55-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> GRANT ALL PRIVILEGES on snort.* to Sensor@192.168.0.1;
Query OK, 0 rows affected (0.00 sec)

mysql> mysql -u snort snort < c:\snortM\snort.db\create_mysql

mysql> mysql -u snort snort < c:\snortM\snort.db\create_mysql
--------------
mysql  Ver 11.18 Distrib 3.23.55, for Win95/Win98 (i32)

Connection id:          4
Current database:       mysql
Current user:           root@localhost
Server version:         3.23.55-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 1 hour 8 min 28 sec

Threads: 1  Questions: 45  Slow queries: 0  Opens: 18  Flush tables: 1  Open 
tab
les: 0 Queries per second avg: 0.011
--------------

--------------
mysql  Ver 11.18 Distrib 3.23.55, for Win95/Win98 (i32)

Connection id:          4
Current database:       mysql
Current user:           root@localhost
Server version:         3.23.55-nt
Protocol version:       10
Connection:             localhost via TCP/IP
Client characterset:    latin1
Server characterset:    latin1
TCP port:               3306
Uptime:                 1 hour 8 min 28 sec

Threads: 1  Questions: 46  Slow queries: 0  Opens: 18  Flush tables: 1  Open 
tab
les: 0 Queries per second avg: 0.011
--------------

   -> ;



Is everyhting right? Or is somehting wrong with that last command? Or if i 
need to add something beofore i can TEST it now!!!







> From: "Kenneth G. Arnold" <bkarnold () cbu edu>
> To: "mike Hughes" <mikehughes013 () hotmail com>
> Subject: Re: [Snort-users] Access denied for user: '@192.168.0.1'  -SNORT-
> Date: Wed, 12 Feb 2003 14:31:57 -0600
>
> At 11:28 AM 2/12/03 -0800, you wrote:
> > mysql -u sensor1 -h 192.168.0.69 -p    YES i can connect to it.
> >
> > mysql -s snort -h 192.168.0.69 -p      YES i CAN connect to it.
> > "Both" time its says welcome to mysql moniter and gives me the prompt:
> > mysql>
> >
> >
> > Here is a netstat -an  output too from windows machine:
> > TCP    0.0.0.0:2725           0.0.0.0:0              LISTENING
> > TCP    0.0.0.0:3047           0.0.0.0:0              LISTENING
> > TCP    0.0.0.0:3051           0.0.0.0:0              LISTENING
> > TCP    0.0.0.0:3052           0.0.0.0:0              LISTENING
> > TCP    0.0.0.0:3131           0.0.0.0:0              LISTENING
> > TCP    0.0.0.0:3306           0.0.0.0:0              LISTENING
>
> This shows that it is listening.  Is there an entry showing an actual 
> connection from 192.168.0.1 to this machine on port 3306 when snort is 
> running?
>
>
> Brother Kenneth Arnold
> System Administrator
> Information Technology Services
> Christian Brothers University
> (901) 321-4333


_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*   
http://join.msn.com/?page=features/junkmail



-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
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