List:MySQL and Java« Previous MessageNext Message »
From:Jeff Newmiller Date:August 20 2012 5:09am
Subject:Re: Access denied for user 'sa'@'localhost'
View as plain text  
Perhaps you should talk to an audience versed with this software (its developers?). As
long as the software is failing on a user you don't intend to be used, the application
software is the problem, not the driver.
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil@stripped>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
Sent from my phone. Please excuse my brevity.

Ijlal EL HAZITI <ijlal.hzt@stripped> wrote:

>Good evening
>I'm trying to install a webapp: sakai, on a remote server; but I'm
>that error:
>Caused by: java.sql.SQLException: Access denied for user
>(using password: NO)
>    at com.mysql.jdbc.SQLError.createSQLException(
>    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
>    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
>    at com.mysql.jdbc.MysqlIO.checkErrorPacket(
>    at com.mysql.jdbc.MysqlIO.secureAuth411(
>    at com.mysql.jdbc.MysqlIO.doHandshake(
> at com.mysql.jdbc.ConnectionImpl.coreConnect(
>    at
> at com.mysql.jdbc.ConnectionImpl.createNewIO(
>    at com.mysql.jdbc.ConnectionImpl.<init>(
>    at com.mysql.jdbc.JDBC4Connection.<init>(
>at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
>    at
>    at
>    at java.lang.reflect.Constructor.newInstance(
>    at com.mysql.jdbc.Util.handleNewInstance(
>  at com.mysql.jdbc.ConnectionImpl.getInstance(
>    at
>    at
>    at
>    at
>    at
>    ... 66 more
>I'm using tomcat7, mysql 5.1, mysql-connector-java-5.1.21 and java
>tomcat instance starts fine.
>before deploying sakai, there were no errors while starting or shutting
>down tomcat.
>I've already granted all privileges on the DB sakai to the user: sakai
>the command:
>GRANT ALL PRIVILEGES ON sakai.* to 'sakai'@localhost' identified by
>also; I have put the correct username and password in the
>file, and removed the anonymous users also.
>I appreciate your help.

Access denied for user 'sa'@'localhost'Ijlal EL HAZITI20 Aug
  • Re: Access denied for user 'sa'@'localhost'Jeff Newmiller20 Aug