GUI interface

[Tore Voldbekk]

I have set up a bit of MS databases before and enjoy the simplicity of
graphical interfaces. Does it exist something similar for MySQL? I have
tried the MySql control center, but it seems very limited. What I
really need is also to be able to set foreign keys, relations and so
forth. Does it exist for MySql, or is a harder user inteface the price
you pay in order not to pay MS a lot of money?

[Bill Karwin]

Tore Voldbekk wrote:

I have set up a bit of MS databases before and enjoy the simplicity of
graphical interfaces. Does it exist something similar for MySQL? I have
tried the MySql control center, but it seems very limited. What I
really need is also to be able to set foreign keys, relations and so
forth. Does it exist for MySql, or is a harder user inteface the price
you pay in order not to pay MS a lot of money?

I've been happy with phpMyAdmin, which is a browser-based interface to
MySQL. You need a PHP-capable web server to run it, though.
http://www.phpmyadmin.net/

For database server administration tasks, MySQL's MySQL Administrator is
nice, but it's more for monitoring and configuring the server, not
building databases.

But if you want to evaluate other MySQL GUI front-ends, mysql.com has a
large catalog of 3rd party tools:
http://solutions.mysql.com/software/?c=tools

As for foreign keys, yes, you can do that, but remember that you need to
define your database tables as InnoDB table type.
See: http://mysql.he.net/doc/mysql/en/Inn...nstraints.html

Regards,
Bill K.

[Mike]

On Thu, 14 Oct 2004 12:59:21 -0700, Bill Karwin wrote:

Tore Voldbekk wrote:

I have set up a bit of MS databases before and enjoy the simplicity of
graphical interfaces. Does it exist something similar for MySQL? I have
tried the MySql control center, but it seems very limited. What I
really need is also to be able to set foreign keys, relations and so
forth. Does it exist for MySql, or is a harder user inteface the price
you pay in order not to pay MS a lot of money?

I've been happy with phpMyAdmin, which is a browser-based interface to
MySQL. You need a PHP-capable web server to run it, though.
http://www.phpmyadmin.net/

For database server administration tasks, MySQL's MySQL Administrator is
nice, but it's more for monitoring and configuring the server, not
building databases.

But if you want to evaluate other MySQL GUI front-ends, mysql.com has a
large catalog of 3rd party tools:
http://solutions.mysql.com/software/?c=tools

As for foreign keys, yes, you can do that, but remember that you need to
define your database tables as InnoDB table type.
See: http://mysql.he.net/doc/mysql/en/Inn...nstraints.html

Regards,
Bill K.

I have both MySQLCC and knoda running as an experiment. Both are useful
with the latter being somewhat easier and more of what I think you want.
However it needs a few extra libraries and I still can't get it to
recognise the mysql I have running directly, but it does see it as ODBC
providing you put that service in too.

Regards
Mike R.