Toolpack migration Debian4 2-3

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. If you are unable to connect, use an IP Address instead of the [HostName].

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

Example

 mysql -u root -h debian64-01
 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.