you said you tested it using command-line:
#mysql -u mysql
try using the username you specified in your previous emails:
# mysql -u monty
if monty has a password then type this insteaD:
#mysql -u monty -p <PRESS ENTER KEY and then type monty's password>
And then use this format as connection string:
DriverManager.getConnection(jdbc:mysql://127.0.0.1/test?user=monty&password=
montypassword);
instead of:
DriverManager.getConnection("jdbc:mysql://localhost/test?user=monty=greats
> > ql
> > db");
:^)
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 4:24 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Help: jdbc for mysql
>
> 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
___________________________________________________________________________
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
