Visit Our UNIX and Linux User Community


Open Port 3306 for MySQL connection


 
Thread Tools Search this Thread
Special Forums Cybersecurity Open Port 3306 for MySQL connection
# 1  
Old 04-12-2002
Open Port 3306 for MySQL connection

I am needing to "un-block" port 3306 so that I can access MySQL from another PC.

When I installed Mandrake 8.1, I set the security level to high because it is going to be a web server. I believe I have to allow access to my ports now and I do not know the commands to do that.

If anyone could show me an example, that would be great.
# 2  
Old 04-12-2002
If you are using iptables you would do something like:

iptables -A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT


Put it into your firewall config file. Not sure on the mandrake specifics. On redhat it is in /etc/sysconfig/
# 3  
Old 04-21-2002
It might also be ipchains, and not iptables. Not sure though which one is by default on Mandrake.

You should read an IPCHAINS-HOWTO on www.linuxdocs.org, it's very easy and fast to learn.

Also can you access your webserver right now? or you just can't get your mysql server?
# 4  
Old 04-22-2002
I can access my webserver just fine. It's just accessing the database through an applet is not working. And I think it has something more to do with Apache and less to do with Linux.
# 5  
Old 04-22-2002
It could be that you don't have the correct permissions or something of that sort in either apache or mysql server, check their READMEs or check out their sites for the problems you are having.

Personally I'm just learning the mysql administration and going to use it with PHP, so I don't think there's anything I could help with at this moment.

Cheers

Previous Thread | Next Thread
Test Your Knowledge in Computers #34
Difficulty: Medium
When a computer is first powered on, the special type of absolute loader is known as the pre-boot loader.
True or False?

10 More Discussions You Might Find Interesting

1. Cybersecurity

Blocking 3306 with iptables -A INPUT -p tcp --dport 3306

Just added these lines to our server firewall: iptables -A INPUT -p tcp --dport 3306 -s 127.0.0.1 -d 127.0.0.1 -j ACCEPT iptables -A INPUT -p tcp --dport 3306 -j DROP Even though mysql is configured to correctly only listen on port 127.0.0.1 we still see these mysql log file notes on a daily... (0 Replies)
Discussion started by: Neo
0 Replies

2. Solaris

Ssh Connection refused port 22

Hello everybody, I'm a begginer using Solaris so I really need your help. I'm trying to copy a file using scp from a Red Hat Linux 6 server to an Oracle Solaris 11 machine and all i get is an error "" ssh: connection to host <HOST_IP> port 22: Connection refused lost connection. Thanks for... (6 Replies)
Discussion started by: limaco82
6 Replies

3. IP Networking

Tcp ip port open but no such process (merged: Release A Port)

i want to kill a tcp connection by killing its pid with netstat -an i got the tcp ip connection on port 5914 but when i type ps -a or ps-e there is not such process running on port 5914 is it possible that because i do not log on with proper user account i can not see that process running? (30 Replies)
Discussion started by: alinamadchian
30 Replies

4. Linux

IP Tables Add Open Port 3306

Hi, Anyone can help me on how to open a port 3306 on Centos 5 for my localhost (127.0.0.1), currently I have the list iptables -L; Chain INPUT (policy ACCEPT) target prot opt source destination RH-Firewall-1-INPUT all -- anywhere anywhere Chain FORWARD (policy ACCEPT) target prot opt... (7 Replies)
Discussion started by: fspalero
7 Replies

5. Shell Programming and Scripting

connection to mysql

is there some way i could connect to a remote mysql server from bash script (7 Replies)
Discussion started by: born
7 Replies

6. Shell Programming and Scripting

Mysql command after a SSH connection (Script)

Hi all, Im new at scripting and i need to run a few commands at work every hours so i decide to make a script but on 1 of the steps i have a the follwoing problem: The command i do is this: #!/bin/bash ssh root@asdasd001 'mysql -h A-db-1 -uroot -password --execute "show slave status"'... (3 Replies)
Discussion started by: Aparicio
3 Replies

7. UNIX for Dummies Questions & Answers

Terminate a port connection

I have executed a command which has ports that have to be assigned. then I deleted the files. Now I need to reinstall the command. but it says the ports are not free How to terminate the port connections and reinstall in solaris unix ---------- Post updated at 09:07 PM ----------... (7 Replies)
Discussion started by: sriki32
7 Replies

8. IP Networking

Unknown open port: "6881/tcp open bittorrent-tracker" found with nmap

Hi. I ran nmap on my server, and I get the following: Starting Nmap 4.76 ( http://nmap.org ) at 2009-03-19 16:33 EDT Interesting ports on -------- (-----): Not shown: 997 closed ports PORT STATE SERVICE 22/tcp open ssh 80/tcp open http 6881/tcp open bittorrent-tracker The... (0 Replies)
Discussion started by: Rledley
0 Replies

9. Programming

Cloning a socket connection, using other port numbers

Hello everybody, I've coded a multi-client server based on internet sockets using the scheme listen on port X-accept-fork, exactly like beej's guide At some point I would like to establish a secondary connection between a client and the server-child serving him. I was considering the... (4 Replies)
Discussion started by: jonas.gabriel
4 Replies

10. UNIX for Dummies Questions & Answers

How to check the TCP/UDP port of a connection

Hi, Users are connecting thru a KCML Client to UNIX machine, and I want to know which TCP/UDP port that client uses? How can I check the port of a user logged in? Regards, Tayyab (2 Replies)
Discussion started by: tayyabq8
2 Replies

Featured Tech Videos