如何从另一台计算机访问mysql数据库？ [英] How to access the database of mysql from another computer?

问题描述

我有两个用户，即admin和student用户。现在我的问题是，如何将数据从数据库检索到我的服务器计算机到另一台计算机？我真的需要知道这个，谢谢。



我尝试了什么：



我试图包括服务器的端口和服务器或ip，但它没有用，请帮助我。

I have two user, the admin and the student user. Now my question is, how to retrieve the data from database to my server computer to another computer? I really need to know this one, thanks.

What I have tried:

I tried to include the port and server or ip of the server but it didnt work, please help me.

推荐答案

你问题的答案是连接字符串，在连接字符串的帮助下，您可以连接到网络中的任何数据库

查看下面的MYSQL连接字符串

Answer for your question is connection string, with the help of connection string you can connection to any database in your network
look at below connection string for MYSQL

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

指定TCP端口

Specifying TCP port

Server=myServerAddress;Port=1234;Database=myDataBase;Uid=myUsername;
Pwd=myPassword;

我们不能告诉你 - 但是如果它们都在同一个局域网上，或者MySql服务器可以通过互联网，这只是一个让你的连接字符串正确的情况。

从这里开始： ConnectionStrings.com - 忘记连接字符串？在这里获取它！ [ ^ ]，看看你能解决什么问题。我们在这里无法帮助您 - 每个字符串都是特定于您的安装，以及您将使用的数据库用户，我们不知道您的服务器在哪里，更不用说连接它的能力了！

We can't tell you - but if they are both on the same LAN, or the MySql server is accessible via the internet, it's just a case of getting your connection string right.
Start here: ConnectionStrings.com - Forgot that connection string? Get it here![^] and see what you can work out. We can't help you here - each string is specific to you installation, and to the DB users you will be using, and we have no idea where your server is, much less the ability to connect to it!

这篇关于如何从另一台计算机访问mysql数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！