Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
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:

Code:
mysql -u root -p <password>
.

Our lan is as follows:

192.168.10.1 - Smoothwall handling DHCP across lan + firewall
192.168.10.2 - 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 192.168.10.222.

netstat -tap shows mysql listening on all and I can ping 192.168.10.222 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:

Code:
[root@192.168.10.222;3306] ERROR 1130: Host '192.168.10.144' 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.

Bubo
Reply With Quote
Sponsored Links
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistic not working mzo Installation/Configuration 49 20th April 2011 13:19
Error when following How To Install VMware Server On Ubuntu 6.06 LTS (Dapper Drake) - somas1 HOWTO-Related Questions 7 20th August 2006 15:07
Help with The Perfect Setup - Ubuntu 6.06 LTS Server LinuxNewb HOWTO-Related Questions 6 30th July 2006 14:43
Can't set up root password on MySQL server for Ubuntu 6.06 simianstyle Installation/Configuration 15 19th June 2006 17:44
Request: Perfect Ubuntu 6.06 LTS - Automatic LAMP Server Installation (co-location) Anim Suggest HOWTO 19 6th June 2006 12:30


All times are GMT +2. The time now is 11:27.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.