How To Install Mysql Administrator In Windows
On this page
- Installing MySQL Administrator Tool To Connect To Remote Databases
- Installing MySQL Administrator
- Using MySQL Administrator
This tutorial provides step-by-stride instructions on how to install MySQL Admin tool on an Ubuntu eleven.04 system and how to connect to a remote host with it. This should likewise piece of work on nigh Debian based operating systems.
I do not consequence any guarantee that this will work for y'all!
Installing MySQL Administrator
Kickoff we discover out the name of the tool using command line.
apt-enshroud search mysql | grep admin
This tells united states of america that the bundle we are looking for is chosen...
mysql-admin - GUI tool for intuitive MySQL assistants
Then we install it with command...
sudo apt-get install mysql-admin
You lot can at present commencement it from the 'Programming Menu',
Using MySQL Ambassador
Because almost all MySQL servers have a firewall protecting the port 3306 we must kickoff create a tunnel to access the MySQL server on the remote host. Therefore we create a tunnel to connect to a MySQL server using SSH with this control...
ssh -L 7777:localhost:3306 [electronic mail protected]
Now our local port 7777 should listen to the database server'south port 3306 where MySQL usually resides. Let's see if this is truthful. (Yous might likewise want to give this command on the remote host.)
netstat -tapn
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address Land PID/Program name
tcp 0 0 0.0.0.0:22 0.0.0.0:* Mind 852/sshd
tcp 0 0 127.0.0.1:7777 0.0.0.0:* LISTEN 22324/ssh
tcp 0 0 127.0.0.ane:7777 127.0.0.i:59683 ESTABLISHED 22324/ssh
tcp6 0 0 :::22 :::* LISTEN 852/sshd
tcp6 0 0 ::1:7777 :::* Listen 22324/ssh
As we can run across our localhost IP address 127.0.0.ane is listening to port 7777. As well tcp6 is doing and so on 0 ::1.
Now all we accept to exercise is use the tunnel to gain access to the remote DB server. Depending on your host file configuration you might have to use a different name for your local PC.
I used the TCP five.6 name localhost6 to connect to my local port 7777. Normally you desire to use either localhost or 127.0.0.1 for the connexion.
Start your MySQL Administrator and connect to the remote host.
Connect with the local IP accost 127.0.0.ane:
Connect with local address localhost6:
Connectedness fault. Cheque your localhost name and or your username/countersign.
This is what a successfull connectedness looks similar.
Suggested articles
This feature is just available to subscribers. Go your subscription here.
Source: https://www.howtoforge.com/installing-mysql-administrator-tool-to-connect-to-remote-databases
Posted by: criderencity.blogspot.com
0 Response to "How To Install Mysql Administrator In Windows"
Post a Comment