2016-04-26 回答
默认端口是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