6.2.1  Export user data from MySQL

We use the

mysqlaccess

 utility to get the user names that have access to the 

database 

itsodb 

out of the MySQL databases. See Example 6 10.

Example 6 10   Retrieve users with access to the sample project database

bash>mysqlaccess % % itsodb  b  U root

mysqlaccess Version 2.06, 20 Dec 2000

...

Sele Inse Upda Dele Crea Drop Relo Shut Proc File Gran Refe Inde Alte Show Supe Crea 

Lock Exec Repl Repl Ssl_ Ssl_ X509 X509 Max_ Max_ Max_ | Host,User,DB

                                                       +                     

 Y    Y    Y    Y    Y    Y    N    N    N    N    N    Y    Y    Y    N    N    Y    Y    

N    N    N    ?    ?    ?    ?    0    0    0   | %,itsosj,itsodb

 N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    

N    N    N    N    N    N    N    N    N    N   | %,root,itsodb

 N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    

N    N    N    N    N    N    N    N    N    N   | %,Michael,itsodb

 N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    

N    N    N    ?    ?    ?    ?    0    0    0   | %,Klaus,itsodb

 N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    

N    N    N    N    N    N    N    N    N    N   | %,ANY_NEW_USER,itsodb

 Y    Y    Y    Y    Y    Y    N    N    N    N    N    Y    Y    Y    N    N    Y    Y    

N    N    N    ?    ?    ?    ?    0    0    0   | localhost,itsosj,itsodb

 Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    Y    

Y    Y    Y    ?    ?    ?    ?    0    0    0   | localhost,root,itsodb

 N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    

N    N    N    ?    ?    ?    ?    0    0    0   | localhost,Michael,itsodb

 N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    

N    N    N    ?    ?    ?    ?    0    0    0   | localhost,Klaus,itsodb

 N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    N    

N    N    N    ?    ?    ?    ?    0    0    0   | localhost,ANY_NEW_USER,itsodb

6.2.2  Map MySQL user data to DB2 user data

The 

root

 user is the database administrator and is not used by our sample 

application; we do not want to migrate this user. The MySQL 

root

 user is similar 

to the instance owner in DB2 UDB.

The users 

Michael

, 

Klaus

 and 

ANY_NEW_USER

 (which is similar to the logical DB2 

group 

PUBLIC

) do not have any privileges on our sample database, so we do not 

need to migrate these users either.

The only remaining user is the user 

itsosj

. This one is the user our application 

uses to connect to the MySQL database and to manipulate data.

We want to add a new group for this user called 

db2app1

.

 Chapter 6. Data porting 

147