Monday, October 3, 2011

Manage MySQL using shell scripting.

Connect MySQL : mysql -h -u -p
Create a DB: mysql> create database
Use a DB for operate: mysql> use
Show all databases: mysql> show databases;
Show the running quries: mysql> process list
Kill the query: mysql> kill

No comments:

Post a Comment