This is documentation for an outdated product. See the current documentation

ISPmanager 5 Lite Documentation

Create a database

 

How to manage a database

A database is a collection of data organized by means of a database management system. Normally it is a set of interrelated tables that consist of columns (fields) and records. Databases allow you to manage large amounts of information over the web. They can be used to run web-based applications as well.

To create a new database:

  1. Go to  Tools Databases Add.
  2. Enter a Name for the database.
  3. Select a user who will be the Owner of the database.
  4. Select a Database server that will manage this database.
  5. Select a default Encoding that will be used for this database. An encoding defines the symbols for the data. We recommend using the universal  "utf8" encoding.
  6. Select the database User who will be able to access the database. If you want to create a new user, select "Create new user". Enter the Username and Password
  7. Remote access — check the box to allow the user to access the database from a remote computer. Provide a List of IP addresses from which access to this database will be allowed. For more information please refer to the article Database servers.
  8. Click Ok.