Re: MySQL sw for reverse engineering
Thank you all for the posts. Can anyone explain to me how can I connect DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe there's some kind off trick to connect DBDesigner4 to MySQL 4.x because the program doesn't support the MySQL 4.x Or the ODBC connection solution to MySQL 4.x... Thanks, Bruno -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL sw for reverse engineering
Bruno Cochofel wrote: Thank you all for the posts. Can anyone explain to me how can I connect DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe there's some kind off trick to connect DBDesigner4 to MySQL 4.x because the program doesn't support the MySQL 4.x Or the ODBC connection solution to MySQL 4.x... Thanks, Bruno I've got it hooked up to 4.0.? and 4.1.?. I don't remember having any problems with it, but it has been a while since I set it up. One database is local to the machine that DBD runs on and the other is on another box. I've got both of the DB servers set up in my DNS server and that's how I've got them listed in the connection settings ( ie server = mysql or mysql2 ). Dunno if that's made a difference or not. I've got DBD 4.0.5.4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL sw for reverse engineering
From http://www.mysqlusers.com/msg/37105.html we have:
Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
Edward Vermillion wrote:
Bruno Cochofel wrote:
Thank you all for the posts. Can anyone explain to me how can I connect
DBDesigner4 to MySQL 4.x? I've never used MySQL 3.x and I believe
there's some kind off trick to connect DBDesigner4 to MySQL 4.x because
the program doesn't support the MySQL 4.x
Or the ODBC connection solution to MySQL 4.x...
Thanks,
Bruno
I've got it hooked up to 4.0.? and 4.1.?. I don't remember having any
problems with it, but it has been a while since I set it up. One
database is local to the machine that DBD runs on and the other is on
another box. I've got both of the DB servers set up in my DNS server
and that's how I've got them listed in the connection settings ( ie
server = mysql or mysql2 ). Dunno if that's made a difference or not.
I've got DBD 4.0.5.4
Re: MySQL sw for reverse engineering
Bruno Cochofel wrote:
From http://www.mysqlusers.com/msg/37105.html we have:
Reset the password to pre-4.1 style for each user that needs to use a
pre-4.1 client program. This can be done using the SET PASSWORD
statement and the OLD_PASSWORD() function:
mysql SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd');
[snip]
That actually looks like something I may have done. I *did* upgrade to
4.0 from 3.?, and may have had to do that to keep it all working at the
time(PHP 4 and all). When I installed 4.1, I just copied the DB files
over to that server so all of that would have gone with it at the time.
Like I said, it was a while back when I installed DBD and even further
back when I updated mysql. I've slept since then. :D
Hope that works for you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL sw for reverse engineering
Does anyone know a sw that can reverse engineering a mysql table? I want to be able to draw a entity-relationship model from an already made MySQL table. Thanks, Bruno
Re: MySQL sw for reverse engineering
Bruno Cochofel wrote: Does anyone know a sw that can reverse engineering a mysql table? I want to be able to draw a entity-relationship model from an already made MySQL table. Thanks, Bruno There's MySQL Workbench here: http://forums.mysql.com/list.php?113 which is a bit shakey but will do that for you. I generally find it crashes when you close it (better than crashing when starting). Doesn't work on Linux yet. Also people say great things about DBDesigner4 but I haven't used it to talk about it. G. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL sw for reverse engineering
Bruno Cochofel wrote: Does anyone know a sw that can reverse engineering a mysql table? I want to be able to draw a entity-relationship model from an already made MySQL table. Dezign from Datanamic does a good job. MydbPal for Mysql is free and advertises reverse engineering; I haven't used it. MySQL Workbench is also free but not yet either full-featured or stable. PB -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.14/130 - Release Date: 10/12/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL sw for reverse engineering
Graham Reeds wrote: Bruno Cochofel wrote: Does anyone know a sw that can reverse engineering a mysql table? I want to be able to draw a entity-relationship model from an already made MySQL table. [snip] Also people say great things about DBDesigner4 but I haven't used it to talk about it. G. I use it (DBDesigner4) and it works good for me, but I'm not a DB expert so YMMV. The reverse engineering works great. I'm running it on Fedora Core 1 right now. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
