Welcome to the most active Linux Forum on the web.
Go Back > Forums > Linux Forums > Linux - Newbie
User Name
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!


  Search this Thread
Old 06-21-2006, 12:33 AM   #1
Registered: Jul 2004
Posts: 332

Rep: Reputation: 30
Mysql on RedHat9

I have a LAN with RedHat9 server (proxy, ftp, mail, web( Apache 2.0.40, Php 4.2.2, Mysql)). The Linux server has 2 network card (one for the LAN and another is the gateway to the internet). My local address interval:
The default Mysql setting allows only localhost connection to mysql database, but I want to connect from another computer (I have a program with mysql connection)from the address and when I try it I get the warning "Host is not allowed to connect to this MySql server"
My question is:
How can I set my Linux and MySql server to beeing able to connect from the host

Thank you

Last edited by gubak; 10-02-2006 at 06:56 AM.
Old 06-21-2006, 01:01 AM   #2
Wim Sturkenboom
Senior Member
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
Not 100% sure (did not feel like testing)
grant all to username@ identified by mypassword
grant permissions to username@5.2.2.% identified by mypassword
The first one allows a specific user from a specific machine with all permissions, the second one a specific user from all machines in 5.2.2.* with specific permissions.

user manual

PS I canceled all external access on my box. I use telnet/ssh to get in the box and next use mysql on the box itself.

Last edited by Wim Sturkenboom; 06-21-2006 at 01:11 AM.


Thread Tools Search this Thread
Search this Thread:

Advanced Search

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 Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
MYSQL-Reordering Problem in REDHAT9.0 JsSS Programming 8 09-08-2004 05:24 AM
mysql question (w/ redhat9) monzlin Linux - Software 2 05-08-2004 04:18 PM
How to configure mysql on a fresh redhat9 install? unclean Linux - Software 0 01-30-2004 03:42 PM
Linux newbie needs help with install of MySQL on Redhat9 bkimelman Linux - Software 1 11-03-2003 11:28 AM
MySQL problems in Redhat9 Prog-Kenny Linux - Software 3 08-13-2003 05:30 PM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 05:40 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration