MySQL Cheatsheet

type -a mysql

sudo service mysql restart

/usr/local/var/mysql

mysql -u root -p

SHOW DATABASES;

CREATE DATABASE database_name;

DROP DATABASE IF EXISTS database_name;

USE database_name;

SHOW tables;

DESCRIBE potluck;

CREATE TABLE potluck (id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(20),
food VARCHAR(30),
confirmed CHAR(1),
signup_date DATE);

USE databaseName;
CREATE USER 'USERNAME' IDENTIFIED BY 'PASSWORD';
grant CREATE,INSERT,DELETE,UPDATE,SELECT on databaseName.* to user@localhost;
grant ALL PRIVELAGES on databaseName.* to user@localhost;
set password for user = password('mysecretpassword');
set password for user@localhost = password('mysecretpassword');
grant ALL on database.* to databaseName@'%' identified by 'mysecretpassword';
exit;

INSERT INTO `potluck` (`id`,`name`,`food`,`confirmed`,`signup_date`) VALUES (NULL, "John", "Casserole","Y", '2012-04-11');

ALTER TABLE potluck ADD email VARCHAR(40);
ALTER TABLE potluck ADD email VARCHAR(40) AFTER name;
ALTER TABLE potluck DROP email;

DELETE from potluck where name='Sandy';

SELECT User FROM mysql.user;

SHOW GRANTS;
SHOW GRANTS FOR CURRENT_USER;
SHOW GRANTS FOR CURRENT_USER();

CREATE USER 'marko' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON dbname.* TO 'marko';

/etc/init.d/mysql status

ps aux | grep mysql
ps wwaux | grep -i sql

sudo /etc/init.d/mysql restart

netstat -tulpen