Language Selection

English French German Italian Portuguese Spanish

Best Bash Tips Explained, Mysql, and other howtos

Filed under
HowTos

The bash shell is just amazing. There are so many tasks that can be simplified using its handy features. This tutorial tells about some of those features, explains what exactly they do and learns you how to use them.

Running a command from your history

Sometimes you know that you ran a command a while ago and you want to run it again. You know a bit of the command, but you don't exactly know all options, or when you executed the command. Of course, you could just keep pressing the Up Arrow until you encounter the command again, but there is a better way.

Full Story.


MySQL communicates through either local unix sockets or over TCP/IP port 3306 (default). Database names, tables, field names, and passwords are case sensitive. SQL Commands are not case sensitive.

The configuration file is /etc/my.cnf. Usually doesn't need tweaking, except when using the InnoDB storage engine.

The main command line utilities are mysql, mysqldump, and mysqladmin. Many people like the phpMyAdmin package to manage MySQL through a web browser.

Mysql Administration.



More in Tux Machines

House of Cards UI central to Mozilla's plans for Firefox on tellies

Mozilla has revealed how it reckons Firefox should look when it's on the tellie. Firefox OS user experience designer Hunter Luo reckons that the four basic functions of a smart television are watching shows, accessing apps, controlling devices and looking at list of your content. The user interface for Firefox-for-tellies therefore presents each of those options as a “deck”, concealing “cards”. So in the image below, “TV” is the deck and each of the channels gets a “card”, in this case Channel 32. Read more

elementary OS "Freya" to Get New Beautiful Open File Dialogue

elementary OS "Freya" was released a month ago, but the developers are still making big changes to it. One of these modifications will bring a new "Open File Dialog" that should look and work much better than the previous one. Read more

Mark Shuttleworth Asks Devs from Different Desktop Environments to Work Together

Mark Shuttleworth had a very interesting keynote at the opening of the Ubuntu Online Summit for 15.10, and he said the developers from all the desktop environments should work together towards a common goal. Read more