Muffinresearch Labs by Stuart Colville

MySQL Tools from MySQL AB | Comments (0)

Posted in Code on 27th January 2005, 11:17 am by Stuart

I’ve used PHPMyAdmin for a long time for all my MySQL administration needs. However, I recently discovered the MySQL tools the MySQL query browser and the MySQL Administrator.

Together these do pretty much everything PHPMyAdmin can do and I have found that they provide an alternative to other software like MySQL-Front too.

The MySQL query browser is great for working on complex queries with features such as; tabbed views, query history, query comparison, and the best animated dolphins you’ve ever seen!

The MySQL admin tool provides a lot of useful information on the current running status of your MySQL server as well as user management and a great back-up and restore feature.

The next question is do they work remotely? Fortunately the answer is yes for SSH equipped machines. Simply download a copy of PuTTY and set up a tunnel for port 3306. That way you can securely access your MySQL database securely via SSH.

Post Tools

Comments: Add yours







XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>



GNU screen: open tab in current working directory|(1)

A nice trick for having screen open a new tab in the same directory as the one you’re currently in. To use it add it to your .screenrc

# Open new window in current dir.
bind c stuff "screen -X chdir \$PWD;screen^M"
bind ^c stuff "screen -X chdir \$PWD;screen^M"

Hat tip: mteckert on SuperUser.com

Ubuntu: add-apt-repository: command not found|(2)

When you’re using a minimal Ubuntu install if you find the ‘add-apt-repository’ command is missing (it’s useful for adding PPAs and other repositories), then simply run:

sudo apt-get install python-software-properties

Photos on Flickr

© Copyright 2004-12 Stuart Colville, all rights reserved. May contain traces of Muffin. Powered by WordPress. Hosting by Slicehost.com This page was baked in 0.482s.