Configuration consists of setting up the mysql server as a service and of setting passwords for the 2 root and 2 anonymous accounts.
2. Installing and Upgrading MySQL. Click on 2.10.2 Unix Post-Installation Procedures. Scroll down to the paragraph whose first sentence is If you install MySQL from a source distribution or using a binary distribution format that does not install mysql.server automatically, you can install it manually. and read to the line containing the shell command shell> chkconfig --add mysql.
Return to the page containing the table of contents for Chapter 2. Click on/etc/rc*.d directories.
Verify that chkconfig has written the correct entries to the2. Installing and Upgrading MySQL. Click on 2.10.3 Securing the Initial MySQL Accounts. Follow the instructions for securing the 2 root and 2 anonymous accounts.
Return to the page containing the table of contents for Chapter 2. Click oncreate 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.