MySQL 4.1 example

1. Run the MySQL database post-installation step:

       ./bin/mysql_install_db --user=mysql

2. Check access rights. The file owner must be the user mysql:

       cd /var/lib/mysql/mysql
       chown mysql *

3. Start the MySQL server. In case of problems, check /var/lib/mysql/mysqld.log file for errors. You can use the startup script typically provided in /etc/rc.d:

       mysqld_safe --user=mysql &    

   Tip: The mysqld.log file is not in the /var/lib/mysql directory for all Linux distributions.
4. Secure the installation by removing the anonymous user, and setting the root password (xyz):

       mysql -u root
       delete from mysql.user where user='';
       update mysql.user set password=password('xyz');
       flush privileges;
       quit;

5. Require a password for connecting to the database:

       mysql -u root -pxyz

6. (Optional) Allow remote access from another computer identified by its IP:

       grant all on *.* to 'root'@'192.168...' identified by 'xyz';
       flush privileges; 

7. Create a new database for Tivoli® Provisioning Manager for OS Deployment

       create database tpmfosd character set utf8;

dbgw.jar is a Java™ implementation of the TCP-to-ODBC database gateway, using JDBC instead of ODBC for database access.

1. Download and extract MySQL Connector/J, which you can find at http://dev.mysql.com/downloads/connector/j/3.1.html. The mysql-connector-java-3.1.8-bin.jar file is now in the Connector/J directory.
2. Create a symbolic link in the Tivoli Provisioning Manager for OS Deployment installation directory:

   cd /usr/local/tpmfos
   ln -s XXX/mysql-connector-java-3.1.8-bin.jar mysql.jar

3. In another terminal, check the database connectivity:

    telnet 2020 
    use mysql://127.0.0.1/tpmfosd?useUnicode=true&characterEncoding=UTF-8,
    root,<password>

   If you are using MySQL Connector 5.1, you can check the database connectivity as follows:

   "use mysql://127.0.0.1/tpmfosd?useUnicode=true&characterEncoding=
   UTF-8&useOldAliasMetadataBehavior=true";