View Single Post
Old 2nd January 2007, 15:36
Bubo Bubo is offline
Junior Member
Join Date: Nov 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySql on Ubuntu 6.06 LTS Server

Hi All

I am trying to setup a stand alone MySql server for a specific task in our office. I have followed the howto (perfect ubuntu 6.06) up to and including the mysql installation.

I can then get a mysql prompt by entering:

mysql -u root -p <password>

Our lan is as follows: - Smoothwall handling DHCP across lan + firewall - Win 2003 Server handling DNS for lan and running active directory for authenticating a dozen or so Windows boxes.

I have set the Ubuntu server as static IP on

netstat -tap shows mysql listening on all and I can ping from a windows box on the lan.

When I try and ping the host/domain name (server2.<hostname>) however I get host not found so I am thinking perhaps a DNS issue?

I wanted to use a gui adminstrator for mysql as I am fairly new to it, so I chose MySql Control Centre on my Windows box.

When I try to connect to the Mysql Server using this I get this error:

[root@;3306] ERROR 1130: Host '' is not allowed to connect to this MySQL server
So my question is, what is preventing me accessing this server across the lan and how can I resolve the issue?

Thanks in advance.

Reply With Quote
Sponsored Links