Solved

Access a mysql db from another computer.

Posted on 2011-03-18
7
453 Views
Last Modified: 2012-05-11
I have a linux server running mysql 5.1.49 on a network @ work.

I want to use Navicat, a dbms on another computer.

I can manage the database locally, how can I manage that db from another computer, using something like phpMyAdmin or Navicat ??
0
Comment
Question by:Imaginx
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 13

Expert Comment

by:dsmile
ID: 35165575
There're two ways to use phpMyAdmin
1. Install it on your db server and access it through the server public ip
Your server needs to have php & apache installed.
2. Install php on your computer and config it to access db sever through its public ip.
If you dont have an environment yet on your computer, you can use xampp or wamp server.

If you have navicat, use it to access db server through server's public ip .


One requirement for both public access way is to grant privileges for your local IP to access the server.
For mor info, just search google with keywords mysql, grant
0
 
LVL 1

Author Comment

by:Imaginx
ID: 35165635
That article may have the information I need, I'm just not sure that I'm understanding it...

(I have phpMyAdmin running on that server, I should have explained it better. NaviCat has some great import tools that are very useful for the project I'm currently on)

It seems as if GRANT just changes what the user account is allowed to do locally, or through a sql command.

Should the grant command be what I use to allow the administrator user account to log in 'remotely' per-se ... I'm using my mac laptop, and I'm not near the server (am on the same subnet) ...

Neither machine are joined to the local domain, just sharing the network ...

I can see the webserver from my laptop, but in navicat, when I use connection settings:
192.168.1.73:3306 - it can not connect. (3306 is the correct port)
0
 
LVL 12

Expert Comment

by:upanwar
ID: 35165642
By default mysql listen on Localhost so please follow this URL to enable remote connection to your mysql server.

http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html   
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 12

Expert Comment

by:upanwar
ID: 35165656
show us the output of.

# netstat -natp | grep 3306


0
 
LVL 1

Author Comment

by:Imaginx
ID: 35165735
the link you posted worked,
is there something in # netstat -natp | grep 3306 I should be cautious of ??
because it doesn't seem to return anything (ran sudo)
0
 
LVL 12

Accepted Solution

by:
upanwar earned 500 total points
ID: 35165824
If the link have worked and your issue has been fixed then no need to do anything.

I was just checking whether mysql is running on 3306 or not thats why I have asked for the output of # netstat -natp | grep 3306
0
 
LVL 1

Author Closing Comment

by:Imaginx
ID: 35165858
That's what I figured the command was for ... wasn't sure though. Thanks for the help
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question