Java/JDBC - Connection refused on Linux

2003-06-17 Thread Jeff Weeks
I can't access MySQL using Java on Linux! It's killing my project. I can access that very MySQL from PHP just fine. I have the same database running on Windows so I can develop what I need to. Just can't run anything for our users!!! I don't think it's the firewall because I get the same

Re: Java/JDBC - Connection refused on Linux - solved

2003-06-17 Thread Jeff Weeks
I noticed from the example given by William Mussatto that I needed to include the Port Number on the URL. Yes, I am a Linux idiotbut hopefully learning as I go. Thank you, everyone. This list is awesome!! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Access denied for user: '@localhost' to database 'mysql'

2003-06-19 Thread Jeff Weeks
I ran a command which was part of the installation process for some php accounting software. update user set host='%' where host='localhost' and user='root'; Figured it just let root log in from anywhere. Dunno if that is what caused the problem or not. But now root can't access anything in

How to import XML into MySQL?

2003-07-15 Thread Jeff Weeks
Sorry. I missed this discussion previously. Now I need the answer. Figures. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: DATE COMPARISON

2003-07-15 Thread Jeff Weeks
Miguel - You can compare dates directly using "<" and ">" - no need for a special function. Dates are older when they are less than other dates. Cheers. Jeff On Tuesday, July 15, 2003, at 09:36 AM, Miguel Perez wrote: Hi: I was wondering if there is a date function to get the older date be

Re: Cant login as a user I thought I created

2003-08-14 Thread Jeff Weeks
How did you create user mark? BTW, after issuing a grant you must issue "flush privileges". Check out mark in the user table in the mysql database. There's your problem! On Wednesday, August 13, 2003, at 12:24 PM, Mark Healey wrote: I'm trying to learn to use mysql. I don't want to mess with

How to get a nice schema diagram

2003-10-21 Thread Jeff Weeks
Looking for an open source or commercial tool to help with database visualization for a presentation we are to give. Can't seem to find a simple way to generate a nice poster of our database design. Any suggestions? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.c

Datanamic works great for attractive schema diagrams

2003-10-21 Thread Jeff Weeks
It reads a MySQL database and will even form relationships based on matching column names. Totally cool. Thanks, Victor. On Tuesday, October 21, 2003, at 09:13 AM, Victor Pendleton wrote: Have you tried datanamic.com? -Original Message- From: Jeff Weeks [mailto:[EMAIL PROTECTED] Sent