The main reason I use the CLI is I'm already there. I do a lot of system administration through the terminal and it's just easier to type "mysql" than to click around my desktop. Plus I don't want the httpd timeout getting in the way of longer queries. I typically run long queries that sometimes take a few minutes to complete. It's better to put those into a "screen" so there's nothing that'll stop them from completing.