Thanks all for your earnest
i use the username and passwd to connect mysql is ok on console:
#mysql -u mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 29 to server version: 3.23.30-gamma-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer
mysql>
it's same tourble when use 127.0.0.1 instead of localhost in my codes.
So what else reason?
look towards your more help
shao
----- Original Message -----
From: "Artigas, Ricardo Y." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, February 28, 2001 5:09 PM
Subject: Re: Help: jdbc for mysql
> check if you really have permission to connect to the database
> from the machine using the username and password you've given.
> Also, try to use 127.0.0.1 instead of localhost in your connection string.
> Good luck.HTH.
>
> :^)
> Ricky Y. Artigas
> Analyst/Programmer
> Information Technology Division
> Easycall Communications Phils., Inc.
> - Easycall Internet -
> 418 Arayat St., Mandaluyong City 1550, Philippines
> Personal WAP Site: http://www.buzzed.co.uk/mobile/?rya
> Company Website: http://www.easycall.com.ph
> Tel.no: (+632) 5338001 ext.6574
> Mobile:(+63) 0917-8951783
> Pager: 141-002955
> Email: [EMAIL PROTECTED]
>
>
> > -------------------------------
> > IMPORTANT NOTICE:
>
> > This message (and any attachment hereto) may contain privileged and/or
> > confidential information specific to EasyCall. If you are not the
intended
> > addressee indicated in this message, you may not copy or disseminate
this
> > message (or any attachment hereto) to anyone. Instead, please destroy
this
> > message (and any attachment hereto), and kindly notify the sender by
reply
> > email. Any information in this message (and any attachment thereto) that
> > do not relate to the official business of EasyCall shall be understood
as
> > neither given nor endorsed by the company.
> >
> >
> > -----Original Message-----
> > From: Shao [SMTP:[EMAIL PROTECTED]]
> > Sent: Wednesday, February 28, 2001 3:35 PM
> > To: [EMAIL PROTECTED]
> > Subject: Re: Help: jdbc for mysql
> >
> > Thank you for your advise, but it output the same message:
> > SQLException: Cannot load connection class 'java.sql.SQLException:
> > Server configuration denies access to data source'.
> > SQLState: 08001
> > VendorError: 0
> >
> >
> > ----- Original Message -----
> > From: "Gavin Siller" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Wednesday, February 28, 2001 6:23 PM
> > Subject: Re: Help: jdbc for mysql
> >
> >
> > > Just to test replcae the appropriate line with the following:
> > >
> > >
> >
DriverManager.getConnection("jdbc:mysql://localhost/test?user=monty=greats
> > ql
> > db");
> > >
> > > Cheers ... Gavin
> > >
> > > -----Original Message-----
> > > From: Shao [SMTP:[EMAIL PROTECTED]]
> > > Sent: 28 February 2001 09:02
> > > To: [EMAIL PROTECTED]
> > > Subject: Help: jdbc for mysql
> > >
> > > Hi, all
> > >
> > > I think this is a very simple question but disturb me deeply. When i
run
> > > these
> > > codes:
> > > import java.sql.*;
> > > public class LoadDriver
> > > {
> > > public static void main(String[] Args)
> > > {
> > > try {
> > >
> > Class.forName("org.gjt.mm.mysql.Driver").newInstance();
> > > System.out.println("Load OK!");
> > > }
> > > catch (Exception E) {
> > > System.err.println("Unable to load driver.");
> > > E.printStackTrace();
> > > }
> > > try {
> > > Connection C = DriverManager.getConnection(
> > >
> > > "jdbc:mysql://localhost:3306/mydb?user=mysql&password=");
> > > }
> > > catch (SQLException E) {
> > > System.out.println("Error in connect");
> > > System.out.println("SQLException: " + E.getMessage());
> > > System.out.println("SQLState: " + E.getSQLState());
> > > System.out.println("VendorError: " + E.getErrorCode());
> > > }
> > > }
> > > it' output likes below:
> > > Load OK!
> > > Error in connect
> > > SQLException: Cannot load connection class 'java.sql.SQLException:
> > > Server configuration denies access to data source'.
> > > SQLState: 08001
> > > VendorError: 0
> > >
> > > Why cannot load the connection class?
> > > My environment is: mm.mysql.jdbc-2.0pre5 + mysql-3.23.30-gamma +
jdk1.3
> > +
> > > redhat6.1 +(tomcat3.2 + apache3.12)
> > >
> > > Please help me
> > > Thanks
> > > shao
> > >
> > >
> >
__________________________________________________________________________
> > _
> > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> > body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > > Resources:
http://java.sun.com/products/servlet/external-resources.html
> > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> > >
> > >
> >
__________________________________________________________________________
> > _
> > > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> > body
> > > of the message "signoff SERVLET-INTEREST".
> > >
> > > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > > Resources:
http://java.sun.com/products/servlet/external-resources.html
> > > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
> > >
> >
> >
__________________________________________________________________________
> > _
> > To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> > body
> > of the message "signoff SERVLET-INTEREST".
> >
> > Archives: http://archives.java.sun.com/archives/servlet-interest.html
> > Resources: http://java.sun.com/products/servlet/external-resources.html
> > LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
>
___________________________________________________________________________
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
