MySQL Query Browser is a part of MySQL database product from MySQL (now it owned by Oracle,Inc.). It is a GUI tool to run MySQL Query and get the result on pretty field-way view. MySQL Query browser mostly used by administrator on it own server, altough it can be managing a remote database query. Here is the how-to:
1. Install the MySQL Query Browser with urpmi on Mandriva 2010.1
[sourcecode language=”bash”]
urpmi –auto-update
urpmi mysql-query-browser
[/sourcecode]
2. Now, run the terminal/Konsole.
3. Login to your MySQL remote server with SSH Tunneling, just type it on your console:
[sourcecode language=”bash”]
ssh -L 3307:127.0.0.1:3306 your_user@sql.remoteserver.com
[/sourcecode]
type your correct tunneling password (use FTP or SFTP password)
4. Run the MySQL Query Browser (KDEMenu -> Development -> Databases -> MySQL Query Browser)
5. Fill the field on Connection dialog, Use 127.0.0.1 (or your defined) as IP, 3307 as the Port, username, password and default schema (default databases, or just leaved it blank to view all databases)
6. Click the Connect button,
7. Viola! You just runned it to Remotely Database somewhere! Mazel tov, and Wassalamualaikum dude!
