Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JDBC can't connect to MySQL Server(10060)

Have Programming Question? Ask it here!
 
 
 


sreejith
can't connect to MySQL Server(10060)
1 Answer(s)      5 years and 9 months ago
Posted in : JDBC



Advertisement
View Answers

August 1, 2008 at 4:22 PM


Hi friend,


This is login action code.


<%@ page language="java" import="java.sql.*" import="java.util.*" %>

<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar";
String password="amar123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String user=request.getParameter("userid");
String pass=request.getParameter("password");
ResultSet rs=st.executeQuery("select userid,password from login");
while(rs.next()) {
String userid =rs.getString(1);
String passw=rs.getString(2);
if(user.equals(userid) && pass.equals(passw)) {
session.setAttribute("user",user);

%>
<jsp:forward page="LoginSuccess.jsp" />

<%}
else
out.println("Login Failed,Please try Againe");
%>

<%
}
}catch(Exception e1){}
}
catch (Exception e){
e.printStackTrace();
}

%>


---------------------------------------------------

Read for more information.

http://www.roseindia.net/jdbc/

Thanks.


Related Tutorials/Questions & Answers:
can't connect to MySQL Server(10060) - JDBC
can't connect to MySQL Server(10060)  Hii Sir, I am working with a jsp project with MySQL as server. Now i want to host my application. I am... MySQL front end. Can we connect to the MySQL server using the I.P address
Mysql connect
Mysql connect  i can have a mysql database file and mysql-connector-net .but i have not mysql database. how to connect vb.net thsis database.(C:\Documents and Settings\Admin\My Documents\VB.NET\Stock delna\STC.sql ). plz help me
Advertisements
mysql_connect arguments
mysql_connect arguments   How many arguments a mysql_connection function required to connect to the database?   ?mysql_connect? function takes three arguments Server - localhost Username - admin Password - 1admin
mysql error 1042 can't get hostname for your address
mysql error 1042 can't get hostname for your address  Hi, I am not able to connect to MySQL database. Its giving following error: mysql error 1042...; Hi, Find my.ini file of your MySQL Server and then add the following line
How to connect mysql with jsp
How to connect mysql with jsp  how to connect jsp with mysql while using apache tomcat
Java Connect to and FTP Server
the apache commons library to connect/login to FTP server. Link of complete example is FTP Server : Connect and Login. Thanks...Java Connect to and FTP Server  What is the code for Java Connect
could not connect to the server - JDBC
could not connect to the server  Hii sir, I am working with a JBDC program now. Now i am trying to host it. when i am trying to connect to the remote MySqL server, i got an exception like
not able to connect to mysql using.. jdbc
not able to connect to mysql using.. jdbc   i am not able to connect to mysql using jdbc .. is there any classpath that i need to set..because i am using mysql-connector-java jar file..to connect to mysql.. Pls provide the steps
Connect JSP with mysql
Connect JSP with mysql   ...; This query creates database 'usermaster' in Mysql. Connect JSP with mysql : Now in the following jsp code, you will see how to connect
FTP Server : Connect and Login
In this tutorial we will discuss how to connect and login in FTP server with java programming
how to connect mysql from gui?
how to connect mysql from gui?  i am unable to connet to mysql server from my projet that is gui for mysql...can anyone help me in this...its urgent? i have to connet to mysql from gui..   Hi Friend, Try the following
unable to connect to server - JSP-Servlet
unable to connect to server  thank you for the program code...-application-server/tomcat/install-configure.shtml Here you will get step by step installation and configuration of Apache Tomcat Server. After installation
how to connect mysql with JDBC - JDBC
how to connect mysql with JDBC  I have created three tables in the database MYsql, i have to connect them now using JDBC, can u please suggest me...(); } } Thanks Rajanikant  Hi friend, To mysql connect using JDBC
connect sql server 2005 using php
connect sql server 2005 using php  how to connect sql server 2005 using php program. how mssql_connect will work
how to connect client to server using Sockets
how to connect client to server using Sockets  how to connect client to server using Sockets
how to connect SQL Server 2005 using php
how to connect SQL Server 2005 using php  i need to connect SQL Server 2005 using php. how can i connect . how to use mssql_connect function
how to connect to database in php using mysql
how to connect to database in php using mysql  how to connect to database in php using mysql
pls provide steps to connect mysql in flex - XML
pls provide steps to connect mysql in flex   hi ,PLS SUGGEST ME I HAVE NO IDEA WHERE TO PLACE THE FUNCTIONS.PHP CODE.I HAVE WAMP SERVER .CAN I PASTE THE FUNCTIONS.PHP THERE .OR ANY OTHERWAY .HOW FLEX CONNECT WITH WAMP .IF SO PLS
error call to undefined function mysql_connect
error call to undefined function mysql_connect  what is error call to undefined function mysql_connect
Connect JSP with mysql
Connect JSP with mysql   ... you how to connect to MySQL database from your JSP code. First, you need... database in my sql command prompt) 2. Connect JSP with mysql
how to connect mySql drivers into eclipse(configuration)?
how to connect mySql drivers into eclipse(configuration)?  how to connect mySql drivers into eclipse(configuration)? I need the configuration in eclipse. what do i have to download from mySql and just downloading is enough or do
problem connect jsp and mysql - JSP-Servlet
problem connect jsp and mysql  hello, im getting an error while connecting jsp and mysql. I have downloaded the driver mysql-connector... Software Foundation\Tomcat 5.5\common\lib\mysql-connector-java-2.0.14.jar
how to connect jsp to mysql - Java Beginners
how to connect jsp to mysql  I m new in Mysql and JSP i m ceating.java file using bean file for connectivity but i m not able to connect jsp... me hw to conncet jsp with mysql this is connection file package connect
how to connect j2me program with mysql using servlet?
how to connect j2me program with mysql using servlet?  my program...(); String userid=connect(user.toLowerCase().trim(), pwd.toLowerCase().trim... String connect(String user,String pwd){ String db="mobileapp
upgrade mysql cpanel server
upgrade mysql cpanel server  upgrade mysql cpanel server
Connecting to remote mysql server using jdbc.
Connecting to remote mysql server using jdbc.  How to Connect to remote mysql server using jdbc
PHP MySql Server Version
PHP MYSQL server version Sometimes we need to check the version of MySql, PHP provides mysql_get_server_info() function to check the MySql version. To check... = mysql_connect('localhost', 'root',  ' zz ' );//mysql_connect(): it open
mysql server connectivity - Java Server Faces Questions
mysql server connectivity  hello friends, my question is that i m not able to connect jsp, servlet with sql 2000. i know we have to do.../mysql/ Thanks
pls provide steps to connect mysql database in flex - XML
pls provide steps to connect mysql database in flex  hi,i am new to flex and doing project. i have doubt in how to connect MYSQL database in flex .pls provide the steps . i would be really thankful 2 u. i am loooking
why this can't
why this can't  import java.util.*; class Dash{ public static void main(String args[]){ int x0=100; int[] x1=new int[3]; int[][] x2=new int[3][3]; int[][][] x3=new int[3][3][3
PHP MySQL Connect to a Database
it with so much ease. To connect with mysql server we can use two ways one... PHP MySQL Connect to a Database:      ... with MySQL server. Following piece of code will help you to check whether your PHP
How to connect to MySql Database from Servlet?
; font-weight: bold; } How to connect to MySql Database from Servlet... will show you how to connect to MySQL database and perform select operation. You will learn the JDBC steps necessary to connect to the MySQL Database and execute
pls provide steps to connect mysql database in flex - XML
pls provide steps to connect mysql database in flex  hi, pls provide steps to connect mysql database in flex.pls i am trying from last week still it was not connected .pls provide the step by step procedure.i am looking
JDBC Connection code to connect servlet with SQL Server 2008
JDBC Connection code to connect servlet with SQL Server 2008  Please ans me why it is not connect i use netbeans IDE7.0 Jdk 1.7 i also add sqljdbc4.jar but the output is SEVERE: Java Runtime Environment (JRE) version 1.6
Using javabeans to connect mySQL database on a jsp page - JSP-Interview Questions
Using javabeans to connect mySQL database on a jsp page  Hi, Am doing my project and I don't know how to connect a jsp page to a mySQl database...; Connecting a JSP page to MYSQL Database using JavaBean File Name: beancode.java
how can i create a mysql database to connect to this code - JDBC
how can i create a mysql database to connect to this code  i need help creating a mysql database for this code. code is import java.awt...."); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register
how can i create a mysql database to connect to this code - JDBC
how can i create a mysql database to connect to this code  i need help creating a mysql database for this code. code is import java.awt...."); Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/register
MySQL server has gone away
MySQL server has gone away  Hi, What is the reason of error "MySQL server has gone away"? Some time in my application this error is coming. Thanks   hi friend, This happens because the server is timed out
Check PHP MySQL Connectivity
can connect a PHP page with MySQL server. Following piece of code will help you to check whether your PHP web page has been connected with MySQL server or not. Code 1: <?php $con=mysql_connect("localhost","
MySQL server PID file could not be found! [FAILED]
MySQL server PID file could not be found! [FAILED]  MySQL server PID file could not be found! [FAILED
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql
need help....how to connect and disconnect multiple databases(databases created in mysql) using java and my sql  i am working on a project... to know that how to query multiple databases(databases created in my mysql) so
java and sql server NOT Mysql - JSP-Servlet
image from MS SQL server NOT MySQL. Or is it not possible to do it in MS SQL server other than Mysql? Please let me know. Thank you all one again...java and sql server NOT Mysql  Hi guys. Thank you all
Connecting to MySQL
(); bds.setDriverClassName("com.mysql.jdbc.Driver"); bds.setUrl("jdbc:mysql...(""); try { System.out.println("Trying to connect!!"...-dbcp.jar, commons-pool.jar, j2ee.jar and mysql-connector-java-5.1.7-bin.jar
Connect to the database
Connect to the database  how to connect to the database in the iphone
PHP MySQL Login Form
will study how to create a login form, connect with the database server and login...Login Form using PHP and MySQL: In any website generally it is mandatory...= $_POST["userid"]; $f_pswd= $_POST["password"]; $con=mysql
Mysql Permission
Mysql Permission       Mysql Permission allows the user to connect to the database, Mysql... the permission to connect. All user /host/password combination are listed in this table
Starting MySQL....The server quit without updating PID file
Starting MySQL....The server quit without updating PID file  Hi, My MySQL server is running on Centos and it is not restarting and giving following error: Starting MySQL....The server quit without updating PID file (/var/lib
cannot connect to database - JDBC
cannot connect to database  Iam using eclipse in my system ,when connecting the database mysql version 5.0 to the eclipse iam getting an error as ""Creating connection to mysql has encountered a problem.Could not connect to mysql
Server DB connection - JDBC
also tried passing the 4th argument to the mysql_connect function but I can't...Server DB connection  Hello Guys I want to connect two databases.... One database is on my localhost and the other one is on server, I want
How to connect
How to connect  how to connect to a remote host using jsp? We need to update files to the database of the application on the local machine from the updated database on our webpage
Advertisements
 

 

 

DMCA.com