Tomcat connecting to MySQL - Ubuntu 8.10 Server

[Ambrose Krapacs]

On Nov 16, 2008, at 21:57 , Hal Burgiss wrote:

> On Sun, Nov 16, 2008 at 10:31:38PM -0400, Derek Broughton wrote:
>>
>> Mysql must have a command line client.  Try it.
>
> This should work on a default install, but ymmv if passwords and users
> have been tinkered with:
>
> $ sudo mysql
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 853
> Server version: 5.0.51a-3ubuntu5.3 (Ubuntu)
>
> Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
>
> mysql> exit
> Bye
>
>
>
> --  
> Hal
>
>
> --  
> ubuntu-users mailing list
> ubuntu-users at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-users

I can use the mysql command line client with no problems. I've used it  
to create different users and added hosts to users in my efforts to  
troubleshoot this problem. I've also manually stopped and started  
mysql using "/etc/init.d/mysql stop" and "etc/init.d/mysql start" to  
verify the daemon is running.

In an effort to rule out an installation anomaly, I installed Ubuntu  
8.10 Server in a virtual machine (VMWare Fusion), and deployed a test  
application with to the tomcat server and saw the EXACT same behavior.  
I attempted to run the same test with 8.04 server but found that the  
Tomcat Java Application server is not one of the options when  
selecting the additional server components to install so I did not  
continue. Perhaps my next test will be to set up MySQL on another  
server and see if I can connect to it from Tomcat running on the 8.10  
server.