Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 353
  • Last Modified:

MYSQL: How to read the queries PHYSICALLY and REMOTELY

Hi,

I am interested in MYSQL. I just completed the installation of MYSQL.

Note:
-It is a the simulation of Enterprise Network
- I installed the MYSQL (at the Windows XP which are located at LAN 1 ¿ 10.10.10.0/24; I assigned the IP address of this XP is 10.10.10.50)
- The setup of MYSQL (at Win XP) is Server type (Not Custom or Client type)
-I have a Win 7 at LAN 2 (10.10.5.0/24)
- Both machines are in a Domain called "Boba.com"

The Goal:
-First: I want to READ the queries PHYSICALLY from Windows XP itself
- Second: I want to READ the queries REMOTELY from Windows 7 (from LAN 2)

Somebody would tell me how to do the above 2 goals? Would you provide a little bit of details please. The Helps that I need:
- How to create the Users? (Is it a domain user? or local user?)
-At XP, I should use the Domain User or Local User?
- Please provide the PATH how to CREATE and READ the QUERIES

Thank you

tjie
0
tjie
Asked:
tjie
1 Solution
 
F IgorCommented:
First of all, having your MySQL server running at 10.10.10.50, each computer (including the server itself ) can connect and query to that server in the same way (All databases and data are stored in a single server, but accessible from every computer that connects)

You need to ensure that Mysql Server can be reached from another computer if:
* In the mysql configuration (my.cnf file ) the following line is commented (with ";") or removed (otherwise, you can only connect from the server itself)

;bind-address=127.0.0.1

*The firewall configuration of that server allows to connect at TCP port 3306 (In windows XP, when you install and run the server a confirmation dialog should appear to confirm)

*For managing users, you can use the mysql administration utility that comes with the server (in folder %MYSQL_INSTALLATION_DIR%/bin/)

*Then , you need a Mysql FrontEnd / GUI to manage users and queries easily (instead of using the mysql console to do that) For example, Mysql Workbench

http://dev.mysql.com/downloads/workbench/

And use this tool from another computer to connect using the root user:

host: 10.10.10.50
user: root
pass: when you install mysql it asks for it. Use that password.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now