Using WinMySQL Professional

New database

Only accessible when connected, the «Server management>New database» submenu allows a DBA to create a new database. In information technology terminology, the database is the recipient which contains the tables.

With WinMySQL Professional, it is very easy to create a database : just invoke the «Server management>New database» submenu to open the small database creation window, then just enter a database name and click on the «Add Db» button.

The next step will consist in tables creation. To do, see «Submenu File>New MySQL® table» or «Submenu File>New MySQL® table from dBaseIII+®» sections.

Don't forget to create users for this database or grant existing users privileges : see «Server administration>Manage users privileges»