9. Drop the temporary DB2 table:

db2>drop table tempdb2.blobdata

10.. For each BLOB that you want to migrate, proceed from step 3.

6.1.3  Differences in the user account management

The way the user information's access rights and privileges are stored in MySQL 

is completely different from DB2 UDB.

MySQL user account management

Migrating the user account management from MySQL to the DB2 security 

system requires knowledge about how the user account management data 

affects your application, and how user data, passwords, access rights, and 

privileges are stored in MySQL. 

User data

When assessing your application, be sure to distinguish between the following 

user types:

Database users

These users connect directly to the MySQL database to retrieve and 

manipulate data. At least one database user must exist for applications to 

connect to the database. These users are typically stored in the

 mysql.user 

table and must be migrated in data porting step. Access rights and privileges 

for these users are stored in the 

mysql.db

, 

mysql.host

, 

mysql.tables_priv

,

and 

mysql.columns_priv

 tables.

Application users

These users log on to the application, but do not exist on the database level. 

Database access is through the application with the application's database 

user ID. As the information about application users is usually stored in custom 

application tables, the migration of application users is done when migrating 

the MySQL application data.

Passwords

Database users typically have associated passwords, which are stored 

encrypted in the 

mysql.user

 table. Encrypted passwords cannot be migrated and 

must be reset on the new system. The password of the database user that is 

used by an application to access the database is typically stored in a profile with 

restricted rights.

Note:

 The migration of encrypted passwords is impossible, because it is the 

intended purpose of encryption functions to make password unencryptable!

138 

MySQL to DB2 UDB Conversion Guide