MySQL Workbench 5.2.45 GA released

By Michael Zinner, Planet MySQLDecember 27, 2012 at 08:18PM

The MySQL developer tools team announces the availability of version 5.2.45 of the MySQL Workbench GUI tool. This version contains various fixes and minor enhancements and includes 72 resolved bugs.

This version contains the following significant updates:
– Support for several new MySQL 5.6 features
– Import recordsets from CSV file for the Inserts editor in Modeling and in the SQL Editor
– Improved trigger editor
– more

Additionally, MySQL Utilities 1.1.1 have been included on the distribution.

For a full list of issues fixed in this release, see https://dev.mysql.com/doc/relnotes/workbench/en/wb-news-5-2-45.html

Please get your copy from our Downloads site. In Windows, you can also use the MySQL Windows Installer to update Workbench and other MySQL products.

Sources and binary packages are available for several platforms, including Windows, Mac OS X and Linux.

https://dev.mysql.com/downloads/workbench/

Workbench Documentation can be found here.

https://dev.mysql.com/doc/workbench/en/index.html

Utilities Documentation can be found here.
https://dev.mysql.com/doc/workbench/en/mysql-utilities.html

If you need any additional info or help please get in touch with us.

Post in our forums or leave comments on our blog pages.

– The MySQL Workbench Team

PlanetMySQL Voting:
Vote UP /
Vote DOWN

I Can’t Get Enough of These Pictures Taken from Airplane Windows

By Casey Chan, GizmodoDecember 27, 2012 at 02:00PM

I used to always pick the aisle seat whenever I flew on a plane. It’s not like I’m ridiculously tall or anything, I just enjoyed the freedom of one side (preferably my right) and the easy access to the bathroom (of which I rarely use). But on a recent trip to New York, I traded my aisle seat for a window seat. And after seeing New York from above, man, I don’t think I’ll ever sit in an aisle seat again. More »

Improve Your Security Defense By Going On Offense Using Backtrack Linux

By Danny Stieben, MakeUseOfDecember 27, 2012 at 01:01PM

backtrack linuxWe constantly hear about new security threats and companies that have been breached. As such, it’s understandable for some of us to be paranoid about security in order to prevent any possible attacks. If you’re not at least a little bit paranoid, you might want to read up on which site was the last one to have passwords stolen from.

Even if you have good security measures in place for your computer, you’ll also have to place equally heavy emphasis on your home network, as havoc can ensue for anyone who can find their way in. In order to figure out whether you have adequate security set up for your network, you’ll need the right tools.

About Backtrack Linux

backtrack linux

Backtrack Linux is a Linux distribution specializing in network penetration. The distribution is based off of Ubuntu, but includes a very large array of testing tools out of the box as well as other needed patches such as tweaked wireless drivers.

While Backtrack Linux is meant to be used in a LiveDVD environment, it can still be installed onto a computer’s hard drive, which may be recommended if you solely use such a system for network penetration, as you’d then be able to install updates to the included software.

Getting Started

When you first boot off of the CD, you’ll need to take a few simple steps in order to get into Backtrack’s GUI. Power users won’t need to start the desktop environment if they prefer not to, but those who are newer to Backtrack and/or Linux should do so.

backtrack linux security

In case you get a “boot:” prompt at the very beginning, just hit enter and it’ll continue booting up.

backtrack linux security

It’ll then come to a boot menu, where you have a number of different options. You’re welcome to use any of them if you need them, but otherwise I’d go with the first, default selection.

backtrack linux security

Backtrack will keep loading until it reaches a command line prompt. From here, power users can run commands with programs that are already installed on the DVD. However, if you want a GUI, you’ll simply need to enter startx and hit enter, and your desktop environment should launch.

Tools

backtrack linux

One of the things that makes Backtrack so respectable as a network penetration testing package is that it includes virtually every tool you could possibly want for the job. Just take a look through the menus, and you’ll see that the software selection is highly customized for its intended purpose.

If you look at the Backtrack category in the Applications menu, you’ll see the full list of all installed programs, and there are definitely a lot of them. There are plenty of tutorials around the Internet that can teach you how to use all of them, but a good start would be James’ guide to cracking a WEP-protected wireless network.

How To Get It

Backtrack Linux can be downloaded from their download page. Once there, you have a couple of choices, such as the architecture and desktop environment. You can even choose between a regular browser download or one using a Torrent client.

Once the ISO image file has been downloaded, you’ll need to burn it to a DVD or write it onto a USB drive. From there, configure your system’s BIOS to boot from the DVD/USB, and Backtrack Linux should be loading.

Conclusion

I’m very glad that Backtrack Linux exists because manually setting up the same environment, including all programs and patches, would take a lot of time and effort. Instead, one can simply load Backtrack from their preferred media, and get down to work in less than a minute. It’ll still take some time to learn how to use all the included programs (or at least those which are applicable to you), but it’ll be well worth it.

If you haven’t already, give Backtrack Linux a try and test out your home network. There’s a reason why it’s on MakeUseOf’s List of Best Linux Distros.  Just please remember to only perform penetration testing on systems which you own or have explicit permission, as it is otherwise illegal in most jurisdictions.

How do you ensure your network’s security? Without sharing sensitive information, what security features do you have set up? Let us know in the comments.

The post Improve Your Security Defense By Going On Offense Using Backtrack Linux appeared first on MakeUseOf.

How to offload your iTunes library to a NAS

By Lee Hutchinson, Ars TechnicaDecember 26, 2012 at 08:45AM

iTunes is something a whole lot of folks tolerate. It’s never been the best at any particular thing (except perhaps activating and syncing your iPhone or iPad, where it’s the only official game in town), but it certainly does a lot of stuff. Sometimes slow, sometimes crashy, and perpetually gaining features, it’s the app we use every day but rarely with any joy. One of its more frustrating aspects is its lack of an officially supported server component—Apple seems stubbornly unwilling to provide a real iTunes server, and so folks who would otherwise happily centrally locate a media library on a perfectly suitable NAS are stuck with islands of music.

Building a central multi-user iTunes server that works consistently and well— that’s also easy to configure and maintain without needing remote administration tools or command line hackery—is annoyingly difficult. However, it is relatively easy to take your iTunes library and simply move it to a NAS. It’s not the house iTunes server we wish we had, but it does get your data off of your computer’s local hard disk drive.

Why would you want to do this? The reason that pushed me down this path is solid state disks. As iTunes libraries go, mine’s middle of the road—about 50GB, made up of a mixture of music, audiobooks, and iOS apps but lacking movies, TV, and podcasts. Still, that’s 50GB of SSD space that would be taken up by files which, frankly, don’t particularly benefit from being on an SSD. I could relocate them to an external drive, but I don’t have any spare external drives with enough capacity. What I do have, though, is a Synology DS-412+ with plenty of space on it.

Read 33 remaining paragraphs | Comments

Process Explorer – The Most Powerful Task Manager Replacement [Windows]

By Chris Hoffman, MakeUseOfDecember 24, 2012 at 06:31PM

process explorerLet’s be honest, the Windows Task Manager isn’t that great for understanding and managing the processes running on your computer. Even on Windows 8, where it’s much-improved, the task manager can’t come close to the power of Process Explorer. It’s part of the Sysinternals set of tools that Microsoft purchased – and for good reason. They’re among the most powerful system utilities for Windows.

In addition to its power, Process Explorer is also flexible. It’s available from Microsoft as a single .exe file. That makes it a portable app you can throw on a USB drive and run on any computer.

Understanding The Processes Running On Your Computer

Perhaps the greatest thing about Process Explorer – from a power-user perspective – is the way it helps visualize the processes running on your computer and their relation to each other.

The task manager included with Windows is a bit of a mess, displaying all running processes in a flat list. It works if you’re hunting for a specific process by name, but it doesn’t give you an overview that really helps you understand what’s going on.

It’s particularly messy if you use multi-process applications like Google Chrome – what if Google Chrome was misbehaving and you needed to kill all its processes? The Windows Task Manager doesn’t make it easy.

process explorer

Process Explorer helps make much more sense of this. The most obvious improvement is the hierarchical tree of processes – we can see the main chrome.exe process that launched all other Chrome processes and understand what Google Chrome is doing. If we wanted to force-quit Google Chrome entirely, we could right-click the top chrome.exe process and select Kill Process Tree. If we wanted to hide all these chrome.exe processes so they didn’t clutter the list, we could click the minus icon to collapse that part of the tree.

process explorer download

Other improvements also help make this list easier to understand. Each process has an associated icon, a description, and a company name. These descriptions and names may be blank – it’s up to each program to provide this information.

Color-coding helps, too. Processes colored blue are your own processes, while processes colored pink are system services. Your desktop processes will appear under explorer.exe near the bottom of the list, while services will appear under services.exe near the top. This helps sort the process list so you aren’t sifting through system services while viewing the processes running on your desktop.

To view which colors correspond to which types of processes and customize the colors, click the Options menu and select Configure Colors.

process explorer download

More Features

Process Explorer is packed with features, including all the ones you’d expect from the Windows Task Manager. You can right-click a process to kill it, change its priority level, or set its CPU affinity and force it to run on only a specific CPU. We won’t focus on all these features – we’ll focus on cool things you can do with Process Explorer that you can’t do with the Windows Task Manager.

  • Search Online: This feature is present in Windows 8’s new task manager, but it showed up in Process Explorer first. You can right-click any running process in the list and select Search Online to quickly search for it online. This can help you understand exactly what the process is and where it came from.
  • Detailed Process Properties: To view information about a process, right-click it and select Properties. If a process is automatically starting with your computer, Process Explorer will tell you where it’s configured to do so. If a process is hiding in the background, you can click Bring to Front to view its window (assuming it has a visible window).

process explorer download

  • Detailed Resource Usage Information: Process Explorer exposes many more ways of visualizing resource usage. In addition to system-wide resource usage graphs, you’ll find per-process CPU, memory, and disk usage graphs in a process’s properties window. You can also see a graph of GPU (graphics card) usage – either per-process or system-wide. To view system-wide resource usage data, click the View menu and select System Information.

process explorer for windows

  • Unlock Locked Files: Have you ever seen a message saying a specific file or folder is in-use by a process and can’t be deleted or moved? This is often to prevent files that are legitimately in-use from being modified, but sometimes programs continue locking a file even when they don’t need it. To see which program is using a file, you can click Find and select Find a Handle or DLL. Search for the name of the file or folder and Process Explorer will tell you which process is “locking” the file. To remove the lock so you can delete or move the file, right-click the handle itself and select Close Handle.

process explorer

  • Find a Window’s Process: Not sure what process a specific window belongs to? Click and drag the target-shaped icon on the Process Explorer toolbar over another window on your desktop. Process Explorer will show you which process the window belongs to.
  • Replace the Windows Task Manager: Love Process Explorer and wish the Windows Task Manager was this awesome? Just click the Options menu and select Replace Task Manager. Whenever you open the task manager – either by pressing Ctrl+Shift+Escape, right-clicking the task bar and selecting Start Task Manager, or pressing Ctrl+Alt+Delete and clicking Start Task Manager – Process Explorer will appear instead.

process-explorer-replace-task-manager

Process Explorer is listed on both our Best Windows Software and Best Portable Apps pages because it’s an amazing tool. If you’re looking for another third-party task manager replacement, you may also want to check out Process Hacker or System Explorer.

What do you think of Process Explorer? Do you prefer another task manager replacement? Leave a comment and share your favorite tool!

The post Process Explorer – The Most Powerful Task Manager Replacement [Windows] appeared first on MakeUseOf.