<div>
Can I send you a copy of the backup so you can see what lines I need to delete?
</div>


Can I send you a copy of the backup so you can see what lines I need to delete?

<div>
Don't worry think I've sorted it.
</div>


<div>
Thanks for your help, I had to delete a line from the script.
</div>


Thanks for your help, I had to delete a line from the script.

<div>
<div class="content wysiwyg-content">
When trying to transfer a wordpress sql database using phpmyadmin from my existing Windows server to my new Linux server I get the following error message see below.<br />
<br />
#1044 - Access denied for user 'name'@'%' to database 'wp_name'<br />
<br />
I've replaced the name of the database and username with name, I've tried keeping the database name the same and it says it already exists, I've kept the username the same as the current username and it says it doesn't have permission, where am I going wrong?<br />
<br />
I've searched the error message and nothing helps me resolve this, I have a number of domains to transfer with wordpress databases and this is stopping me from doing so at present.
</div>
</div>


When trying to transfer a wordpress sql database using phpmyadmin from my existing Windows server to my new Linux server I get the following error message see below.

#1044 - Access denied for user 'name'@'%' to database 'wp_name'

I've replaced the name of the database and username with name, I've tried keeping the database name the same and it says it already exists, I've kept the username the same as the current username and it says it doesn't have permission, where am I going wrong?

I've searched the error message and nothing helps me resolve this, I have a number of domains to transfer with wordpress databases and this is stopping me from doing so at present.

Transfering sql database using phpmyadmin

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

WordPress is a free and open-source content management system (CMS) based on PHP and MySQL for creating websites and blogs. Features include a plugin architecture, a template system and strong management, customization and search systems; through its dynamic presentation of content, webmasters have the flexibility to create websites easily.