第一次用idea，装了ruoyi后总是用户不存在，求帮助

Question

20:34:36.984 [http-nio-80-exec-1] INFO  o.a.c.c.C.[.[.[/] - [log,173] - Initializing Spring DispatcherServlet 'dispatcherServlet'
20:34:36.998 [http-nio-80-exec-1] INFO  o.a.s.s.m.AbstractValidatingSessionManager - [enableSessionValidation,233] - Enabling session validation scheduler...
20:34:36.998 [http-nio-80-exec-1] DEBUG c.r.f.s.w.s.SpringSessionValidationScheduler - [enableSessionValidation,82] - Scheduling session validation job using Spring Scheduler with session validation interval of [10]ms...
20:34:36.999 [http-nio-80-exec-1] DEBUG c.r.f.s.w.s.SpringSessionValidationScheduler - [enableSessionValidation,104] - Session validation job successfully scheduled with Spring Scheduler.
20:34:37.020 [http-nio-80-exec-1] INFO  o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [shiro-activeSessionCache]
20:34:37.058 [http-nio-80-exec-3] INFO  o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
20:34:37.065 [http-nio-80-exec-3] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==>  Preparing: select config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark from sys_config WHERE config_key = ?
20:34:37.066 [http-nio-80-exec-3] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==> Parameters: sys.account.registerUser(String)
20:34:37.066 [http-nio-80-exec-3] DEBUG c.r.s.m.S.selectConfig - [debug,137] - <==      Total: 0
20:34:38.030 [schedule-pool-1] INFO  c.r.f.s.w.s.OnlineWebSessionManager - [validateSessions,100] - invalidation sessions...
20:34:38.035 [schedule-pool-1] DEBUG c.r.s.m.S.selectOnlineByExpired - [debug,137] - ==>  Preparing: select sessionId, login_name, dept_name, ipaddr, login_location, browser, os, status, start_timestamp, last_access_time, expire_time from sys_user_online o WHERE o.last_access_time <= ? ORDER BY o.last_access_time ASC
20:34:38.048 [schedule-pool-1] DEBUG c.r.s.m.S.selectOnlineByExpired - [debug,137] - ==> Parameters: 2023-03-04 20:04:38(String)
20:34:38.051 [schedule-pool-1] DEBUG c.r.s.m.S.selectOnlineByExpired - [debug,137] - <==      Total: 0
20:34:38.052 [schedule-pool-1] INFO  c.r.f.s.w.s.OnlineWebSessionManager - [validateSessions,165] - Finished invalidation session. No sessions were stopped.
20:34:44.461 [http-nio-80-exec-34] INFO  o.a.s.c.e.EhCacheManager - [getCache,169] - Using existing EHCache named [sys-config]
20:34:44.461 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==>  Preparing: select config_id, config_name, config_key, config_value, config_type, create_by, create_time, update_by, update_time, remark from sys_config WHERE config_key = ?
20:34:44.463 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectConfig - [debug,137] - ==> Parameters: sys.login.blackIPList(String)
20:34:44.464 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectConfig - [debug,137] - <==      Total: 0
20:34:44.469 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectUserByLoginName - [debug,137] - ==>  Preparing: select u.user_id, u.dept_id, u.login_name, u.user_name, u.user_type, u.email, u.avatar, u.phonenumber, u.sex, u.password, u.salt, u.status, u.del_flag, u.login_ip, u.login_date, u.pwd_update_date, u.create_time, u.remark, d.dept_id, d.parent_id, d.ancestors, d.dept_name, d.order_num, d.leader, d.status as dept_status, r.role_id, r.role_name, r.role_key, r.role_sort, r.data_scope, r.status as role_status from sys_user u left join sys_dept d on u.dept_id = d.dept_id left join sys_user_role ur on u.user_id = ur.user_id left join sys_role r on r.role_id = ur.role_id where u.login_name = ? and u.del_flag = '0'
20:34:44.474 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectUserByLoginName - [debug,137] - ==> Parameters: admin(String)
20:34:44.480 [http-nio-80-exec-34] DEBUG c.r.s.m.S.selectUserByLoginName - [debug,137] - <==      Total: 0
20:34:44.508 [schedule-pool-1] INFO  sys-user - [run,109] - [127.0.0.1]内网IP[admin][Error][用户不存在/密码错误]
20:34:44.510 [schedule-pool-1] DEBUG c.r.s.m.S.insertLogininfor - [debug,137] - ==>  Preparing: insert into sys_logininfor (login_name, status, ipaddr, login_location, browser, os, msg, login_time) values (?, ?, ?, ?, ?, ?, ?, sysdate())
20:34:44.520 [schedule-pool-1] DEBUG c.r.s.m.S.insertLogininfor - [debug,137] - ==> Parameters: admin(String), 1(String), 127.0.0.1(String), 内网IP(String), Chrome 11(String), Windows 10(String), 用户不存在/密码错误(String)
20:34:44.568 [schedule-pool-1] ERROR c.r.c.utils.Threads - [printException,96] - 
### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
### The error may exist in file [C:\Users\admin\Desktop\RuoYi-master\ruoyi-system\target\classes\mapper\system\SysLogininforMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysLogininforMapper.insertLogininfor-Inline
### The error occurred while setting parameters
### SQL: insert into sys_logininfor (login_name, status, ipaddr, login_location, browser, os, msg, login_time)   values (?, ?, ?, ?, ?, ?, ?, sysdate())
### Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
org.springframework.jdbc.UncategorizedSQLException: 
### Error updating database.  Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
### The error may exist in file [C:\Users\admin\Desktop\RuoYi-master\ruoyi-system\target\classes\mapper\system\SysLogininforMapper.xml]
### The error may involve com.ruoyi.system.mapper.SysLogininforMapper.insertLogininfor-Inline
### The error occurred while setting parameters
### SQL: insert into sys_logininfor (login_name, status, ipaddr, login_location, browser, os, msg, login_time)   values (?, ?, ?, ?, ?, ?, ?, sysdate())
### Cause: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1; nested exception is java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
    at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
    at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
    at com.sun.proxy.$Proxy85.insert(Unknown Source)
    at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
    at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)
    at org.apache.ibatis.binding.MapperProxy$PlainMethodInvoker.invoke(MapperProxy.java:145)
    at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:86)
    at com.sun.proxy.$Proxy111.insertLogininfor(Unknown Source)
    at com.ruoyi.system.service.impl.SysLogininforServiceImpl.insertLogininfor(SysLogininforServiceImpl.java:31)
    at com.ruoyi.framework.manager.factory.AsyncFactory$3.run(AsyncFactory.java:132)
    at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
    at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
    at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
    at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
    at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
    at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: Incorrect string value: '\xE5\x86\x85\xE7\xBD\x91...' for column 'login_location' at row 1
    at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
    at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
    at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
    at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
    at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3446)
    at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434)
    at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3444)
    at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:152)
    at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.base/java.lang.reflect.Method.invoke(Method.java:566)

Answer 1

这个提示的是你插入的内容存在中文,但是你数据库设置的编码格式又不是utf-8
你可以参考下面这个链接改改试试
http://t.csdn.cn/L60Uo