求教数据库主备，我设置了端口，但是在mysqld.log中的错误提示，说是使用的还是3306
在从机中，使用mysql -h192.168.0.70 --port=65000 -utslave -p登录show slave status时，提示错误： Last_IO_Error: error connecting to master 'tslave@192.168.0.70:65000' - retry-time: 60retries: 86400
之后查看mysqld.log日志发现： Slave I/O: error connecting to master 'tslave@192.168.0.70:3306' - retry-time: 10
retries: 86400, Error_code: 2013
在配置文件里我设置了端口也是65000，还有retry-time设置的是10，为什么在last_io_error里是60了
从机的my.cnf配置文件：
datadir=/var/lib/mysql
port = 65000
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
log-bin=mysql-bin
server-id=2
replicate-do-db=vds_am
replicate-ignore-db=mysql
replicate-ignore-db=information_schema
replicate-ignore-db=amh
replicate-ignore-db=performance_schema
log-slave-update
slave-skip-errors
master-host=192.168.0.70
master-user=tslave
master-password=123456
master-port=65000
master-connect-retry=10
页:
[1]