MySQL 101: Working with the MySQL DB on Linux

” Some people are born to be a database administrator, and
others have database administration thrust upon them. If you’re in
the former group and you need to perform some very basic
operations, like creating and backing up databases, you’ll find
it’s much easier than it sounds. Let’s take a look at some very
basic MySQL administration to get started.

“When I say basic, I do mean basic. This tutorial will not make
you a database administrator or MySQL expert. But you’ll have
enough MySQL to get by for some standard scenarios like setting up
WordPress or doing a quick backup of a MySQL database.

“You can also do these things with phpMyAdmin, and many folks
do, so why look at the command line? The first reason is that using
the command line client provides one less piece of software to
install, maintain, and worry about. If you find yourself
interacting with MySQL infrequently, there’s not much reason to
worry about installing a separate piece of software to interact
with it.”

Complete Story