Configuration

Feature Data Objects API

 
Configuration
 
 
 

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.

Notechkconfig uses a commented line from the /etc/init.d/mysqlfile, namely, # chkconfig: 2345 64 36

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.

NoteIf you get an error message like ERROR 2003 (HY00): Can’t connect to MySQL server on ‘<hostname>’ (<somenumber>) 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.

NoteIf 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.