Configuration consists of setting up the mysql server as a service and of setting passwords for the 2 root and 2 anonymous accounts.
Return to the page containing the table of contents for Chapter 2. Click on 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.
Verify that chkconfig has written the correct entries to the /etc/rc*.d directories.
- /etc/rc0.d, /etc/rc1.d, and /etc/rc6.d should contain K36mysql -> ../init.d/mysql
- /etc/rc2.d, /etc/rc3.d, /etc/rc4.d, and /etc/rc5.d should contain S64mysql -> ../init.d/mysql
Return to the page containing the table of contents for Chapter 2. Click on 2. 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.
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.