it *is* important that you follow the directions provided to you
as hassan mentioned you need to go to mysql command prompt and try to open the
connection with the username/password
mysql>connect usern...@host
mysql>supply password
if you cannot access ALL of the requested tables with each of the required DML
operations(insert/update/delete/select)
you will then need to run mysqladmin and either
1)create the user
2)grant the user the necessary access(insert/update/delete/select) access to
the user you need
as these questions are specific to mysql please ask mysql users list if you
have any problems with these operations
my...@lists.mysql.com
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger
sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung
oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem
Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung.
Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung
fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le
destinataire prévu, nous te demandons avec bonté que pour satisfaire informez
l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est
interdite. Ce message sert à l'information seulement et n'aura pas n'importe
quel effet légalement obligatoire. Étant donné que les email peuvent facilement
être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité
pour le contenu fourni.
> From: yucca...@live.co.za
> To: users@tomcat.apache.org
> Subject: Re: stuck confused an need help please
> Date: Mon, 24 May 2010 21:06:13 +0200
>
> I forgot to mention I am using myswl 5, and tomcat 6
>
> --------------------------------------------------
> From: "Yucca Nel" <yucca...@live.co.za>
> Sent: Monday, May 24, 2010 9:00 PM
> To: "Tomcat Users List" <users@tomcat.apache.org>
> Subject: Re: stuck confused an need help please
>
> >
> > yes but I don't know why access I being denied? The credentials I am
> > providing sre 100% correct sn the database user has ALL privileges so
> > could anyone perhaps think o a possible reason why I am getting these
> > errors? I have confirmed with hosting provider that user exists and
> > credentials are correct and they also appear to be lost. I am using
> > correct myswl driver located in WEB-INF/lib
> > --------------------------------------------------
> > From: "Hassan Schroeder" <hassan.schroe...@gmail.com>
> > Sent: Monday, May 24, 2010 8:53 PM
> > To: "Tomcat Users List" <users@tomcat.apache.org>
> > Subject: Re: stuck confused an need help please
> >
> >> On Mon, May 24, 2010 at 11:37 AM, Yucca Nel <yucca...@live.co.za> wrote:
> >>> I have been getting mysql SELECT privilege denied exception even though
> >>> user has all access to database.
> >>
> >> There would seem to be a contradiction between the above statement
> >> and the first error in your log example :-)
> >>
> >>> ERROR main org.apache.catalina.core.ContainerBase.[Catalina] - Exception
> >>> opening database connection
> >>> java.sql.SQLException: Access denied for user '
> >>> yucca123_tom'@'localhost'
> >>> (using password: YES)
> >>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
> >>
> >> I would try to fix that first, personally...
> >>
> >> --
> >> Hassan Schroeder ------------------------ hassan.schroe...@gmail.com
> >> twitter: @hassan
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> >> For additional commands, e-mail: users-h...@tomcat.apache.org
> >>
> >>
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> > For additional commands, e-mail: users-h...@tomcat.apache.org
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
_________________________________________________________________
The New Busy is not the old busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_3
