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 . Click on . Scroll down to the paragraph whose first sentence is 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.
Return to the page containing the table of contents for Chapter 2. Click on . Click on . Follow the instructions for securing the 2 root and 2 anonymous accounts.
If you get an error message like when setting the password for the ‘’@’<hostname>” or the ‘root’@’<hostname>’ account, verify that the IP address that <hostname> maps to in the /etc/hosts file is correct.
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.
If you enabled remote root access when you installed MySQL, you can create user accounts by way of a remote connection. Otherwise, you will have to connect locally in order to create a user account.
You can use the FDO Data Store Management API to create a data store.