How to access the database of mysql from another computer?

Question

0.00/5 (No votes)

See more:

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.

Posted 25-Feb-16 20:18pm

Member 12265307

Updated 25-Feb-16 20:31pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

koolprasad2003 · Answer 1 · 2016-02-25T20:29:00

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

C#

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

Specifying TCP port

C#

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

OriginalGriff · Answer 2 · 2016-02-25T20:31:00

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!

How to access the database of mysql from another computer?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0