Avatar of taaz
taaz
 asked on

tcp : port

I ran the command

#netstat -a |grep 3306
#
netstat -a |grep 8229
tcp         0         0 *:8229                                   *:*                                                       LISTEN


what does the above shows?  please quick reply be greatly greatly appreciated
MySQL ServerLinuxUnix OS

Avatar of undefined
Last Comment
Kerem ERSOY

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
pilson66

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
pilson66

this means that daemon listen port 8229
to show about process name - run "netstat -nltp"
taaz

ASKER
So the port 8229 is available ?
pilson66

some process is listen this port
so, if this port is not blocked with firewall - yes, port is available.
Your help has saved me hundreds of hours of internet surfing.
fblack61
taaz

ASKER
On the slave

SHOW SLAVE STATUS\G;

I am getting   Slave_IO_Running: No

I am running short of time need urgent help to this issue
Kerem ERSOY

Hi,

The first thing hre is your MySQL daemon is not listening to the port 3306. But some application is listening to the port 8229. If you want to know what application is listening to the port please issue the command and post the outpt here:

netstat -anpt | grep 8229

Cheers,
K.
rabbid_dog

No

The port is being used by something.
And it is listening on every ip address you have on your server, or computer.

Type
netstat -tunap

This will give you more information about which processes are using which ports.
Also you can try
lsof -c mysqld |grep -i TCP
root@mx2:~# lsof -c mysqld |grep TCP
mysqld    3376 mysql   13u  IPv4      14377                 TCP *:3306 (LISTEN)

Open in new window

or
lsof -i TCP:3306
root@mx2:~# lsof -i TCP:3306
COMMAND  PID  USER   FD   TYPE DEVICE SIZE NODE NAME
mysqld  3376 mysql   13u  IPv4  14377       TCP *:3306 (LISTEN)

Open in new window

Replacing with whichever port number you need
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
taaz

ASKER
netstat -anpt | grep 8229
tcp       0      0  0.0.0.0:8229                                  0.0.0.0:*                      LISTEN                3167/mysqld
taaz

ASKER
I ran the following on the slave  in the MYSQL MASTER/SLAVE
 
netstat -anpt | grep 8229
tcp       0      0  0.0.0.0:8229                                  0.0.0.0:*                      LISTEN                3167/mysqld
taaz

ASKER
lsof -c mysqld |grep TCP   does give me
command not  found

lsof -i  TCP:3306    dos not run either
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
SOLUTION
Kerem ERSOY

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
taaz

ASKER
Ok I will chang port to default 3306 on the master and will try

can you tell me how to check the firewall setting
the OS: Linux
pilson66

iptables-save
Kerem ERSOY

> Ok I will chang port to default 3306 on the master and will try

Do you need instructions on hosw to do this?

> can you tell me how to check the firewall setting
> the OS: Linux

What distro are you using ? I'll send you the specific instructions on how to make them permanent when you tell me what distro are you using ..

As a rule of thumb this will show the active rules:

iptables -L -n
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Kerem ERSOY

It seems to me that probably somebody messed with the default settings in your /etc/services file to change the default port of mysql.

edit your /etc/services and find these lines:

mysql           8229/tcp                        # MySQL
mysql           8229/udp                        # MySQL

and make sure it reads:

mysql           3306/tcp                        # MySQL
mysql           3306/udp                        # MySQL

Save the file and restart your mysql daemon. Then it should start at port 3306 now..

pmasotta

changing mysql port
http://www.cyberciti.biz/faq/change-default-mysql-port-under-linuxunix/

if you are connecting the sql server to internet using mysql on the default port w/o any firewall controll is not really a good idea.
taaz

ASKER
on the master

cd /etc
cat services |grep mysql

mysql                 3306/tcp                          #MySQL
mysql                 3306/udp                         #MYSQL

On the Slave

cd /etc
cat services |grep mysql

mysql                 3306/tcp                          #MySQL
mysql                 3306/udp                         #MYSQL

 
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
pmasotta

and what is indicated at the server file

/etc/my.cnf

port=3306  or port= 8229     ????
taaz

ASKER
It is port 3306 on my.cnf  of both the servers (Master and Slave)


SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
taaz

ASKER
On the Master

netstat -anpt | grep mysqld

tcp                     0                   0  0.0.0.0:3306          0.0.0.0:*           LISTEN    2766/mysqld


on the slave

netstat -anpt | grep mysqld

tcp                     0                   0  0.0.0.0:3306          0.0.0.0:*           LISTEN    2781/mysqld

 
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
pmasotta

well now the port changed to the default mysql port 3306  

try to connect the client to the server then...
taaz

ASKER

I can open a new question for the error I am getting
Getting the error

from slave when I

show slave status\G;

i am getting

Slave_io_running: No
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
taaz

ASKER
I will just say Thank You to pmasotta,KeremE and Pilson66

you all are exceptional I am really thankful to you all.

I got the thing running after
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Kerem ERSOY

you're welcome taaz.