469,081 Members | 1,886 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

GUI interface

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?

Jul 20 '05 #1
2 1872
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.
Jul 20 '05 #2
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.

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Roy Pereira | last post: by
4 posts views Thread by Doug | last post: by
3 posts views Thread by zlst | last post: by
20 posts views Thread by Ole Hanson | last post: by
reply views Thread by YellowFin Announcements | last post: by
8 posts views Thread by rn5a | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.