Thank you for trying to help me everybody !
I read carefully your answer and it look like I have problem with
privileges. My problem is resolved !
The first thing I did is :
Comment this line on "my.cnf" file : # bind 127.0.0.1
Then the second thing that I made (with your advice) : is to try to connect
on MySQL with User and not with the root.
GRANT ALL PRIVILEGES ON testdb.* to 'test'@'localhost' IDENTIFIED BY 'test';
Doesn't work but when I did that :
GRANT ALL PRIVILEGES ON testBDD.* to 'test'@'monkinetwork' IDENTIFIED BY
'test';
It's worked.
It's look like I had to grant privilege on monkinetwork... It's very strange
and I can't understand, I don't know why I had to do that...
Best Regards.
monkiboy
> OK, the problem normally does not come from the driver, just try this:
> from your freshly installed MySQL database, remove the test database and
> also the test user from the database permissions table and from any
> global user definitions, then flush-privileges and you should be ready
> to go.
>
> Drew.
>
>
> On Thu, 2005-02-24 at 03:01, monkiboy wrote:
> > Hi everybody!
> > I have a weird problem to use the MySQL-connector under Linux (Debian).
I heard it can come from Tomcat.
> > I have no problem in windows XP, all is working fine !
> > But under Linux when I try to connect to mysql throught mysql-connector
wrote in a Servlet I have this message :
> >
> > Message: Invalid authorization specification message from server:
"Access denied for user 'root'@'monkinetwork' (using password: YES)"
> > SQLState: 28000
> > ErrorCode: 1045
> >
> > I am Using : Tomcat 5.0.28
> > MySQL-Connector version is : mysql-connector-java-3.0.15-ga-bin.jar
> >
> > JDK Version : 1_5_0_01. Servlet-Examples and JSP works fine! So I don't
think the problem come from JDK.
> >
> > MySQL version : MySQL-SERVER-4.1.9-2 : All is working under console mode
!
> >
> > Here's My Servlet TESt1.java:
> >
> >
> > Code:
> >
> >
> > import java.io.*;
> > import javax.servlet.*;
> > import javax.servlet.http.*;
> > import java.sql.*;
> > import java.sql.DriverManager;
> >
> > public class TEST1 extends HttpServlet {
> > public void doGet(HttpServletRequest request, HttpServletResponse
response)
> > throws ServletException, IOException {
> >
> > response.setContentType("text/html");
> > PrintWriter out = response.getWriter();
> >
> > String url = "jdbc:mysql://localhost:3306/HeroDB";
> > String user = "root";
> > String password = "password";
> >
> > try{
> > Class.forName("com.mysql.jdbc.Driver");
> > out.println("<br> DRIVERS JDBC : OK!");
> > Connection connection =
DriverManager.getConnection(url,user,password);
> >
> > out.println("<br> Database connection : OK!");
> >
> > }
> > catch (ClassNotFoundException e)
> > {
> > out.println("Error with JDBC Drivers !");
> > }
> > catch(SQLException ex) {
> >
> >
> > out.println("<br> ERROR MESSAGE <br>");
> > while (ex != null) {
> >
> > out.println("<br>Message: " + ex.getMessage ());
> >
> > out.println("<br>SQLState: " + ex.getSQLState ());
> >
> > out.println("<br>ErrorCode: " + ex.getErrorCode ());
> >
> > ex = ex.getNextException();
> > out.println("");
> > }
> > }
> >
> >
> > }
> > }
> >
> >
> >
> > AND THE HTML PAGE in order to access to the Servlet :
> >
> > Code:
> >
> > <HTML>
> > <HEAD>
> > <TITLE>DataBase Test</TITLE>
> > </HEAD>
> > <BODY BGCOLOR="#FDF5E6">
> > <H2 ALIGN="CENTER">DataBase TEST</H2>
> >
> > <FORM ACTION="http://localhost:8080/TEST1";>
> > <CENTER>
> > <INPUT TYPE="SUBMIT" VALUE = "CONNEXION TEST">
> > </CENTER>
> > </FORM>
> >
> > </BODY>
> > </HTML>
> >
> > Theses codes works very well under windows, but under linux system here
what I've got :
> >
> > DRIVERS JDBC : OK!
> > ERROR MESSAGE
> > Message: Invalid authorization specification message from server:
"Access denied for user 'root'@'monkinetwork' (using password: YES)"
> > SQLState: 28000
> > ErrorCode: 1045
> >
> > Well, the web.xml file is well configured.
> >
> > Anyway : I already tried with class: org.gjt.mm.mysql.driver, but I have
the same message error !
> >
> > By the way, it's very strange that I can play with MySQL under the
terminal but not throught tomcat.
> > Any suggestions please , because it's giving me a very hard time ! ?
> > Thank you !
> > ++
> > monkiboy
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
