FileZille连接阿里云实例 fzSftp started, protocol_version=8 错误: 无法连接到服务器

本文介绍了解决阿里云MySQL连接问题的方法,包括创建新用户、设置端口、配置实例安全组及服务器防火墙等步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

如图:解决方案

1、不能直用root用户连接(不知道是不是阿里云的限制),于是新建了一个用户,设置了新的端口。

2、在阿里云的实例安全组中开放该端口(这步完成后可以试试能不能连接了,如果可以,请忽略3、4步骤)


3、在服务器防火墙中开放该端口

vim /etc/sysconfig/iptables  添加如下内容 (红色部分代表端口,需改成相应端口号)

# Firewall configuration written by system-config-firewall
# Manual customization of this file is not recommended.
*filter
:INPUT ACCEPT [0:0]
:FORWARD ACCEPT [0:0]
:OUTPUT ACCEPT [0:0]
-A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
-A INPUT -p icmp -j ACCEPT
-A INPUT -i lo -j ACCEPT
-A INPUT -m state --state NEW -m tcp -p tcp --dport 55555 -j ACCEPT
-A INPUT -j REJECT --reject-with icmp-host-prohibited
-A FORWARD -j REJECT --reject-with icmp-host-prohibited

COMMIT

4、service iptables restart 重启即生效


log.xml 内容: <msg time='2025-07-07T17:14:01.051+08:00' org_id='oracle' comp_id='tnslsnr' msg_id='dbgrmmdcrf_create_relation_full:1960:1503427940' type='NOTIFICATION' group='create' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124' version='2'> <txt>Create Relation ADR_CONTROL </txt> </msg> <msg time='2025-07-07T17:14:01.384+08:00' org_id='oracle' comp_id='tnslsnr' msg_id='dbgrmmdcrf_create_relation_full:1960:1503427940' type='NOTIFICATION' group='create' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>Create Relation ADR_INVALIDATION </txt> </msg> <msg time='2025-07-07T17:14:01.683+08:00' org_id='oracle' comp_id='tnslsnr' msg_id='dbgrmmdcrf_create_relation_full:1960:1503427940' type='NOTIFICATION' group='create' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>Create Relation INC_METER_IMPT_DEF </txt> </msg> <msg time='2025-07-07T17:14:02.001+08:00' org_id='oracle' comp_id='tnslsnr' msg_id='dbgrmmdcrf_create_relation_full:1960:1503427940' type='NOTIFICATION' group='create' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>Create Relation INC_METER_PK_IMPTS </txt> </msg> <msg time='2025-07-07T17:14:02.299+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt> LISTENER for 64-bit Windows: Version 19.0.0.0.0 - Production Version 19.3.0.0.0 </txt> </msg> <msg time='2025-07-07T17:14:02.299+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>System parameter file is D:\BaiduNetdiskDownload\WINDOWS.X64_193000_db_home\network\admin\listener.ora </txt> </msg> <msg time='2025-07-07T17:14:02.299+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>Log messages written to D:\Oracle\diag\tnslsnr\WIN-KJRHJTCG463\#\alert\log.xml </txt> </msg> <msg time='2025-07-07T17:14:02.299+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>Trace information written to D:\Oracle\diag\tnslsnr\WIN-KJRHJTCG463\#\trace\ora_6124_1704.trc </txt> </msg> <msg time='2025-07-07T17:14:02.299+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>Trace level is currently 0 </txt> </msg> <msg time='2025-07-07T17:14:02.299+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt> </txt> </msg> <msg time='2025-07-07T17:14:03.034+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>Started with pid=6124 </txt> </msg> <msg time='2025-07-07T17:14:03.043+08:00' org_id='oracle' comp_id='tnslsnr' type='UNKNOWN' level='16' host_id='WIN-KJRHJTCG463' host_addr='fe80::984b:79cc:a538:3775%15' pid='6124'> <txt>TNS-01151: Missing listener name, #, in LISTENER.ORA </txt> </msg>
最新发布
07-08
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值