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

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

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

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

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]

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

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

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