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

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

How to access the database of mysql from another computer?

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us