The configuration wizard presents you with the following configuration defaults. Go with the defaults except where noted otherwise.
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.
You may optionally request that theC:\Program Files\MySQL\MySQL Server 5.0\my.ini). It starts the MySQL service (mysqld) using options specified in my.ini.
The configuration wizard creates a configuration file (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 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,You can use the Fdo Data Store Management API to create a data store.