Results 1 to 4 of 4
LinkBack URL
About LinkBacks- 02-18-2011, 05:01 AM #1
Member
- Join Date
- Feb 2011
- Posts
- 10
- Rep Power
- 0
SQLException caught: Access denied for user 'root'@'localhost' (using password: YES)
hi i developed a registraion form using jsp
the code is as follows
<html>
<body bgcolor="#999966">
<form action="/userregister/Registration" method=post>
<table cellpadding=4 cellspacing=2 border=0>
<th bgcolor="#999966" colspan=2>
<font size=5>REGISTRATION</font>
<br><font size=1><sup></sup></font><hr>
</th><tr bgcolor="#999966"><td valign=top>
<b>First Name<sup>*</sup></b>
<br><input type="text" name="firstname" value="" size=15 maxlength=20>
</td><td valign=top><b>Last Name<sup>*</sup></b>
<br><input type="text" name="surname" value="" size=15 maxlength=20></td>
</tr><tr bgcolor="#999966">
<td valign=top><b>E-Mail<sup>*</sup></b>
<br><input type="text" name="email" value="" size=25
maxlength=125><br></td><td valign=top>
<b>Zip Code<sup>*</sup></b> <br>
<input type="text" name="zipcode" value="" size=5 maxlength=6></td>
</tr><tr bgcolor="#999966"><td valign=top colspan=2>
<b>User Name<sup>*</sup></b><br>
<input type="text" name="userId" size=10 value="" maxlength=10>
</td></tr><tr bgcolor="#999966">
<td valign=top><b>Password<sup>*</sup></b>
<br><input type="password" name="address1" size=10 value=""
maxlength=10></td><td valign=top>
<b>Confirm Password<sup>*</sup></b>
<br><input type="password" name="address2" size=10 value=""
maxlength=10></td><br>
</tr><td valign=top>
<b>Town:<sup>*</sup></b>
<br><input type="text" name="town" size=10 value=""
maxlength=10></td>
<br></tr><td valign=top>
<b>City:<sup>*</sup></b>
<br><input type="text" name="country" size=10 value=""
maxlength=10></td><br>
</tr><tr bgcolor="#663300">
<td align=center colspan=2><hr>
<input type="submit" value="Submit"></td></tr></table></center></form>
</body>
</html>
and the servlet is
package myservlets;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class Registration extends HttpServlet{
public void init(ServletConfig config) throws ServletException{
super.init(config);
}
public void doPost(HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException{
String connectionURL = "jdbc:mysql://localhost/jsp";
Connection connection=null;
ResultSet rs;
res.setContentType("text/html");
PrintWriter out = res.getWriter();
String uId = req.getParameter("userId");
String fname = req.getParameter("firstname");
String sname = req.getParameter("surname");
String address1 = req.getParameter("address1");
String address2 = req.getParameter("address2");
String town = req.getParameter("town");
String county = req.getParameter("country");
String zipcode = req.getParameter("zipcode");
try {
Class.forName("org.gjt.mm.mysql.Driver");
connection = DriverManager.getConnection(connectionURL, "root", "notallowed");
String sql = "insert into emp_details values (?,?,?,?,?,?,?,?)";
PreparedStatement pst = connection.prepareStatement(sql);
pst.setString(1, uId);
pst.setString(2, fname);
pst.setString(3, sname);
pst.setString(4, address1);
pst.setString(5, address2);
pst.setString(6, town);
pst.setString(7, county);
pst.setString(8, zipcode);
int numRowsChanged = pst.executeUpdate();
out.println(" Welcome : ");
out.println(" '"+fname+"'");
pst.close();
}
catch(ClassNotFoundException e){
out.println("Couldn't load database driver: " + e.getMessage());
}
catch(SQLException e){
out.println("SQLException caught: " + e.getMessage());
}
catch (Exception e){
out.println(e);
}
finally {
try {
if (connection != null)
connection.close();
}
catch (SQLException ignored){
out.println(ignored);
}
}
}
}
when i run this am getting the errror as
SQLException caught: Access denied for user 'root'@'localhost' (using password: YES)
please can any one say actually what is the problem
- 02-18-2011, 06:03 AM #2
Moderator
- Join Date
- Apr 2009
- Posts
- 10,481
- Rep Power
- 16
You need to use code tags.
Also you need to tell us what db you're using.
I can guess, but I shouldn't have to.
- 02-18-2011, 06:27 AM #3
Member
- Join Date
- Feb 2011
- Posts
- 10
- Rep Power
- 0
SQLException caught: Access denied for user 'root'@'localhost' (using password: YES)
hi u can see in my code am trying to connect to mysql database
and use said use code tags
sorry i dont have any idea regarding that
can u sen any sample application
- 02-18-2011, 11:31 AM #4
Moderator
- Join Date
- Apr 2009
- Posts
- 10,481
- Rep Power
- 16
They mean the formatting of your code is maintained and we can actually read it.Java Code:This is in code tags.
Unformatted code is very difficult to read.
You need to provide us with as much information as possible to answer your question. Expecting us to read your (unformatted) code to see which db you were connecting to is likely to result in people simply not bothering.
The answer is that you haven't given user root@localhost permission to access your database.
Reply With QuoteSimilar Threads
-
Jni registry 'access denied' error.
By durino13 in forum Advanced JavaReplies: 4Last Post: 09-17-2011, 07:06 AM -
java.io.FileNotFoundException: ..\log\server.log (Access is denied.
By parimal in forum Advanced JavaReplies: 22Last Post: 04-09-2011, 04:59 AM -
Access is denied
By tholland in forum New To JavaReplies: 2Last Post: 12-20-2010, 08:57 PM -
access denied
By Dennis in forum Advanced JavaReplies: 8Last Post: 06-05-2010, 08:46 AM
Bookmarks