当前位置：文江博客话题详情

MySQL Workbench无法连接到远程托管数据库，而错误re re localhost

发布于 2025-02-10 08:39:42 字数 1828 浏览 0 评论 0原文

MySQL Workbench在新的Windows 10笔记本电脑上使用新的安装，此软件以前尚未安装该软件，使用MySQL-WorkBench-Community-8.0.0.29-winx64.msi，并接受了向导中的所有默认值。

我为WordPress网站上托管的知识库创建了一个新的MySQL数据库。

WordPress和DB托管在以下位置：name.com
WordPress和DB托管：相同服务器
服务器IP：169.62.56.10
服务器Apache版本：2.4.53
服务器PHP版本：7.4.29
服务器体系结构：X86_64
服务器操作系统：Linux
DB服务器：Localhost通过UNIX套接字
DB服务器类型：MySQL
DB服务器版本：8.0.29 -MySQL社区服务器-GPL
DB端口：3306
DB模式：BECCA37_PS_KB
db用户：BECCA37_PS_KB_ADMIN，带有关联的密码
远程mysql：我将％添加为允许的主机（我当然会稍后将其摇动，但首先需要连接（S）完全工作：0））< /p>

，现在正在尝试连接到它。

（1）通过WordPress使用WPDataTables插件，作为单独的连接，而不是WordPress配置使用，因为这是使用单独的数据库架构而不是WordPess表。此方法可完美地工作。耶！

这两个不起作用。

我确定这是我做过或没有做的事情。几乎总是。：0）

我尝试关闭Windows防火墙，没有更改。

我还需要从环境终结中检查其他内容？配置？ ETC。？

注意：我对托管服务器或远程数据库本身没有其他

控制笔记本电脑。

我没有运行本地的MySQL服务器；我的理解是，如果我只想连接到远程托管的MySQL数据库，我就不需要。

连接方法：标准（TCP/IP）
主机名：如上所述
端口：如上
用户名：如上
密码：存储在Vault
中
默认架构中：如上所述

错误消息：

“您的连接尝试失败了用户的BECCA37_PS_KB_ADMIN'到MySQL Server，点169.62.56.10：3306：无法连接到LocalHost“

我尝试过运行MySQL WorkBench“作为管理员”，没有更改。

（3）通过HeidisQL根据其他帖子中的一些建议。

网络类型：Mariadb或MySQL（TCP/IP）
库：libmysql.dll（也使用libmysql-6.1.dll尝试，无更改）
hostName / ip上述< / p>
用户：如上< / p>
密码：输入
端口：如上所述
数据库：如上所述

错误消息：

“无法在'169.62.56.10'（10060）上连接到MySQL Server

原文

MySQL Workbench with a fresh install on a new Windows 10 laptop where this software has not been installed before, using mysql-workbench-community-8.0.29-winx64.msi and accepted all default values in the wizard.

I've created a new MySQL database for a knowledge base hosted on a WordPress website.

WordPress and DB Hosted At: Name.com
WordPress and DB Hosted On: same
server
Server IP: 169.62.56.10
Server Apache Version: 2.4.53
Server PHP Version: 7.4.29
Server Architecture: x86_64
Server Operating System: linux
DB Server: Localhost via UNIX socket
DB Server type: MySQL
DB Server version: 8.0.29 - MySQL Community Server - GPL
DB Port: 3306
DB Schema: becca37_ps_kb
DB User: becca37_ps_kb_admin, with associated password
Remote MySQL: I added % as an allowed host (I would, of course, like to crank this down later but first need the connection(s) working at all :0) )

And am now trying to connect to it.

(1) via WordPress for wpDataTables plugin use, as a separate connection than the WordPress config uses since this is using a separate database schema than the WordPess tables. This method is working flawlessly. Yay!

These other two are not working.

I'm SURE it's something I did or didn't do. Almost always is. :0)

I've tried turning off windows firewall, no change.

What are the other things I need to check from my environment end? Configuration? Etc.?

Note: I have no other control over the hosting server or remote database itself (e.g. no server-level config changes, etc., no database-level config or permission changes, etc., etc.)

(2) via MySQL Workbench from my laptop.

I do not have a local MySQL server running; my understanding is that I do not need that if I'm only wanting to connect to remotely hosted MySQL databases.

Connection Method: Standard (TCP/IP)
Hostname: as above
Port: as above
Username: as above
Password: stored in vault
Default schema: as above

Error Message:

"Your connection attempt failed for user 'becca37_ps_kb_admin' to the MySQL server at 169.62.56.10:3306: Unable to connect to localhost"

I've tried running MySQL Workbench "as administrator", no change.

(3) Via HeidiSQL based on some suggestions in others posts.