How to find the port used by mysql?

List the listening ports and check if mysql is listed on it. $ netstat -tln | grep mysql If you cannot find the port number for mysql view my.cnf file to see if you can find the port number. If you see a line "skip-networking" try commenting out the line and then restart mysql daemon. $ vi /etc/my.cnf [mysqld] set-variable=local-infile=0 datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1 skip-networking [mysql.server] user=mysql basedir=/var/lib [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid $ service mysqld restart