I've made the suggested changes and I now receive the foloowing eror:
java.sql.SQLException: Invalid authorization specification: Access denied for user:
'root@larry' (Using password: YES)
Here is the updated code...any more suggestions?
Connection con =
DriverManager.getConnection("jdbc:mysql://larry/howlerdb?user=root&password=winston2644");
Thanks
John Brosan
Matt Read wrote:
> 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
>>