Not sure how it works with a remote DB. Rememeber, it's the username/password of the DB, not the ISP account. You might be able to export the schema using PHPMyAdmin and than read that -- not sure it that's an option.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harris Paltrowitz Sent: Wednesday, January 10, 2007 11:34 AM To: MySQL SIG Subject: RE: [mysql] Graphical database diagram? Believe me, I'd usually rather be staring at other things too, but eventually things do have to get done! This was a great suggestion -- looks like exactly what I want. However, I'm getting "invalid username/password" when trying to connect to my remote database. I've got a ticket open with my web host to see if I need to prefix the userID with something, so I'll see. Thanks again! Harris -----Original Message----- From: "Cliff Hirsch" <[EMAIL PROTECTED]> To: "'MySQL SIG'" <[email protected]> Sent: 1/10/07 10:01 AM Subject: RE: [mysql] Graphical database diagram? I can think of more interesting things to stare at, but if your eye candy is DB diagrams try Fabforce DBDesigner4: http://fabforce.net/dbdesigner4/ It's free, pretty good, and can import your existing MySQL schema. Cliff -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Harris Paltrowitz Sent: Wednesday, January 10, 2007 9:28 AM To: [email protected] Subject: [mysql] Graphical database diagram? Hey all, I'm new to Mysql and PHP, but not to database programming in general. I would really like to have a database diagram to occasionally stare at while I'm coding -- anyone know of one that would be automatically generated from my existing database? Ideally it would show tables, foreign key relationships and column names. I wasn't able to spot one in phpMyAdmin, by the way. Thanks in advance. Harris _______________________________________________ New York PHP Community MySQL SIG http://lists.nyphp.org/mailman/listinfo/mysql NYPHPCon 2006 Presentations Online http://www.nyphpcon.com Show Your Participation in New York PHP http://www.nyphp.org/show_participation.php
