On Wed, 2005-04-27 at 07:07 +1200, [EMAIL PROTECTED] wrote: > Thanks Dave. I thought it was interesting as well... I just tried using > 'root' and the password for the root user in mySQL and it works. I'm not > going to have access to the root user on my production host, so how can I > get around this? Both the Tomcat server and the mySQL server are on the > same host, so using localhost works to identify the server. I'm just > curious as to why this isn't working.
Bit like working out the magic of running tomcat as someone other than root :-) In mySQL (command line interface), I created a user with access rights to read and write to the tables necessary, then used that from tomcat. Only twist is the idea of passing the password over the network in plain text. I found something in the excellent mySQL documentation that told me how to do that. > > Maybe there is a permissions issue? I've only started using mySQL, so I'm > not proficient at the nuances of it yet. I know I can have additional > mySQL users created on my production server, I just need to give them the > permissions this user would need in order to insert into this database. http://dev.mysql.com/doc/ I downloaded the index and the (very large) single html page. Be patient and it tells you what you need. > > <slap> - Sorry everyone. It was my fault. The database specified below > is a new database that I didn't specifically add my couser to. This is > the reason why it wasn't connecting. I'm not sure what the whole '%' > thing was though. Now it's working and should work fine on my production > host. > > Thanks for the response! we've all done it (or at least I have). regards DaveP --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
