Download your favorite Linux distribution at LQ ISO.
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 04-13-2007, 01:21 AM   #1
Registered: Sep 2006
Posts: 52

Rep: Reputation: 15
Connecting to Linux (Fedora) database?

in a windows workgroup network, i just installed Fedora 5 Server with MySQL but window client just cannot connect to it to access the MYSQL database. how do i creat the connectivity for windows users? these are xp and windows 2000 pcs
Old 04-13-2007, 01:47 AM   #2
LQ Newbie
Registered: Apr 2006
Location: Szeged, Hungary
Distribution: Debian "squeeze"
Posts: 27

Rep: Reputation: 15
I don't know Fedora at all but, mysql is usually configured to listen to (localhost) so you can't connect to it from another computer. Edit /etc/mysql/my.cnf and change bind-address = to your computers LAN ip like .
Old 04-13-2007, 03:28 AM   #3
Registered: Sep 2006
Posts: 52

Original Poster
Rep: Reputation: 15
thanks Errotan, but the thing is that when i open the /etc/mysql/my.cnf file i dont see any entry line (with the for the ip address configuration. shall i just add it myself?
Old 04-13-2007, 11:20 AM   #4
Senior Member
Registered: Mar 2004
Location: Cary, NC, USA
Distribution: Fedora, Kubuntu, RedHat, CentOS, SuSe
Posts: 1,288

Rep: Reputation: 99
You shouldn't need to modify your my.cnf. You need to run system-config-securitylevel and under "Other ports" you need to add 3306 for both UDP and TCP. Once you are able to get to the mysql server, you may still not be able to connect until you add the User/Host to the mysql database user table.

Hope that helps.



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
connecting to a MySQL database hsa Linux - General 3 09-16-2005 06:34 AM
probs with connecting to mysql database using php ankscorek Linux - Software 4 08-16-2005 07:40 PM re-connecting to database error trscookie Programming 3 05-02-2005 11:39 AM
connecting to MYSQL remote database opsraja Linux - Software 1 02-18-2005 05:52 AM
Connecting a Postgres Database from a Java application Paulo Ges Programming 4 08-23-2003 10:08 AM > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 05:30 PM.

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
Open Source Consulting | Domain Registration