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
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
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
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%/b
*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.
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%/b
*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.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial