MYSQL常用命令 MyISAM to InnoDB, max connections , GRANT ALL PRIVILEGES , mysqldump 等等

MyISAM to InnoDB

ALTER TABLE  boblog_blogs     ENGINE=InnoDB;
ALTER TABLE  boblog_calendar  ENGINE=InnoDB;

max connections

show global variables like "%max_con%";

set global max_connections xxx;

GRANT ALL PRIVILEGES

GRANT ALL PRIVILEGES ON *.* TO ‘root‘@‘%‘ IDENTIFIED BY ‘sa123‘ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO ‘myuser‘@‘%‘ IDENTIFIED BY ‘mypassword‘ WITH GRANT OPTION;

flush privileges;

 mysqldump

mysqldump -uroot -pabc123 qida_prd_20151122_1753 >qida_prd_20151124_0013.sql

mysql -uroot -p qida2_t001<F:\asp db backup\mysql\sql script\1511qd_shop.sql