1. 给数据库添加登录用户和权限
# 创建用户
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;
原文：https://www.cnblogs.com/30go/p/9157188.html