when I mysqldump a DB of a openfire server to another, I cannot login it use the same username&password, how can I do?
Some time ago I had the same problem.
Have a look at this thread:
NEED HELP: migrating openfire database (mysql)
Maybe you also (at first) need to set the setup value in the openfire.xml to false.
I entered my settings afterwards and finished setup. All userdata and stuff that was stored in the database (like kraken accounts) were accessible after i finished the setup.
Hope this helps!