PROJECT SETTINGS

MySQL

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 www.one.com, 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.