luoshui0428
紫浔
采纳率100%
2016-08-03 09:35

Linux中,发布JavaWeb项目时登录不进去。求大神帮忙解答!小妹感激不尽!

5
已采纳

jdk是1.7,tomcat版本是8.5,测试过了,没有发现问题,也可以进入tomcat页面,测试发布了一个网页,也可以成功,但是将Java web 项目放进去时,登录不进去,Linux上用tail -f /tomcat8.5.4/logs/catalina.out查看错误日志如下:

Caused by: java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:885)
at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3421)
at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1247)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2775)
at com.mysql.jdbc.Connection.(Connection.java:1555)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:285)
at org.apache.commons.dbcp.DriverConnectionFactory.createConnection(DriverConnectionFactory.java:38)
at org.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582)
at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1556)
at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
... 54 more

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享
  • 邀请回答

6条回答

  • luoshui0428 紫浔 5年前

    我自己改好了,是因为连接地址不对,不能用localhost要用虚拟机的地址

    点赞 评论 复制链接分享
  • ios_king 果冻剑客 5年前

    先关服务再 修改密码,重新进入,步骤如下:
    解决方法如下:
    ?
    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    29
    30
    31
    32
    33
    34
    35
    36
    37
    38
    39
    [root@www ~]# service mysqld stop #先关闭mysql服务
    Stopping mysqld: [ OK ]
    [root@www ~]# mysql
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [root@www ~]# mysql -u root -p #关闭服务后又出现如下问题
    Enter password:
    ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
    [root@www ~]# mysql -u root mysql #键入此命令进入mysql
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 1
    Server version: 5.1.73 Source distribution
    Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    mysql> update user set password=password('123') where user='root' and host='localhost'; ---->修改root的密码
    Query OK, 1 row affected (0.04 sec)
    Rows matched: 1 Changed: 1 Warnings: 0
    mysql> flush priviledge;
    ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'priviledge' at line 1
    mysql> flush privileges;
    Query OK, 0 rows affected (0.00 sec)
    mysql> \q
    Bye
    [root@www ~]# mysql -u root -p ------>重新进入
    Enter password:
    Welcome to the MySQL monitor. Commands end with ; or \g.
    Your MySQL connection id is 2
    Server version: 5.1.73 Source distribution
    Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    mysql> \q
    Bye

    点赞 评论 复制链接分享
  • u014717036 100000000000000000 5年前

    目测是权限问题,直接给权限吧

    点赞 评论 复制链接分享
  • CODER_V 无道loading 5年前

    和你数据库有关,可能是你权限问题或数据库密码

    点赞 评论 复制链接分享
  • CODER_V 无道loading 5年前
    点赞 评论 复制链接分享
  • qq_35439782 傅牧山 5年前

    看下两边的数据库上的密码是不是一样

    点赞 评论 复制链接分享

相关推荐