Nearly...
The mysql user can be called anything you want. I usually have a user set up in MySql specifically for Java called 'javaUser'. I give them select, insert, delete and update privileges. The UNIX mysql user is very separate than the mysql users. You shouldn't need to do anything with the UNIX mysql user. I believe this is used by mysql so it can the correct privileges to read and write the databases. Users for mysql are so you can set up who is allowd to connect to the mysql and what they can do when they connect. ie. can they create databases, update databases, which databases they can update etc. At 01:02 PM 16/08/2002 +0200, you wrote: >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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
