mybatis入门踩的坑-mysql数据库拒绝访问及log4j:WARN No appenders could be found for logger 解决方案

一、

首先说log4j:WARN No appenders could be found for logger 主要是因为log4j的配置没有完整导致的，新建一个log4j.properties文件(放于resource文件下且该文件被值为资源文件)，cv下面的代码即可

解决方案：

log4j.rootLogger=INFO, stdout, D

# Console Appender
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern= %d{hh:mm:ss,SSS} [%t] %-5p %c %x - %m%n

# Custom tweaks
log4j.logger.com.codahale.metrics=WARN
log4j.logger.com.ryantenney=WARN
log4j.logger.com.zaxxer=WARN
log4j.logger.org.apache=WARN
log4j.logger.org.hibernate=WARN
log4j.logger.org.hibernate.engine.internal=WARN
log4j.logger.org.hibernate.validator=WARN
log4j.logger.org.springframework=WARN
log4j.logger.org.springframework.web=WARN
log4j.logger.org.springframework.security=WARN

# log file
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = D://log.log
log4j.appender.D.Append = true
log4j.appender.D.Threshold = DEBUG 
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern = %-d{yyyy-MM-dd HH:mm:ss}  [ %t:%r ] - [ %p ]  %m%n

二、java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)

数据库拒绝访问，小编在cmd命令下输入MySQL都不得行，所以找到服务(快捷搜索服务)下重启了MySQL

重启之后进入cmd以管理员运行，就可以访问数据库了