D&C GLug - Home Page

[ Date Index ] [ Thread Index ] [ <= Previous by date / thread ] [ Next by date / thread => ]

Re: [LUG] Troubleshooting MySQL... failure to start

 

On 3/12/2007, "Tom Potts" <tompotts@xxxxxxxxxxxxxxxxxxxx> wrote:

>On Monday 03 December 2007 07:07, martin.gautier@xxxxxxxxxxxxx wrote:
>> >>Dec  2 23:47:55 fileserver mysqld[18963]: 071202 23:47:55 [ERROR] Can't
>>
>> start server: Bind on TCP/IP port: Cannot assign requested address
>>
>> MySQL binds to localhost by default on port 3306.
>>
>> Is your loopback (127.0.0.1) device running & working? I guess ifconfig
>> would be a good command to start with...
>or alternatively have you a firewall that is blocked on 3306 - assuming MySql
>is trying that one
>Tom te tom te tom

Cheers guys, but my loopback is up and running:
lo        Link encap:Local Loopback
          inet addr:127.0.0.1  Mask:255.0.0.0
          inet6 addr: ::1/128 Scope:Host
          UP LOOPBACK RUNNING  MTU:16436  Metric:1
          RX packets:10327 errors:0 dropped:0 overruns:0 frame:0
          TX packets:10327 errors:0 dropped:0 overruns:0 carrier:0
          collisions:0 txqueuelen:0
          RX bytes:1719919 (1.6 MiB)  TX bytes:1719919 (1.6 MiB)

and I have not installed a local firewall on this machine, the only
firewall I am using is one between my green (LAN) and red (WAN) networks.

Cheers.
Grant.

-- 
The Mailing List for the Devon & Cornwall LUG
http://mailman.dclug.org.uk/listinfo/list
FAQ: http://www.dcglug.org.uk/linux_adm/list-faq.html