Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i'm looking for the best and safest way to administrate my mysql-databases etc. on my server. any advice on this?

thanks

share|improve this question

closed as not constructive by Zoredache, sysadmin1138 Mar 12 '11 at 0:13

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

1  
This question is too vague for anyone to really help you, so my initial advice is to revise your question to be more specific (What are you managing, what are your requirements, etc.) :-) –  voretaq7 Mar 11 '11 at 20:34
add comment

1 Answer

up vote 1 down vote accepted

Here are a few recommendations I can give you:

phpMyAdmin

phpMyAdmin is a free software tool written in PHP intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL. The most frequently used operations are supported by the user interface (managing databases, tables, fields, relations, indexes, users, permissions, etc), while you still have the ability to directly execute any SQL statement.

Webmin

Webmin is a web-based interface for system administration for Unix. Using any modern web browser, you can setup user accounts, Apache, DNS, file sharing and much more. Webmin removes the need to manually edit Unix configuration files like /etc/passwd, and lets you manage a system from the console or remotely.

MySQL Workbench

MySQL Workbench is a cross-platform, visual database design tool developed by MySQL. It is the highly anticipated successor application of the DBDesigner4 project. MySQL Workbench is available as a native GUI tool on Windows, Linux and OS X in different editions.

Navicat

Navicat for MySQL is a powerful Database administration and development tool for MySQL. It works with any MySQL Database Server from version 3.21 or above, and supports most of the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, and Manage User, etc.

Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to MySQL.

With Navicat well-designed Graphical User Interface (GUI), Navicat for MySQL lets you quickly and easily create, organize, access and share information in a secure and easy way, taking MySQL administration.

Sorry, I could only post two links due to not having enough rep at the moment. Maybe someone can edit this and link MySQL Workbench and Navicat.

Hope this helps!

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.