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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved