Sponsored Content
Full Discussion: iptables - allow MySql
Top Forums UNIX for Advanced & Expert Users iptables - allow MySql Post 303015682 by damogallagher on Tuesday 10th of April 2018 06:49:18 AM
Old 04-10-2018
Quote:
Originally Posted by stomp
Seems that the mysqld listening to all interfaces. That one checked and fine.

---

Please check if the mysql-port is open from the machine from which you are trying to connect:

Code:
nmap -p3306 -P0 ip.of.mysql.server

Check/Show your complete firewall rule set(iptables -L -v n):
This is the result of running the nmap command
Code:
Host is up.
PORT     STATE    SERVICE
3306/tcp filtered mysql

 

5 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

MySQL problem >> missing mysql.sock

MySQL on my server is down.... I figured out that the mysqld process isn't running. When I try to run it, it says it can't find mysql.sock Any suggestions? Here's what I can't do: can't be root don't have physical access (do stuff via SSH) reinstall MySQL (need to keep the current MySQL... (8 Replies)
Discussion started by: _hp_
8 Replies

2. UNIX for Advanced & Expert Users

mysql would not start: missing mysql.sock

I recently installed mysql-standard-5.0.21-solaris9-sparc-64bit.pkg on a Solaris 9 machine (SunOS 5.9 Generic_118558-19 sun4u sparc SUNW,Ultra-250). The package installation went very smooth, however, starting mysql is a different story. I get the message below everytime I try to start mysql: #... (2 Replies)
Discussion started by: xnightcrawl
2 Replies

3. Red Hat

MySQL conflicts with mysql-3.23.58-16.RHEL3.1

I am tring to install mysql 5.0 on redhat linux3. In this server mysql 3 is already installed and hence while I install mysql 5 it gives the following error. How I can install mysql 5 with out affect previous installation? bash-2.05b# rpm -i MySQL-server-community-5.0.41-0.rhel3.i386.rpm... (2 Replies)
Discussion started by: johnveslin
2 Replies

4. UNIX and Linux Applications

MySQL Daemon failed to start - no mysql.sock file

After doing a yum install mysql mysql-server on Fedora 14 I wasn't able to fully install the packages correctly. It installed MySQL 5.1. I was getting the following error when running the: mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)... (3 Replies)
Discussion started by: jastanle84
3 Replies

5. IP Networking

Iptables Log in mysql

Hello all friends I am using ulogd with iptables to import iptables log into mysql but it is not working , Is there any way to log iptables log into mysql , i am using centos 6 Thanks (0 Replies)
Discussion started by: rink
0 Replies
SAFE_MYSQLD    (1)						     mysql.com							SAFE_MYSQLD    (1)

NAME
safe_mysqld - start the mysqld daemon on Unix. SYNOPSIS
safe_mysqld [--basedir=path] [--core-file-size=#] [--defaults-extra-file=path] [--defaults-file=path] [--open-files=#] [--datadir=path] [--err-log=path] [--ledir=path] [--log=path] [--no-defaults] [--open-files=#] [--pid-file=path] [--port=#] [--socket=path] [--timezone=#] [--user=#] DESCRIPTION
safe_mysqld adds some safety features such as restarting the server when an error occurs and logging run-time information to a log file. --basedir=path --core-file-size=# --defaults-extra-file=path --defaults-file=path --open-files=# Size of the core file mysqld should be able to create. Passed to ulimit -c. --datadir=path --err-log=path --ledir=path Path to mysqld --log=path --no-defaults --open-files=# Number of files mysqld should be able to open. Passed to ulimit -n. --pid-file=path --port=# --socket=path --timezone=# Set the timezone (the TZ) variable to the value of this parameter. --user=# NOTE
Note that all options on the command line to safe_mysqld are passed to mysqld. If you wants to use any options in safe_mysqld that mysqld doesn't support, you must specify these in the option file. SEE ALSO
isamchk (1), isamlog (1), mysqlaccess (1), mysqladmin (1), mysqlbug (1), mysqld (1), mysqldump (1), mysqlshow (1), msql2mysql (1), perror (1), replace (1), safe_mysqld (1), which1 (1), zap (1), AUTHOR
Ver 1.0, distribution 3.23.29a Michael (Monty) Widenius (monty@tcx.se), TCX Datakonsult AB (http://www.tcx.se). This software comes with no warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mer- curmedia.com) safe_mysqld (mysql) 19 December 2000 SAFE_MYSQLD (1)
All times are GMT -4. The time now is 01:48 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy