About the MySQL Database Manager
The MySQL Database Manger is a powerful tool that allows you to create, manage and administer MySQL databases on your website. Built upon the popular open source utility, phpMyAdmin, DB Manager includes an intuitive GUI that lets both novice users and seasoned database administrators work quickly and efficiently. This guide is a comprehensive resource covering all features of DB Manager. After reading it, you will know how to:
- create databases (either from scratch or by importing data from another source)
- delete databases
- design and populate tables
- set up user accounts so that others can access your data
- export databases
You will also gain a basic understanding of SQL, or Standard Query Language. SQL is a command language consisting of keywords like SELECT, INSERT and DROP and the syntax governing how they may be used (SQL statements are also known as queries). You can type queries directly or use the GUI to build them visually; regardless of the method you choose, DB Manager displays the queries generated as feedback.
To access Database Manager:
Click the Database Manager icon on your Control Panel.