connexion tomcat/mysql: IP vs localhost

2004-03-29 Thread Guillaume Roger
Hi all, I've a problem while connecting to mysql from tomcat. There is a bean which initializes the connexion between tomcat and mysql. The parameter which seems to be faulty is the url: jdbc:mysql://localhost:3306/appli After a reboot, this url caused an error, ie the connexion between mysql

Re: connexion tomcat/mysql: IP vs localhost

2004-03-29 Thread David Smith
Are you sure it's not MySQL being funny? Try going in to mysql as root and executing this query: select user, host from mysql.user ; Take a look at the host field for the user tomcat is logging in as. If it specifies anything other than %, you may end up having to put in a row for every

Re: connexion tomcat/mysql: IP vs localhost

2004-03-29 Thread Guillaume Roger
David Smith a écrit : Are you sure it's not MySQL being funny? Try going in to mysql as root and executing this query: select user, host from mysql.user ; That was an idea I already had, and I checked that. It is specified %, so I should be able to connect from everywhere. The thing is that I

Re: connexion tomcat/mysql: IP vs localhost

2004-03-29 Thread David Smith
Well, then I'm not sure what to tell you. I use mysql all the time and have never had such an issue (Mandrake Linux 9.2, Tomcat 5.0.19, Apache 2.0). Very strange. Are there any firewalls or internet connection sharing programs at work? --David Guillaume Roger wrote: David Smith a écrit :

Re: connexion tomcat/mysql: IP vs localhost

2004-03-29 Thread satbinder . singh
How do I unsubscribe from this mail group, as I keep getting mails every to minutes?

Re: connexion tomcat/mysql: IP vs localhost

2004-03-29 Thread eric sato
try here http://jakarta.apache.org/site/mail2.html#Tomcat - Original Message - From: [EMAIL PROTECTED] Date: Tuesday, March 30, 2004 0:41 am Subject: Re: connexion tomcat/mysql: IP vs localhost How do I unsubscribe from this mail group, as I keep getting mails every to minutes

Re: connexion tomcat/mysql: IP vs localhost

2004-03-29 Thread Giuseppe Briotti
== Date: Mon, 29 Mar 2004 11:03:11 +0200 jdbc:mysql://localhost:3306/appli jdbc:mysql://212.xxx.xxx.xxx:3306/appli quite strange... what happens if you put 127.0.0.1 (i.e. the IP address for localhost)? I think that, because you are working on a box (i.e. client and