LinuxQuestions.org
Latest LQ Deal: Complete CCNA, CCNP & Red Hat Certification Training Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
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!

Notices


Reply
  Search this Thread
Old 06-21-2006, 01:33 AM   #1
gubak
Member
 
Registered: Jul 2004
Posts: 332

Rep: Reputation: 30
Mysql on RedHat9


Hi
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: 5.2.2.1-5.2.2.255.
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 5.2.2.2 and when I try it I get the warning "Host 5.2.2.2 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 5.2.2.2?


Thank you

Last edited by gubak; 10-02-2006 at 07:56 AM.
 
Old 06-21-2006, 02: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)
Code:
grant all to username@5.2.2.2 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 02:11 AM.
 
  


Reply


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 06:24 AM
mysql question (w/ redhat9) monzlin Linux - Software 2 05-08-2004 05:18 PM
How to configure mysql on a fresh redhat9 install? unclean Linux - Software 0 01-30-2004 04:42 PM
Linux newbie needs help with install of MySQL on Redhat9 bkimelman Linux - Software 1 11-03-2003 12:28 PM
MySQL problems in Redhat9 Prog-Kenny Linux - Software 3 08-13-2003 06:30 PM


All times are GMT -5. The time now is 12:00 PM.

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