Toolpack migration Debian4 2-3

Revision as of 15:15, 19 May 2009

This page shows the Toolpack 2-4 migration guide for Debian 4.

Toolpack Migration Steps

Create new database user

Connect to MySQL and create a new user tbdb with all privilege.

 mysql -u root
 CREATE USER 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
 GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY '[DatabasePassword]';
 exit

Example

 mysql -u root
 CREATE USER 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 GRANT ALL privileges ON *.* TO 'tbdb'@'%' IDENTIFIED BY 'tbdbpw';
 exit

Install ODBC MySQL connector

 apt-get install libmyodbc

Configure ODBC driver manager

 odbcinst -i -f /usr/share/libmyodbc/odbcinst.ini -d

Restart MySQL service

 /etc/init.d/mysql restart

Toolpack System installation

Now that the prerequisite are installed, we can go back to the migration guide Toolpack migration 2-3.