Solved

Access a mysql db from another computer.

Posted on 2011-03-18
7
455 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
Certified OpenStack Administrator Course

We just refreshed our COA course based on the Newton exam.  With 14 labs, this course goes over the different OpenStack services that are part of the certification: Dashboard, Identity Service, Image Service, Networking, Compute, Object Storage, Block Storage, and Orchestration.

 
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

Flexible connectivity for any environment

The KE6900 series can extend and deploy computers with high definition displays across multiple stations in a variety of applications that suit any environment. Expand computer use to stations across multiple rooms with dynamic access.

Question has a verified solution.

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

Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
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…

632 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