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
urpmi --auto-update urpmi mysql-query-browser
2. Now, run the terminal/Konsole.
3. Login to your MySQL remote server with SSH Tunneling, just type it on your console:
ssh -L 3307:127.0.0.1:3306 your_user@sql.remoteserver.com
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!
how to use mysql query browser, limesurvey tutorial, android query, setting remote mysql vb6, remote server database with mysql query browser, oracle query merubah nama kolom, mysql ssh tunneling, mysql query browser tool, mysql query, makalah tentang mysql query browser bahasa indonesia, how to query mysql remotely from, wordpress query on external mysql
Tulisan Terkait
Staff BPTIK Unnes, dan freelance programmer beberapa aplikasi berbasis VB6, PHP-MySQL, Java untuk Sistem Informasi, Plugin WordPress dan Plugin MOODLE. Bebas aktif sebagai Gusdurian, Nahdliyin dan simpatisan Partai Kebangkitan Bangsa dan Penggemar musik-musik karya Freddy Mercury QUEEN, Ahmad Dhani DEWA19 dan Piyu PADI serta penonton serial TV Stargate SG1, Ancient Aliens dan Mythbusters. 
No Comments on “How to use MySQL Query Browser on Remote Database on Mandriva”
You can track this conversation through its atom feed.