MySQL cheatsheet

mysql

mysql> create database front;
mysql> GRANT ALL PRIVILEGES ON front.* to ppdl_front@localhost IDENTIFIED BY 'password';
mysql> SHOW GRANTS FOR 'ppdl_front'@'localhost';
mysql> REVOKE ALL PRIVILEGES ON `shared`.* FROM 'ppdl_front'@'localhost';

mysqladmin -h 127.0.0.1 -u root password '123456'

# Change type of table

ALTER TABLE t1 ENGINE=InnoDB;
show table status; (показать статус таблиц базы данных)

# Вывести в столбик:

select * from vb_user where username='znnick'\G;