Mysql Administration

Mysql

User/User privileges
mysql> create user ...identified by...; mysql> grant xxx_priv on [schema].[objs] with grant option; mysql> flush privileges;
 * Users of mysql database is managed by the table mysql.user.
 * There are the following user privileges.
 * Select_priv, update_priv, insert_priv, delete_priv
 * Create_priv, drop_priv, alter_priv
 * Reload_priv, shutdown_priv, process_priv
 * File_priv, Reference_priv, Index_priv

Commands
mysql> use database; mysql> show databases; mysql> show tables; mysql> show indexes from table; mysql> show columns from table; mysql> show table status like table;