MySQL Server 8.0 远程数据库 [英] MySQL Server 8.0 remote database

问题描述

我从超过 5 天的时间里开始尝试这个，我感到非常沮丧.我需要在我的 PC 上创建数据库，该数据库必须对同一 LAN 中的所有其他 PC 可见.

I am very frustrated that I am trying this from over 5 days. I need to create database on my PC that has to be visible for all other PCs in the same LAN.

我尝试使用 XAMPP - Apache + MySQL - 即使在阅读了谷歌前 2 页的所有文章并观看了许多 YouTube 剪辑后，也没有结果.现在我正在我的 PC 上尝试使用 MySQL Server 8.0.我再次尝试了所有谷歌首页的内容，但没有结果.我怎样才能做到这一点?

I tried with XAMPP - Apache + MySQL - no result even after reading all articles from first 2 pages of Google and watching many youtube clips. Now I am trying with MySQL Server 8.0 on my PC. I tried again all of Google first pages stuff without result. How can I do that?

我知道这里已经问过很多次了，但根本没有复杂的解决方案.

I know that this has been asked many times here but there is no complex solution at all.

你们中有人有现在经过测试并且有效的教程吗?

Does anybody of you have tutorial that is tested nowadays and it is working?

推荐答案

问题出在连接字符串上.

The problem was in connection String.

static final String USERNAME="[用户名]";static final String PASSWORD="[密码]";static final String CONN_STRING="jdbc:mysql://[ip-address]:[port]/[database-name]";

static final String USERNAME="[username]"; static final String PASSWORD="[password]"; static final String CONN_STRING="jdbc:mysql://[ip-address]:[port]/[database-name]";

所以正如刘悦建议的那样，我刚刚授予了这个用户名的访问权限.问题是我的另一台计算机的名称不同.

So as LIU YUE suggested I just granted access for this username. The problem was that my other computer has a different name.

这篇关于MySQL Server 8.0 远程数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！