MySQL account is the simplest security measures. Each account by the user name, password, and location usually by a server name, IP or wildcard component. Such as user john from server1 log john may be different from the right to log on server2. MySQL's user structure is the user name / password / location. This does not include the database name. The following two command database1 and database2 set SELECT user rights.
Code:
GRANT SELECT ON database1 .* to 'xyz' @ 'server1' IDENTIFIED BY 'password123';
GRANT SELECT ON database2 .* to 'xyz' @ 'server1' IDENTIFIED BY 'password211';
Bookmarks