mysql命令手记

 1.命令建库utf8：

CREATE DATABASE chain DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

#https://www.cnblogs.com/fnlingnzb-learner/archive/2016/09/01/5830661.html

2.创建远程账户

2.1.mysql -uroot -p

2.2.GRANT ALL PRIVILEGES ON *.* TO 'itoffice'@'%' IDENTIFIED BY 'itoffice' WITH GRANT OPTION;

2.3.flush privileges;