MySQL Setup

Previous Top Next

---

Collections MAX uses MySQL Enterprise 5.0 or greater as a database to store information. There are many different platforms to install MySQL so we will not cover them all here.  You can find more about installing MySQL for your specific server operating system at

http://dev.mysql.com/doc/refman/5.0/en/installing-es.html

Note:  DO NOT install MySQL Enterprise in strict mode.

Installing MySQL in strict mode will cause importing of account data to fail!

Make sure you uncheck the box if prompted.

Windows Installation

After you have received MySQL Enterprise open the folder and double click on the Setup Icon

Next, Choose the Complete Installation

Click Next to Install the Program

The Program will install and then you will be prompted to configure the server.

Click Next to Configure the Server (Leave Check box checked)

Click Next to Configure the server instance

Choose Detailed Configuration and click NEXT

Choose Transactional Database Only and click NEXT

Choose the installation path for the Inno DB Database files.  If you have a

faster disk on your system make sure to choose it.  Click NEXT.

Depending on the number of users you have, choose Manual Setting and then

choose the number of concurrent connections.

TIP:  Don't put this number to high if you don't have enough RAM.

Also, don't put it too low if you are going to serve a large amount of

collectors.

Enter your ROOT password.  This is the MASTER password for MySQL

Don't forget this!!!   Click NEXT.

If you are going to connect MySQL over a network, check the box that says Enable TCP/IP Networking.

MAKE SURE NOT to check the box that says Enable Strict Mode!!!

Note:  DO NOT install MySQL Enterprise in strict mode.

Installing MySQL in strict mode will cause importing of account data to fail!

Click Execute to finish Installation.  Make sure to reboot computer after this.