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 !

1 Answer 1


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.

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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