Manager database Administration // IT Management Solutions

Manager database Administration

New to the HotScripts Blog?
Subscribe to our blog via RSS feed or email alert and receive updates, tips and tutorials on web development & design.

If your web site or application is backed by a MySQL database, chances are that you’re using phpMyAdmin to manage it. phpMyAdmin provides a simple interface that allows you to create databases, define table structures, perform CRUD operations as well as supporting other useful features like table import/export and optimization.

There are however many phpMyAdmin alternatives that provide added functionalities like GUI interface for designing database and setting table relationships. In this round up we take a look at some of the desktop and web based MySQL database administration tools.

SQLyog GUI is a powerful MySQL manager and admin tool, combining the features of MySQL Administrator, phpMyAdmin and other MySQL Front Ends and MySQL GUI tools.

Platform: Windows | Price: (Professional License)

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, dtored procedure, gunction, event, view, and manage eser, etc. This software is commercial, but a Navicat lite version is available for free

Platform: Windows, Mac OS X, Linux, Unix | Price: Commercial (also available for free as a lite version)

DbVisualizer is a Java-based database tool for developers and database administrators aimed at helping them develop and maintain databases. It is the perfect choice since the same tool can be used on all major operating systems accessing a wide range of databases. One of its great features is query builder that provides an easy way to develop database queries through a point-and-click interface.

Platform: Windows, Mac OS X, Linux, Unix | Price: Free

HeidiSQL is a lightweight, Windows based interface for MySQL databases. It enables you to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events. You can also export structure and data either to SQL file, clipboard or to other servers.

You might also like

Resume Part 1 - any feedback is appreciated!

by Too_Trusting

Highly Skilled Office Professional;
Accounting, Purchasing, Facilities
Computer/Technical Skills
QuickBooks Pro
Digital Copiers/Scanners
MS Office/Word/Excel
MS Publisher, Access, Powerpoint
Website Content
PBX Systems
Qualifications/Skills Summary
Staff Supervision / Mentoring
Office Moves / Space Planning
Purchasing / Vendor Relations
Customer Database Management
FedEx / UPS Internet Ship
A/R / A/P / Payroll, Taxes
Bank Reconciliation
Budgets / Expense Forecasting

What I did

by Werewolf32

Was give up the idea that I should be able to find one career or one job that would keep me interested for the rest of my life. I wouldn't say I'm great at everything I do, but I've done a lot of different things and the best thing I ever did for finding my "purpose in life" was acknowledging that whatever it is, it isn't tied to any one particular career.
At various times I've been a teacher (of music, ESOL, and outdoor education at different times), graphic designer, manager, ship crew, writer/editor, and a bunch of other things. I'm currently doing a part-time course in database administration, so I can have another backup career path if I ever want it

互联网时代的网络自动化运维  — 中关村在线
CMDB(Configuration Management Database) 配置管理数据库(以下简称:CMDB),将IT基础架构的所有组件存储为配置项,维护每个配置项的详细数据,维护各配置项之间的关系数据以及事件、变更历史等管理数据。通过将这些数 ..

Packt Publishing Oracle Enterprise Manager 12c Administration Cookbook
Book (Packt Publishing)
Apress Expert Oracle Enterprise Manager 12c
Book (Apress)
McGraw-Hill Osborne Media OCP Oracle Database 11g Administration II Exam Guide: Exam 1Z0-053 (Oracle Press)
Book (McGraw-Hill Osborne Media)

Related Posts

Copyright © . All Rights Reserved