mysql#

archive a database#

mysqldump --single-transaction <db_name> | gzip -c > YYYYMMDD.sql.tgz

create a local user#

CREATE USER '<user>'@'localhost' IDENTIFIED BY '<password>'; FLUSH PRIVILEGES;

create a network user#

CREATE USER '<user>'@'%' IDENTIFIED BY '<password>'; FLUSH PRIVILEGES;

update a user’s password#

ALTER USER '<user>'@'%' IDENTIFIED BY '<password>'; FLUSH PRIVILEGES;

list the columns in a table#

SHOW COLUMNS FROM (<database>.)<table>;