Re: [Snort-users] Access denied for user: '@192.168.0.1' -SNORT-

From: mike Hughes <mikehughes013(at)hotmail.com>
Date: Wed Feb 12 2003 - 20:39:39 EST

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 Received on Wed Feb 12 21:00:24 2003