LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-12-2003, 07:54 PM   #1
nullpt
Member
 
Registered: Jul 2003
Distribution: Red Hat
Posts: 94

Rep: Reputation: 15
help urgent please!


Hello all,

I've got mysqld owork on my server so I can use it on my web-sites.

But it it's listening a port for remote connections.

How can I set mysqld to run strictly local?

Thanks for your precious time.
 
Old 10-12-2003, 08:08 PM   #2
mossy
Member
 
Registered: Aug 2003
Location: USexIRL
Distribution: *nix
Posts: 849

Rep: Reputation: 30
I believe it is a server. You can prolly shut it off by firewall or there may be a switch to stop it listening. Maybe killing the daemon???????

Last edited by mossy; 10-12-2003 at 08:09 PM.
 
Old 10-12-2003, 08:16 PM   #3
retep
Member
 
Registered: Sep 2003
Distribution: RedHat/Debian
Posts: 50

Rep: Reputation: 15
There may be an option in the my.cnf file to select which address mysql listens on (but I'm not aware of one).

As mossy mentioned, you may want to throw up a firewall.

Also, mysql has its own security about which users can connect to which hosts. See http://www.mysql.com/doc/en/GRANT.html

It differentiates localhost users from users on other hosts. But application security isn't as good as just not listening on a public address..
 
Old 10-12-2003, 10:23 PM   #4
nullpt
Member
 
Registered: Jul 2003
Distribution: Red Hat
Posts: 94

Original Poster
Rep: Reputation: 15
Yes I could do that, but I wanted to know the daemon switch way, I belive there is one.
If anyone knows it pls tell me.

I am aware that there have been some remote exploits for mysqld and I really wanted to shut that door.

Thanks alot for your precious time

Last edited by nullpt; 10-12-2003 at 10:24 PM.
 
Old 10-12-2003, 11:29 PM   #5
nullpt
Member
 
Registered: Jul 2003
Distribution: Red Hat
Posts: 94

Original Poster
Rep: Reputation: 15
Hi,

I found this in the manual pages at mysql.com.

/etc/my.conf

[mysqld]
datadir=/usr/local/mysql/var
socket=/var/tmp/mysql.sock
port=3306
user=mysql

I haven't test it because the server is beeing upgraded (RAM).
I'll try to set the port to 0 or leave with empty.
I'm just afraid that to local connections it gets stuck.

Still i belice there is some switch or other config argument for this... changing the port is for remote connections and as well for local connections, I don't belive it will work fine with the port changed.

Still I can set it to a very high port where no one can see it, or simply block it with the firewall (wich I dont use).


Thanks for all your help!

Gn8 all

Last edited by nullpt; 10-12-2003 at 11:31 PM.
 
Old 10-12-2003, 11:32 PM   #6
retep
Member
 
Registered: Sep 2003
Distribution: RedHat/Debian
Posts: 50

Rep: Reputation: 15
After a quick check, it looks like bind-address is the /etc/my.cnf setting you need:
http://www.mysql.com/doc/en/Privileges_options.html

Either that, or skip-networking.
 
  


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
boot sector and lilo collapse !!!!! URGENT URGENT URGEN !!!!! frelihm Linux - Software 21 12-02-2009 10:21 AM
Urgent Question Regarding Urgent Questions! Need Help Now! Crashed_Again LQ Suggestions & Feedback 11 10-17-2007 08:07 PM
urgent help please !!! deepdark SUSE / openSUSE 5 01-02-2005 11:39 PM
Urgent..Im Having A Nightmare..Urgent!!!! midgcool Linux - Software 41 11-30-2004 10:19 AM
Urgent Urgent !!!! Mozilla Keeps All Your Deleted Emails !!!! odin123 Linux - Software 2 01-31-2004 02:22 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:19 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
Open Source Consulting | Domain Registration