Solved

JDBC: Database access; Access denied for user

Posted on 2004-08-03
2
764 Views
Last Modified: 2008-01-09
From terminal window I'm able to access my database using:
mysql -u rmwijage -p
Password NahumCh1.

From JDBC when using my database handler I get the following error message:

SQLException: Invalid authorization specification,  message from server: "Access denied for user: 'rrugemalira@localhost.localdomain' (Using password: YES)"
SQLState: 28000
VendorError: 1045

Here is my database handler:
/* ==================================================== */
package rtpm.EAKServlets;

import java.io.*;
import java.net.*;

import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import rtpmEAKBeans.FormBean;

public class DBHandler extends HttpServlet {

    public void doPost (HttpServletRequest request,
      HttpServletResponse response) {
      try { // OBTAIN A DATABASE CONNECTION
         
          // Step 1: Load the JDBC driver          
          Class.forName("com.mysql.jdbc.Driver");
             
          // Step 2: Establish a connection to the database          
       
          Connection conn = DriverManager.getConnection(
          "jdbc:mysql://localhost/rtpmKenyaDB","rmwijage", "NahumCh1");
 
          String sql = "INSERT INTO rtpm_user(firstname, surname, " +
          "username, password1, password2, email, " +
          "sdp_code) VALUES (?, ?, ?, ?, ?, ?, ?)";
          PreparedStatement ps = conn.prepareStatement(sql);
         
          // Retreave the bean properties to be inserted into table rtpm_user
          FormBean f = (FormBean) request.getAttribute("formHandler");
         
          // Set the parameters in the prepared statement
          ps.setString(1, f.getFirstName());
          ps.setString(2, f.getLastName());
          ps.setString(3, f.getUserName());
          ps.setString(4, f.getPassword1());
          ps.setString(5, f.getPassword2());
          ps.setString(6, f.getEmail());
          ps.setString(7, f.getSdp());
         
          // Insert the row in the table
          ps.executeUpdate();

          // Close the connection
          ps.close();
          conn.close();    
      }
      catch (SQLException e) {
          // handle any errors
          System.out.println("SQLException: " + e.getMessage());
          System.out.println("SQLState: " + e.getSQLState());
          System.out.println("VendorError: " + e.getErrorCode());
          }
      catch (Exception e) {
      e.printStackTrace();
      }
     
      // Send the request back to success.jsp  
      try {
          getServletConfig().getServletContext().
            getRequestDispatcher("/success.jsp").
             forward(request, response);
      }
      catch (Exception e){}
     
   }
}
/* ========================================================================= */

// I do appreciate your kind help.
0
Comment
Question by:Rrugemalira
2 Comments
 
LVL 11

Accepted Solution

by:
sompol_kiatkamolchai earned 500 total points
ID: 11711715
I think it is privileges problem. Please make sure that you already grant permission for this user to insert on that table.
You can use MySQL Administrator to do that

User Administration --> (select user) --> Schema Privileges  --> (select schema) --> Assiged Privileges

Download this tool from

http://dev.mysql.com/downloads/administrator/

0
 
LVL 4

Expert Comment

by:Oliver_Dornauf
ID: 11714844
Did you read the error message?
User rrugemalira@localhost.localdomain can not login, at the console you use rrugemalira@localhost.
Try a diffrent syntax for your connection:

 Connection conn = DriverManager.getConnection(
          "jdbc:mysql://localhost/rtpmKenyaDB?user=rmwijage","rmwijage", "NahumCh1");


check also if you have a typo : rmwijage and rrugemalira
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stuck in Bootstrap WysiHtml Editor 3 42
Display the newly inserted values 3 81
How to group array of objects ? 5 70
getting Http 404 error in jsp forms 8 81
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
Read about why it is more lucrative for an IT company to participate in government projects.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question