数据库（mysql）的用户表里新创建了一个用户，可是用它登入系统，却说用户名密码错误，报错如下

Question

start
2017-06-15 10:01:34 -253382 [http-apr-8080-exec-6] INFO - cm登录系统密码或用户名错误
2017-06-15 10:01:35 -254698 [http-apr-8080-exec-7] DEBUG - Don't need to create transaction for [com.xhw.service.system.user.impl.UserService.getUserByNameAndPwd]: This method isn't transactional.
2017-06-15 10:01:35 -254699 [http-apr-8080-exec-7] DEBUG - ooo Using Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@dc6e69]
2017-06-15 10:01:35 -254699 [http-apr-8080-exec-7] DEBUG - ==> Preparing: select USER_ID, USERNAME, PASSWORD, NAME, RIGHTS, ROLE_ID, LAST_LOGIN, IP, STATUS, BZ, SKIN, EMAIL, NUMBER, PHONE from SYS_USER where 1=1 and USERNAME = ? and PASSWORD=?
2017-06-15 10:01:35 -254699 [http-apr-8080-exec-7] DEBUG - ==> Parameters: cm(String), 6ba424c31220d5df3b83352ba0851ccace7a7be8(String)

Answer 1

需要设置允许该用户可以从指定的ip地址登录，http://blog.csdn.net/kesixin/article/details/72900966