MySQL 相关笔记

• RDBMS
• MySQL 基础知识
• MySQL 语法

mysql -h host -P port -u username -p
USE mysql;
SELECT Host,User FROM user;
DELETE FROM user WHERE User='username' AND Host='host';
GRANT ALL ON *.* TO 'username'@'host' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT select,create,drop,update,alter ON *.* TO 'username'@'host' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;