After WordPress Network migration to new getting problems!

Hi,

I have a WordPress Network with subdomains. I exported the db – imported in the new host. Backed up the files and moved to new host. Changed the username/password in wp-config file for correct username/password.

Now I the main site is visible https://mainsite.com but the subdomains are not (https://sd1.mainsite.com, https://sd2.mainsite.com etc) I am able to login the dashboard of network and main domain but when I try dashboard of subdomain I am getting the following error:

Can’t select database
We were able to connect to the database server (which means your username and password is okay) but not able to select the prefix_wrd1 database.

?Are you sure it exists?
?Does the user prefix_wrd1 have permission to use the prefix_wrd1 database?
?On some systems the name of your database is prefixed with your username, so it would be like username_prefix_wrd1. Could that be the problem?
If you don’t know how to set up a database you should contact your host. If all else fails you may find help at the WordPress Support Forums.

Please let me know if anyone have any solution.