-
What is this?
From advanced Bash tricks to Python gotchas to MySQL tutorials, this blog covers various topics in programming and systems administration. Find out how to get more done and have fun! Keep up with the latest by subscribing to the RSS feed!About the Author
This is the tech blog of Samuel Huckins. You can check out my homepage and other websites below, or send me a message here.-
-
Recent Posts
Post categories
Tags
Apache Apple Bash bookmarks CLI command database Desktop disk editor efficiency Excel filesystem firefox graph graphing hardware HTML information keyboard Launchy Linux logging migration Mobile monitoring MySQL PDF Programming putty Python Ruby scripting Security ssh subversion svn sysadmin Trac Ubuntu vim Vista web web applications WindowsBlogroll
Handy Links
My Sites
My del.icio.us
-
- Posts 191
- Words in Posts 69,962
- Comments 482
-
Tag Archives: MySQL
mysql_secure_installation: A useful first step in securing a MySQL server
This won’t be an exhaustive post on how to secure a MySQL server. I just want to mention a useful utility packaged with MySQL server: mysql_secure_installation. Simply run it from the command line once MySQL server is installed and running. … Continue reading
Running MySQL queries in Python
Being able to access MySQL databases in Python opens up quite a wide range of possibilities. It’s essential for a number of tasks such as connecting disparate datasources, performing maintenance, running regular updates, and more. While there are a number … Continue reading
Finding the smallest or largest value across multiple columns in MySQL
A long title for a simple problem: You have a table containing several columns of, say, dates. You want to find out the first or last date among the values of these columns per row. Not too bad. But, you … Continue reading
Creating better MySQL indexes: The basics
The well-developed MySQL platform allows anyone to play with a full-featured database just by following a few links and clicking through an install wizard. You can download it at home for free, and have access to the same high end … Continue reading
Exploring the power of the mysql client
One of the things that surprised me at the MySQL Bootcamp was the focus on using the mysql CLI client. I used to only use this, since the GUI-based Query Browser was rather unstable on Linux. I just got tired … Continue reading