Solved

Access a mysql db from another computer.

Posted on 2011-03-18
7
449 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
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
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…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

911 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now