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.
Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 2nd January 2007, 16:32
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

This looks like a response from the MySQL server, so the only thing left to do is to grant permissions to the user in MySQL. Normally you only get 'localhost' access. Use phpmyadmin or similar to change the permissions of the the user you want to connect with. For which I wouldn't use 'root', but that's a simple security matter.
Reply With Quote
  #3  
Old 3rd January 2007, 18:51
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,752 Times in 2,582 Posts
Default

martinfst is right, you need a user with 192.168.10.144 in the Host field in the mysql.user table.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #4  
Old 3rd January 2007, 18:59
Bubo Bubo is offline
Junior Member
 
Join Date: Nov 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for that but I am still a little confused

I created the user as follows:

Code:
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
mysql> GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'
    ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
which I thought should allow access from anywhere on the lan.

I can then connect from my Win box using this username however when I try and use a specific windows app to connect I get the access denied message again.

Its all very confusing

Bubo
Reply With Quote
  #5  
Old 3rd January 2007, 19:02
Bubo Bubo is offline
Junior Member
 
Join Date: Nov 2006
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Forgot to mention, the winows app came bundled with mysl 4.1 for windows.

I have installed mysql 5 on the Ubuntu server. Will that version difference cause this kind of error ? I didn't think so but am willing to be told otherwise.

Bubo
Reply With Quote
  #6  
Old 3rd January 2007, 23:11
martinfst martinfst is offline
Senior Member
 
Join Date: Dec 2006
Location: Hilversum, The Netherlands
Posts: 880
Thanks: 1
Thanked 18 Times in 17 Posts
Send a message via MSN to martinfst Send a message via Skype™ to martinfst
Default

After the 'GRANTS' did you issue the MySQL command
Code:
flush privileges;
Reply With Quote
Reply

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 23:28.


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