Tips/MySQL

Basic Exploration

 $ mysql -u root -p -h localhost
 mysql> show databases;
 mysql> use <db_name>;
 mysql> show tables;
 mysql> describe <table name>;
 
 $ mysqldump -d -u root -p --all-databases

Resetting a root password

Add a user

 $ mysql --user=root mysql

  mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost'
      ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION; 
  mysql> GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%'
      ->     IDENTIFIED BY 'some_pass' WITH GRANT OPTION;
  mysql> GRANT RELOAD,PROCESS ON *.* TO 'admin'@'localhost';
  mysql> GRANT USAGE ON *.* TO 'dummy'@'localhost';

A user with typical update rights may be added with

  mysql> GRANT SELECT,INSERT,UPDATE,DELETE ON virus_db.* TO 'vstats'@'localhost' 
      -> IDENTIFIED BY 'password';

See also http://www.scalene.net/docs/manuals/mysql/manual_MySQL_Database_Administration.html#Adding_users