The configuration wizard presents you with the following configuration defaults. Go with the defaults except where noted otherwise.
- Detailed Configuration
- Multifunctional Database
- default InnoDB Tablespace Setting
- Decision Support (DSS)/OLAPA
- Enable TCP/IP Networking (using Port Number 3306)
- Enable Strict Mode
- Use UTF-8 instead of the Standard Character Set
- Install As Windows Service (Service Name = MySQL with the service started automatically)
- Modify Security Settings (you must provide a root password (twice) and if you deinstalled an existing MySQL database, you must provide a current password)
You may optionally request that the bin directory be added the the Windows PATH environment variable. Do so. The wizard will add that directory to the end of %PATH%. The bin folder contains the libmysql.dll used by the MySQL provider.
The configuration wizard creates a configuration file (C:\Program Files\MySQL\MySQL Server 5.0\my.ini). It starts the MySQL service (mysqld) using options specified in my.ini.
You can use the Fdo User Manager API to create a user account with the usage privilege if you are using the enterprise version of FDO. Otherwise you can use the 2 SQL commands, create user <user> identified by ‘<password>’ and grant select, insert, update, delete, create, create view, drop, index, alter on *.* to ‘<user>’@’%’ identified by ‘<password>’. In either case you must be connected as a user, for example, root, with the grant privilege. The value <user> can be ‘<username>’@’localhost’ if the connection local, or it must be ‘<username>’@’,hostname.’ if the connection is remote. The value of <hostname> is <host label>.<domain name>, for example, someComputer.someCompany.com.
You can use the Fdo Data Store Management API to create a data store.