很烦,就这个错误搞了一晚上,整个人都不好了,记录一下,以免还有小伙伴遇到这个错误不知怎么办
当然,应该没人像我这么蠢了。。。。唉,
关键就在这!就是这里出了错误
配置文件
datasource.properties
db.driverLocation=/usr/local/mysql-connector-java-5.1.6-bin.jar db.driverClassName=com.mysql.jdbc.Driver db.url=jdbc:mysql://192.168.1.107:3306/mmall_learning?characterEncoding=utf-8 db.username=mmall db.password=123456 1 192.168.1.107 是所在主机的ip
[root@XXX 桌面]# ifconfig eth0 Link encap:Ethernet HWaddr 00:15:5D:01:6E:04 inet addr:192.168.1.107 Bcast:192.168.1.255 Mask:255.255.255.0 inet6 addr: fe80::215:5dff:fe01:6e04/64 Scope:Link UP BROADCAST RUNNING MULTICAST MTU:1500 Metric:1 RX packets:568099 errors:0 dropped:0 overruns:0 frame:0 TX packets:73385 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:1000 RX bytes:95369270 (90.9 MiB) TX bytes:11477266 (10.9 MiB) lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:65536 Metric:1 RX packets:15493 errors:0 dropped:0 overruns:0 frame:0 TX packets:15493 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:1880464 (1.7 MiB) TX bytes:1880464 (1.7 MiB) 2,mmall_learning 是你存放表的数据库的名称,和mysql的默认数据库mysql和information-schema是并列关系 3,mmall是你在创建数据库用户时的名字,其余的数据库用户可以有root等等 4,password:我就是这里搞错了!!!!!!!!!!像头猪,这个密码是对应的上面数据库用户的密码! 这里可以查询用户名和密码,注意这里密码只能显示是否设置了,不能显示具体的 mysql> select user,host,password from mysql.user; +-------+-----------+-------------------------------------------+ | user | host | password | +-------+-----------+-------------------------------------------+ | root | localhost | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | AAAAA | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | root | 127.0.0.1 | *81F5E21E35407D884A6CD4A731AEBFB6AF209E1B | | AAAAA | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | mmall | % | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | | mmall | localhost | *6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9 | +-------+-----------+-------------------------------------------+ 6 rows in set (0.00 sec) 如果还是想不起来密码可以在navicat的user里面重新设置或者终端命令设置也可以 敲重点!!!!!!!!!!!!! 所以,在配置环境的时候这些用户名,密码最好是用相同的,拿个小本本记下来,不然以后会浪费很多时间 ps:如果有效伙伴和我一样傻,,请大声的告诉我