Install MySQL 4.1

• Click on /u/mvs/au/inbox/setup.exe again.
• On the setup type window, choose the "custom" setup type option.
• On the program features window, click the "CHANGE" button and enter "c:\u\mvs\mysql" or the correct path for %MVS_ROOT%\mysql.  The Developer Components option should have a red x next to it so it will be excluded from the installation.  All other components should be included.
• On the MySQL.com Sign-up window, choose the "Skip Sign-up" option
• On the Wizard Completed window, check the box for "Configure the MySQL Server now".
• On the Configuration type window choose the "Detailed Configuration" option .
• On the server type window choose the "Server Machine" option.  (not a developer or dedicated machine).
• On the Database Usage window, choose the "Non-Transactional Database Only" option.
• On the concurrent connections window, choose the "Manual Setting" option.  If they have fewer than 20 Profits Plus users then choose 20 users, otherwise choose a number that will cover all Profits Plus users plus 5 more.
•  On the networking options window, check the "Enable TCP/IP Networking" and set the Port Number: to 3306.
• On the default character set window, choose "Standard Character Set".
• On the Windows option window, check the box for "Install As Windows Service" and Choose the Service Name for the version you are installing, example: MySQL41_mvs.   And check the box for "Include Bin Directory in Windows PATH".
• On the security options window, check the box for "Modify Security Settings".  give a root password of mysql1  and check the box for "Enable root access from remote machines".  Un-check the box for "Create An Anonymous Account".
• On the Ready to execute window, click the Execute button.  An error window might display if a firewall (Zone Alarm) asks "Allow mysql to access the local area network".  In that case you need to tell the firewall to allow it and then click "Retry" on the mysql error window.  When it tells you to, click the Finish button.
• The my.ini file is created in the installation folder c:\u\mvs\mysql\my.ini. Leave it there. You won't need a my.cnf file at all.

Grant privileges and set passwords:
Start the MySql client in a dos prompt window by selecting the MySQL command line client from the Windows START menu. Enter the root password mysql1.  It will give you a MySQL command line so you can enter the following commands

mysql> GRANT ALL PRIVILEGES ON *.* TO 'mvuser'@'localhost' IDENTIFIED BY 'mvuser1' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'mvuser'@'%' IDENTIFIED BY 'mvuser1' WITH GRANT OPTION;

mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mysql1' WITH GRANT OPTION;

mysql> SET PASSWORD FOR 'mvuser'@'localhost' = OLD_PASSWORD('mvuser1');

mysql> SET PASSWORD FOR 'mvuser'@'%' = OLD_PASSWORD('mvuser1');