mysql常用操作

# 创建用户
create user ‘ecsoft‘ identified by ‘ecsoft‘;

# grant all privileges on 库名.表名 to ‘用户名‘@‘IP地址‘ identified by ‘密码‘ with grant option;
grant all privileges on ecsoft.* to ecsoft@"localhost" identified by ‘ecsoft‘;

# 提交
flush privileges;