Let me Understand,
To run tomcat as tomcat user and be able to connect to mysql thought JDBC I need: On my unix machine have a user named tomcat which runs tomcat. On mysql have other user named tomcat. And the connection thought JDBC must be done with the user and password created in mysql. -----Original Message----- From: Capr1ce [mailto:[EMAIL PROTECTED]] Sent: viernes 16 de agosto de 2002 12:57 To: Tomcat Users List Subject: RE: Run Tomcat as tomcat user No they don't need to have the same password. When your JSP/Java code connects to the MySql database using JDBC, you should use the mysql user to connect. At 12:48 PM 16/08/2002 +0200, you wrote: >�the unix tomcat user and the mysql tomcat user must have the same password? > >-----Original Message----- >From: Capr1ce [mailto:[EMAIL PROTECTED]] >Sent: viernes 16 de agosto de 2002 12:40 >To: Tomcat Users List >Subject: RE: Run Tomcat as tomcat user > > > >A password is not necessary, but certainly recommended. > >See these sections of the mysql documentation: >http://www.mysql.com/doc/en/GRANT.html >http://www.mysql.com/doc/en/Adding_users.html > > >At 12:31 PM 16/08/2002 +0200, you wrote: > >Hi Andy ! > > > >Thanks for your response. > > > >I have created a user named tomcat in mysql and I have granted acccess > >but...I haven't created any password for this user, is necesary a password?? > > > >Urtzi > > > >-----Original Message----- > >From: Andy Eastham [mailto:[EMAIL PROTECTED]] > >Sent: viernes 16 de agosto de 2002 12:25 > >To: Tomcat Users List > >Subject: RE: Run Tomcat as tomcat user > > > > > >Urtzi, > > > >You need to grant access to the tomcat user. See the section in the GRANT > >command in the mysql manual (available online at the www.mysql.com site). > >By default, root can connect without a password, but other users need to be > >granted access. > > > >You'll need to execute something like: > >GRANT ALL PRIVILEGES on *.* to nobody@yourhostname identified by > >'nobodyspassword'; > > > >The password is not the unix password - its mysql specific and set by this > >command. > > > >I recommend you read up to make sure you're only grant what you need - after > >all there's no point running as nobody if it can do everything root can... > > > >Test it by doing > >su - nobody > >then check that you can connect with the password you've set. > > > >Andy > > > > > -----Original Message----- > > > From: Urtzi Larrazabal [mailto:[EMAIL PROTECTED]] > > > Sent: 16 August 2002 11:04 > > > To: [EMAIL PROTECTED] > > > Subject: Run Tomcat as tomcat user > > > > > > > > > > > > Hi ! > > > > > > I am trying to run tomcat as tomcat user. When I start it, it > > > seems to start without any problem. I execute some jsp and it > > > works fine but when I execute a page tha require to connect to > > > mysql database it cant't connect to the database and an empty log > > > named something like DCB_1029483253596.log is generated. Running > > > tomcat as root I haven't any problem. > > > > > > �any idea? > > > > > > Regards, > > > > > > Urtzi. > > > > > > > > > -- > > > To unsubscribe, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > For additional commands, e-mail: > > > <mailto:[EMAIL PROTECTED]> > > > > > > > > > > > > > >-- > >To unsubscribe, > e-mail: <mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > >-- > >To unsubscribe, > e-mail: <mailto:[EMAIL PROTECTED]> > >For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
