These settings are applied to all php pages and features with MySQL database (as Shop, Catalog, Blog, Calendar, Newsletter, Online Editable Page, Counter, etc) functions. MySQL is a database management system that runs on your web server providing access to databases created or saved on the site. For example, the list of names and email addresses your mailing list or shop has collected. This data is managed by a MySQL server. You only need a single MySQL database for your website.

  • Use MySQL for all online scripts (check box) - Shop and catalog pages always use MySQL database. While Blog, Calendar, Search, Counter, Podcast, etc can work with both flat (plain text) files and MySQL database. If you want to have all PHP features to work with MySQL, check this box and set the MySQL settings below.
  • Host Name or IP (edit box) - Enter the hostname of the MySQL server. Most servers use "localhost" as the host name, enter that if you do not have a specific server name.
  • Database Name (edit box) - Type the database name to be used. e.g. MySite_SQL_Database
  • Username (edit box) - Username for the database login.
  • Password (edit box) - Password for the database login.
  • Project ID (check box)- If you use single MySQL database for multiple projects, make sure to define here project ID. This ID should serve as a unique prefix.
    On some hosts, your provider will have already created a database for you. If this is your case, you don't need to create database, just fill the database settings. For example: on, there is already database created and you can't add new databases. If you don't have a database, then you have to create one. On most hosts you will have some utility to manage databases. You can use this utilty to create a database. If you are not sure how to create database, contact your provider or check documentation for your server.
  • Monitor Users (check box) - Use this to monitor how many guests and registered users are browsing your site. EZGenerator Counter is required for this feature. Also, you have to add %GUEST_COUNT%, %USER_COUNT%, %USERS% macros from Macros Fields. These macros are available in the php pages such as Blog, Calendar, etc.


  •  What's the use of Project ID (a.k.a. project prefix)?
    • As mentioned above, multiple projects can be handled by same database. So that means there will be several "users" table (for instance). If many projects use same tables, it will become a project mess. Here the use of project prefix comes in hand. By defining unique table prefix for each project, you ensure the systems won't put data into wrong tables.
  • How to use Project ID (what kind of wording to use in this field)?
    • Full information about the naming can be found here: However, I suggest using only lower case letters and underscore ( _ ).
      Table without prefix: ca_users; Table with prefix test_: test_ca_users
      Note: I use underscore after the letters, because it's easyer to read the tables when you open the tables list via external tool. But it's not required.
  • When to use Project ID?
    • The simple and most correct answer is: ALWAYS. If you have only one project so far and it has no project ID yet, don't change this (adding project prefix to current tables will force tables to be duplicated). But make sure all future projects will have project prefix, and it will be unique for every project.
mySQL • settings