Your code should probably look something like this. Note there is no
connection between Unix account and mySql accounts.
Connection con =
DriverManager.getConnection("jdbc:mysql://larry/howlerdb?user=root&password=
rootpassword");
or if you're trying to log in as howler
Connection con =
DriverManager.getConnection("jdbc:mysql://larry/howlerdb?user=howler&passwor
d=winston2644");
Either should work as long as you're connecting from localhost.
Matt.
----- Original Message -----
From: "Howler D. Wolfe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: 18 July 2001 15:14
Subject: Re: Problems with a simple JSP and mySQL connect
> Simon,
>
> I miss read your question. The host machine is "larry" and the db
> account I use is "root" I hope that clarifies things.
>
> Thanks again
> John Brosan
>
>
> Simon Chan wrote:
>
> > Which machine (host) and what db account you access the database from?
> >
> > "Howler D. Wolfe" wrote:
> >
> >> I have data in this table as follows
> >>
> >> HOST USER PW PRIVS (shortened to save space)
> >> -----------+-------------+-----------+---------------
> >> localhost root 9999 All are set to 'Y'
> >> larry root (empty) All are set to 'Y'
> >> localhost (empty) (empty) All are set to 'N'
> >> larry (empty) (empty) All are set to 'N'
> >> localhost howler 9999 All are set to 'Y'
> >>
> >> Not sure whats going on with this or what exactly should be here.
> >>
> >> Any suggestions would be helpful
> >>
> >> Thanks
> >> John Brosan
> >>
> >> Simon Chan wrote:
> >>
> >> > Please check your mysql.user table to make sure that your client
> >> machine is in the host field.
> >> >
> >> > skc
> >> >
> >> > "Howler D. Wolfe" wrote:
> >> >
> >> >> Hello Everyone,
> >> >>
> >> >> I apologize if this has been answered in a previous post. I've
> >> been digging through old posts and
> >> >> and searching on the net for an answer to this problem.
> >> >>
> >> >> I am runnin Tomcat 3.2.2 and Apache 1.3.19 and MySQL (I think the
> >> latest version). I am able to
> >> >> run the examples without a hitch. I am new to Java, JSP and MySQL,
> >> I have created a database with
> >> >> two tables, when I try to use the MySQL driver to connect to the
> >> database I get the following error.
> >> >>
> >> >> I think I get this error because I don't have a user other than
> >> root setup on MySQL. In my searching
> >> >> for an answer, I read about using the URL of the MySQL db as part
> >> of getConnection(). I tried this
> >> >> and it failed due to the MySQL port not being open on my firewall.
> >> After I opened the appropriate
> >> >> port, I got the same error.
> >> >>
> >> >> What have I failed to do when setting up MySQL? I've installed it,
> >> ran the grants, I think I've done
> >> >> what was supposed to be done.
> >> >>
> >> >> I've used the user id of "root" with the password I set for it.
> >> >>
> >> >> Partial Error Text follows:
> >> >> *
> >> >> java.sql.SQLException: Server configuration denies access to data
> >> source*
> >> >>
> >> >> Thanks in advance
> >> >> John Brosan
> >> >
> >>
> > --
> > Simon Chan, Senior System Analyst, Rawmart.com, Inc.
> > 17/F MassMutual Tower, 38 Gloucester Rd, Hong Kong SAR, China
> > Tel: +852 2861-4564. Fax: +852 2865-3865. Email: [EMAIL PROTECTED]
> >
> > http://www.rawmart.com , the next dimension in the trading of
> > raw materials, please register now.
> >
> > An initiative of the Noble Group. Please visit us at
> > http://www.thisisnoble.com
>
>
>
