Posted on: August 2nd, 2010 by Famous Phil

Introduction:

This topic plagues me to death every time I need to do some administrative function MySQL simply because I don’t do it every day.  I have 3 servers that I manage entirely via the command line now and all 3 require me to know at least some MySQL.  Unfortunately, I always end up going to several sources to get all the information I need.  So instead of doing that in the future, I’m writing this blog as a centralized reference for everything I need.  Hopefully you can use this blog as much as I will!

Note: You will need to click the “show code” icon in the top right corner to view the code entirely for some of the blocks that are longer than the code box.

POST UPDATED 6/5/2011 (deleting a user / listing users)

Read the rest of this entry »

Tags: administration, cheat, command line, interpreter, mysql
Posted in Hosting / Server Administration, Programming
|| 4 Comments »