mySQL - recommend a program for relational database design

[tony-raymondo]

Hi

I'm used to the old days of making relational databases in MS Access.

e.g. i'm used to working with layouts like this:

in the past, i've never worked with anything other than the ms access MDB file.

But i'm finally getting into sql and phpmyadmin, and I don't know where to start????

What is the MS Access equivalent here? Do i want to use MySQL Workbench?

e.g. how do i work on relational databases for export to phpMyAdmin.

forgive my ignorance Thanks!

 

[wizzardz01]

If you using windows try putty and MySQL Query Browser. Google about it

 

[olimix]

online sql editor :

http://ondras.zarovi.cz/sql/demo/?keyword=default

you can download it too

it's working perfectly with phpmyadmin , generated code is ready to be import

 

[trophaeum]

use visio

 

[tony-raymondo]

1. putty
2. MySQL Query Browser
3. visio
4. http://code.google.com/p/wwwsqldesigner/

hmm...

i use windows XP - i forgot to mention that.

i'm kinda looking for a program that I can download and model a database on -- offline if possible.

 

[judson]

There are a few.

The problem though, is security. By default, mySQL is set up to not allow any connections from anything other than localhost. Check that your host has not set yours up differently. If you can't connect remotely, your question is moot.

If you can, you can even use Access to connect to your mysql DB.

 

[KeyzDT]

putty....*shiver*

 

[thinkdevoid]

mysql workbench

 

[darkmonk]

MySQL workbench has an ER modeling tool built in. To be honest, I didn't really like it, but it is free and workable. Download and install the full MySQL pack locally, do your ER model, then script it and run the script on your server to deploy. Better to do it this way then open up external access to your server db. If you want to spend $$$ there's always ERWin or Embarcadero's stuff.

 

[trophaeum]

1. putty
2. MySQL Query Browser
3. visio
4. http://code.google.com/p/wwwsqldesigner/

hmm...

i use windows XP - i forgot to mention that.

i'm kinda looking for a program that I can download and model a database on -- offline if possible.

visio comes with office, you just need an odbc driver to talk to the db to send the create table queries, hate to say it but i still use visio myself, i cant find something decent to replace it

 

[Florist88]

try Toad for mysql (freeware)