Solved

Access a mysql db from another computer.

Posted on 2011-03-18
7
450 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
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

In Solr 4.0 it is possible to atomically (or partially) update individual fields in a document. This article will show the operations possible for atomic updating as well as setting up your Solr instance to be able to perform the actions. One major …
I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension (http://www.experts-exchange.com/discussions/210281/Attachments-with-no-extension.html). This reminded me of questions tha…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

803 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