killonb.blogg.se

Although not as feature-rich as MySQL Workbench, it does a great job of offering a user-friendly interface for the management (creating, editing, etc.) of databases on a particular machine. Figure D phpMyAdmin 5: EmmaĮmma ( Figure E) is another GUI tool for the management of MySQL databases. phpMyAdmin also allows for the execution of MySQL commands from within the interface. The interface is incredibly user-friendly and makes the tasks of creating and managing databases simple. It’s a PHP-driven tool and handles every aspect of managing a MySQL database server. PhpMyAdmin ( Figure D) is a favorite of many database admins. Figure C Webmin MySQL module 4: phpMyAdmin This enables you to easily manage your databases on that one server from anywhere that has access to the machine. Figure B MySQL Workbench 3: Webmin MySQL moduleĪlthough not quite as powerful as the MySQL Workbench (you can work only on the databases local to the server), the MySQL Webmin module ( Figure C) allows you do handle nearly any task on your databases - all through your Web browser. And like any good database management tool, MySQL Workbench has a built-in query tool and command shell. MySQL Workbench is a MySQL administrator’s dream come true. You can even use it to connect to multiple servers. Whatever you need to do with your databases, this GUI tool will do it. MySQL Workbench ( Figure B) is the king of all MySQL management tools. Figure A MySQL command shell 2: MySQL Workbench But if you want sheer power, this is the tool to use. Many users swear by the command shell and refuse to use any other tool, although others are intimidated by its steep learning curve and complex command-line syntax. From the MySQL command shell ( Figure A), you can do anything you need with your MySQL databases. Of course we should start with the built-in command-line tool. Note: This list is also available as a photo gallery.

In fact, there are several tools out there that allow you to manage the MySQL databases.

Most users assume that the only way to manage those databases is from the MySQL shell within a terminal. No matter where you stand, you may have to deal with this powerful database somehow. For others, it’s a nightmare relationship they’d rather not have to face. For many, it’s a love affair that has been going on for years. Here are five topnotch tools to consider. The right MySQL management tool can make your database chores go a lot more smoothly. Five tools to help you manage your MySQL databases