WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I try the export method of phpmyadmin, but the user is exported with the data... so there is no way to re import it into another database without error message.

The old user is name : oldserver_username, and the new server user is called : some_text_server_name_new_user

So there is NO WAY i can have the same username to export-import... how can i export and re import without having to have username check or bypass that ?

i am completely lost in MySQL !

share|improve this question
up vote 2 down vote accepted

The database user name/password is not stored in the database; it is only used to access the database. Change the username (and password, too) to the new values in wp-config.php.

And the problem might be access to the database via phpmyadmin; check your username/password in Cpanel or some other hosting control panel.

share|improve this answer
in phpmyadmin, the import fail... user (old one) not allow to access database – menardmam Mar 27 '12 at 15:51
Your login/password is wrong; reset that in Cpanel or some other control panel at the host. – markratledge Mar 27 '12 at 16:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.