liunx查询mysql数据库端口_linux系统怎么查找mysql所在端口

默认端口是3306

可以使用 ：netstat -anp|grep mysqld

如下

[mysql@localhost ~]$ netstat -anp|grep mysqld

(Not all processes could be identified, non-owned process info

will not be shown, you would have to be root to see it all.)

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

unix 2 [ ACC ] STREAM LISTENING 17761 6128/mysqld /tmp/mysql.sock

或者用 ps -ef|grep mysqld

[mysql@localhost ~]$ ps -ef|grep mysqld

mysql 6025 5997 0 18:51 pts/1 00:00:00 /bin/sh /usr/local/mysql/bin/mysqld_safe --user=mysql

mysql 6128 6025 0 18:51 pts/1 00:00:00 /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --log-error=/usr/local/mysql/var/localhost.localdomain.err --pid-file=/usr/local/mysql/var/localhost.localdomain.pid --socket=/tmp/mysql.sock --port=3306

可以查看到mysqld的启动参数信息， --port=3306

-------------------------------------------------------------------

ifconfig查看ip地址

然后远程登录的时候 执行

mysql -u root -p密码 -hmysql服务器的ip

取消

评论