Best Bash Tips Explained, Mysql, and other 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.
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.
- Command of the day - lsof
- How to sync your Pocket PC with Ubuntu
- How to Enable SSL version 3 and TLS (Transport Layer Security) version 1 in Apache hosts
- Manage SSH Tunnels with Gnome SSH Tunnel Manager