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
#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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
So the port 8229 is available ?
some process is listen this port
so, if this port is not blocked with firewall - yes, port is available.
so, if this port is not blocked with firewall - yes, port is available.
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
SHOW SLAVE STATUS\G;
I am getting Slave_IO_Running: No
I am running short of time need urgent help to this issue
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.
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.
No
The port is being used by something.
And it is listening on every ip address you have on your server, or computer.
Type
This will give you more information about which processes are using which ports.
Also you can try
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)
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)
ASKER
netstat -anpt | grep 8229
tcp 0 0 0.0.0.0:8229 0.0.0.0:* LISTEN 3167/mysqld
tcp 0 0 0.0.0.0:8229 0.0.0.0:* LISTEN 3167/mysqld
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
netstat -anpt | grep 8229
tcp 0 0 0.0.0.0:8229 0.0.0.0:* LISTEN 3167/mysqld
ASKER
lsof -c mysqld |grep TCP does give me
command not found
lsof -i TCP:3306 dos not run either
command not found
lsof -i TCP:3306 dos not run either
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
can you tell me how to check the firewall setting
the OS: Linux
iptables-save
> 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
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
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..
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..
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.
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.
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
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
and what is indicated at the server file
/etc/my.cnf
port=3306 or port= 8229 ????
/etc/my.cnf
port=3306 or port= 8229 ????
ASKER
It is port 3306 on my.cnf of both the servers (Master and Slave)
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
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
well now the port changed to the default mysql port 3306
try to connect the client to the server then...
try to connect the client to the server then...
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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
you all are exceptional I am really thankful to you all.
I got the thing running after
you're welcome taaz.
Linux
Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.
71K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
to show about process name - run "netstat -nltp"