Moving wordpress from one domain to another and phpmyadmin

[bobrock4]

Hi all, I have moved a site made in wordpress from a domain (domain1.com) to a different one (domain2.com).

I have created a new db and I have been forced to give to it a different name, because in my cpanel mysqldatabases you can create db using only a prefixed db name structure (such as namehosting_(empty field)).

So from database nama namehosting1_wp, I have forced to create namehosting1_wp, changing parameters in wp_config.php I have also forced to change db user for the same reason.

I have gone to phpmyadmin to import the sql database previously exported from domain2.com. It gives to me this message: #1044 - Access denied for user 'nameuser'@'localhost' to database 'information_schema'.

It seems that I have not right privileges. Or should I follow some other procedures?

Thanks and ciao Bob

[bobrock4]

Hi, you have given right solutions and good stuff to read. But there are some issues in my hostings that I'm not able to solve also with this support. This is  a particular case. Don't mind and thanks for your support Bob

[DeanAndrews]

Sorry if I have given the impression that moving a WordPress site is hard. It's fairly straight forward if you follow the instructions given.

[bobrock4]

Thanks CodingStuff for your good reply and material you have given to me. I have understood that this moving is not so simple. Ciao. Bob

[DeanAndrews]

Hi,

You could use something like Back up Buddy to migrate the site here

There are plenty of guides from WordPress themselves here and a different approach by Yoast here

Hope that points you in the right direction.