Access Your MySQL Server Remotely Over SSH

So you’ve got MySQL on your web server, but it’s only opened to local ports by default for security reasons. If you want to access your database from a client tool like the MySQL Query Browser, normally you’d have to open up access from your local IP address… but that’s not nearly as secure.

So instead, we’ll just use port-forwarding through an SSH tunnel, so your MySQL client thinks it’s connecting to your localhost machine, but it’s really connecting to the other server through the tunnel.

If you are using the command line ssh, the command would look like this. (You can do the same thing graphically in Putty or SecureCRT options if you need to)

ssh -L 3306:localhost:3306 geek@webserver.com

The syntax is ssh -L <localport>hostname<remoteport> <username>@<servername>. We’re using localhost as the hostname because we are directly accessing the remote mysql server through ssh. You could also use this technique to port-forward through one ssh server to another server.

If you already have mysql running on your local machine then you can use a different local port for the port-forwarding, and just set your client tools to access MySQL on a different port.

Once you’ve got the ssh tunnel going, you can open up MySQL Query Browser and enter in the details for your remote server, using localhost as the server host, and adjust the port to whatever you used.

iPorn App Pulled for Causing Server Meltdown

he internet is today buzzing with talk about the iPhone’s very first adult application to hit the App Store.

Zoom

Originally only showing pictures of women in lingerie or bikinis, the developers of Hottest Girls this week uploaded more pictures (bringing the total to over 2,200) which include topless and semi-nude photos.

When asked for comment, Apple said it was considering its response to the reaction received by Hottest Girls. Now that the application has disappeared from the App Store, folks are wondering if Apple pulled the application because of bad pad press.

However, according to the developer, popular demand is the reason the application is no longer available. Oh and don’t worry, the boobie buffet will still be there once it goes back online.

“The Hottest Girls app is temporarily sold out. The server usage is extremely high because of the popularity of this app. Thus, by not distributing the app, we can prevent our servers from crashing. Those who already have the app will still be able to use our app. To answer the question on everyone’s mind: Yes, the topless images will still be there when it is sold again. -ATG dev team”

HTC Hero hands-on: Flash, keyboard and ruminations

We’re going to need some real time with the device to make a final opinion, but we’re cautiously optimistic that HTC has a winner with its new Hero. Here’s what we’ve got from our first looks at the phone in London and NY:

  • The beveled edges along the back makes the handset sit comfortably in the hand, and while the teflon coat doesn’t necessarily **feel revolutionary, it’s going to make a world of difference after a couple of months riding in our grubby pockets. It’s certainly solid, but much more so than other «brick» phones.
  • The Sense UI (or as HTC terms it, «user experience») riding a capacitive touchscreen offers a people-centric approach to managing your information that is absolutely dreamy at first blush — though it shares a lot of TouchFLO heritage.
  • The on-screen keyboard also seems quite useable with a nice simulated haptic forced-feedback bounce when you strike each key in either landscape or portrait mode (which can naturally be deactivated). HTC has built its own touch keyboard from the ground up, and in our brief couple of tests we’d say it’s probably the best touchscreen typing experience we’ve ever felt. It never lags behind, and has great colorful visual cues for its auto-corrected words — green means it’s suggesting a correctly spelled word, red means we’ve gone off the beaten path, and the T9-style multiple suggestions are heavenly.
  • This intuitive one-hander isn’t shy with the specs either as we’ve already seen in the official press release. Our only concern is possible sluggishness from the Qualcomm processor that cause the graphic transitions to stutter a bit and results in screen rotations that feel dangerously uncomfortable.
  • We were told that the device we saw was running pre-production firmware so there’s still time to tweak — though not much with a July European launch.
  • The Hero is not a «Google Experience» device. As such, you won’t find the Google logo anywhere (no big deal) but you also won’t be downloading any firmware updates over the air — sideloading only kids. Not a deal breaker but an annoying and seemingly arbitrary limitation nonetheless. There’s still a small lack of clarity of how updates will work with HTC’s «mods» living on top of basic Android — even if they’re able to port in new Android versions seamlessly, we imagine there will be some breakage.
  • For a device without a physical keyboard, the Hero seems a little thick up against its HTC Magic, Nokia N97, and iPhone 3G counterparts, but not overly so.
  • HTC has confirmed that whichever (unspecified) carrier gets the phone in the US will have a modified version, both in software (carrier-specific services) and in hardware chassis tweaks. Just don’t take our teflon away, ok HTC?
  • The phone will be available for free on T-Mobile UK — if only we could be so subsidy lucky in the US.

There are four videos for you after the break. The first shows Flash running at full screen on the HTC Hero courtesy of YouTube. The second, however, shows it failing when running a trailer from Yahoo Movies, just like Adobe did — in fact, it crashed all four times that we tried it on what we were told was a Hero running the final build of the OS. Third one is a quickie showing the on-screen keyboard rotating from portrait to landscape and back. Lastly, we demonstrate the hardware a little bit and show off our lightning speed at typing. For the real completists, there’s also a new gallery of hands-on shots from the NY launch event right below.

Palm Pre How To Guide – Enable Tethering Over Bluetooth!

Credit goes to fish199902 for this one.  Basically, you setup an SSH tunnel to the Pre, which supports running as a SOCKS proxy.  You then configure your browser to point to this proxy and BAM, you’re tethering away.

First, you must have rooted your Pre and installed/enabled SSH.

Connect to your Pre’s NAP (network access point) via Bluetooth:

Connect to Pre NAP to Tether

Ignore this error message on your Pre:

Ignore Pre Tether Error Message

Using PuTTY, configure the following settings under Connection -> SSH -> Tunnels:

  • Source port: 8080
  • Destination: Dynamic and Auto radio buttons
  • Click Add and you’ll see the port in the “Forwarded ports” box

Pre Tether Putty Setup


Then, initiate the SSH connection to your Pre.  Going through Bluetooth and using port 222, your connection window will look like this:

Pre Tether through SSH SOCKS proxy

Once you’re at the login screen, configure your browser’s SOCKS proxy with:

  • Address: localhost
  • Port: 8080

Pre Tether IE7 SOCKS Proxy Setup

Now you’re good to go!

Microsoft ZUNE HD

Microsoft’s just sent out a press release (after the break) and launched an official Zune HD page.

The Zune HD is real, and it’s coming this Fall. Microsoft officially announced the next iteration in their Zune line today, making it less of a tripped out pipe dream, and more of a totally tubular reality. The specs, which look exactly like that leak we saw, go like this: 3.3-inch, 480 x 272 OLED capacitive touchscreen display, built-in HD Radio receiver, HD output (utilizing a new dock — not on-board), and… not much more right now. Microsoft is doing away with the famed squircle in favor a full multitouch device, and they seemed to indicate that some new touch-friendly apps and games would be headed our way, though they were fairly mum when it came to details. The device will boast an IE-based, customized browser, but little else was said in the way of software.

Details are also scarce concerning storage capacities, CPU performance, and other crucial numbers, but it seems like they’ve got more in store come E3… and that’s the next big piece of news. Zune integration is coming to the Xbox and Xbox Live, as the Zune marketplace will step in to replace the current Live video resources, expanding the library and offering all kinds of new perks, like Zune’s first foray into international waters. According to the company, at E3 «attendees will see first-hand how Zune integrates into Xbox LIVE creating a game-changing entertainment experience» — we’re not entirely sure what the means right now, but it sounds sweet. Try to contain your excitement.

Picture of black Zune HD, now after the break, which Microsoft is giving out to selected «Zune MVP» sites such as Inside the Circle and ZuneTracks.

HP Mini 1101

HP’s got more additions to its Mini netbook lineup coming your way with the 1101 and 110 XP / Mi. All three models sport a 10.1-inch widescreen LED, autosync software for easier connectivity to your primary PC, and the standard 1.6 GHz Intel Atom N270 / 1.66GHz N280 processor options with GMA 950 graphics, VGA output, 3 or 6 cell batteries, and 802.11b/g.

The Mini 110 XP edition takes the trend even further with — and we’re sure you’re surprised here — 1GB RAM and 160GB HDD or 32GB SSD, as well as optional WWAN and a Broadcom Crystal HD Enhanced Video Accelerator, which HP claims will let you watch 1080p video smoothly — yeah, we’ll believe it when we see it. Those who go with the company’s Linux-based pet Mi can bump up to 250GB HDD and 2GB memory. As for the Mini 1101, it looks like it’s basically the business-centric 110 with XP and Vista as your OS choices and no apparent video enhancer. As for pricing and availability, the Mini 1101 is coming at ya on June 1st with a base price of $329, while Mini 110 will follow shortly after in black swirl on June 10th, and white swirl / pink chic on July 8th. Those will start at $279 with Mi and $329 if you want Windows XP instead.