| View previous topic :: View next topic |
| Author |
Message |
Dracos
n00b
Joined: 13 Jan 2005
Posts: 19
|
 Posted: Sat Nov 04, 2006 7:07 am Post subject: Mysql not listening for network connections |
 |
|
Can anyone explain this?
| Code: | mordor ~ # nmap -P0 localhost
Starting Nmap 4.01 ( http://www.insecure.org/nmap/ ) at 2006-11-03 23:02 PST
Interesting ports on localhost (127.0.0.1):
(The 1667 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
80/tcp open http
139/tcp open netbios-ssn
445/tcp open microsoft-ds
3306/tcp open mysql |
Now, by IP address:
| Code: | mordor ~ # nmap -P0 192.168.0.8
Starting Nmap 4.01 ( http://www.insecure.org/nmap/ ) at 2006-11-03 23:02 PST
Interesting ports on 192.168.0.8:
(The 1668 ports scanned but not shown below are in state: closed)
PORT STATE SERVICE
22/tcp open ssh
80/tcp open http
139/tcp open netbios-ssn
445/tcp open microsoft-ds |
In my.cnf (cut down to relevant lines per numerous Google searches):
| Code: | [mysqld]
port = 3306
# skip-networking |
Am I missing something? All I want to do is connect with SQLYog from my win2k box at 192.168.0.9 |
|
| Back to top |
|
 |
n3bul4
Apprentice
Joined: 04 Nov 2003
Posts: 187
|
| Posted: Sat Nov 04, 2006 8:11 am Post subject: |
|
|
localhost != 192.168.0.8
The problem is, that your mysql daemon is only listening on the localhost (127.0.0.1)
If you want to also listen on an other interface you have to edit your
mysql config....
greetz |
|
| Back to top |
|
|
Dracos
n00b
Joined: 13 Jan 2005
Posts: 19
|
| Posted: Sat Nov 04, 2006 9:01 am Post subject: |
|
|
I see that now. I found another thread that said to comment out
| Code: | | bind-address = 127.0.0.1 |
but that didn't work. Now mysqld is segfaulting at startup (like it always does between zapping it and reinstalling). It leaves it's pid file behind, complains about that when I restart it, but then dies. I have the following stack trace:
| Code: | 0x812224a handle_segfault + 360
0xb7d40677 _end + -1349941401
0x82a46ff os_file_read + 207
0x82810ba fil_io + 1542
0x826d6f4 buf_LRU_invalidate_tablespace + 1434
0x826dcba buf_read_page + 434
0x8265d26 buf_page_get_gen + 128
0x8277d59 fsp_parse_init_file_page + 770
0x8277d9b fsp_parse_init_file_page + 836
0x82780f0 fseg_n_reserved_pages + 53
0x822ba02 ibuf_data_init_for_space + 360
0x8283064 fil_ibuf_init_at_db_start + 416
0x822b5a1 ibuf_init_at_db_start + 218
0x8218ed2 dict_boot + 2595
0x8217e34 innobase_start_or_create_for_mysql + 4047 |
The only thing that makes it actually start again is reinstalling it.
I want mysql to listen on localhost and 192.168.0.8. This is my web development box, I have a lot of stuff pointed at localhost that I'd like to avoid changing. |
|
| Back to top |
|
|
n3bul4
Apprentice
Joined: 04 Nov 2003
Posts: 187
|
| Posted: Sat Nov 04, 2006 10:30 am Post subject: |
|
|
Hmm the segfault is strange....
Did this start after you commented out the line in your config?
You could do the following:
| Code: | | bind-address = 0.0.0.0 |
This would let it listen on all interfaces.
I am not sure if this works:
| Code: | | bind-address = 127.0.0.1,192.168.0.8 |
but there should be an example config file or you look at the manual.....
Maybe you also look at your logfiles.....eventually there is some info about
the problem..... |
|
| Back to top |
|
|
|
Networking & Security
