mysql default commands

mysql > SELECT User, Host FROM mysql.user;    # Show Users;

mysql > CREATE USER 'newuser'@'localhost' IDENTIFIED BY 'password';         # Create an user

mysql > SET PASSWORD FOR 'username'@'localhost' = PASSWORD('new password');        # Set new password

mysql > FLUSH PRIVILEGES;

mysql> CREATE TABLE 'new_database'.'table' SELECT * FROM 'old_database'.'table';    # copy table to another database

mysql> SHOW TABLE STATUS FROM 'database';    # check Engine, Collation (e.g., character set) for all tables in a 'database'

mysql> DESCRIBE 'table' ;

mysql > DELETE FROM 'table_name';        # delete all rows in 'table_name'