database error WordPress move from one hosting to other

The credentials for your database are located in the wp-config.php file. Make sure those settings are correct.

In particular, non-ASCII characters may be causing a problem. Or an extra space in any value (especially the password).

Look at the user/pass/dbname in your host also. An extra space at the end of the password in wp-config or on the host, for example, can cause authentication errors.

I’d reset the user/pass via your hosting cPanel, making sure no extra spaces or non-ascii characters in those fields. Then make the wp-config.php file match exactly.

Related Posts:

  1. Restoring WordPress posts from database only
  2. How to move existing WordPress wp-content folder along with database to new server and new domain name?
  3. How do I copy a wordpress database?
  4. “Error establishing a database connection” – Intermittent error on GoDaddy
  5. Best host for running large mem and processor intensive WordPress sites?
  6. restore a db after bad backup
  7. Is my way to change WordPress server is correct?
  8. Migrated to Namecheap, now Trouble with Database & wp-config [closed]
  9. trying to install wp but i have no clue on hosting and servers [closed]
  10. Can I connect WordPress website with an external database?
  11. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  12. Oracle SQL query for Date format
  13. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  14. Can I have multiple primary keys in a single table?
  15. Using wpdb to connect to a separate database
  16. Database connection close
  17. How to stop WordPress using utf8mb4_unicode_520_ci collation?
  18. How to create bulk page and content? [closed]
  19. Importing posts from old website to new conflicting post ID’s?
  20. Exporting revisions
  21. WP_Options ID high
  22. The revisions table in my database is at 70% capacity and growing. What should I do?
  23. WordPress for a very large website
  24. How to use multiple database in wordpress?
  25. WP_list_table bulk_action get edit and delete
  26. How to display data from custom table in wordpress database?
  27. Is removing orphaned wp_postmeta records safe?
  28. stdObject stored in database. How does one convert it to usable format?
  29. I have a table I created, how do I make a form for a user to filter the data?
  30. What ALL can cause “Another update is currently in progress.”? [closed]
  31. Error connecting to DB in /wp-includes/wp-db.php on line 1538 [closed]
  32. Set Display Name to first and last name (phpmyadmin SQL Query)
  33. Trigger Plugin database update after git pull
  34. Does WordPress ever need multiple databases?
  35. Why are no posts showing despite my apparently correct DB restoration?
  36. How to query the WordPress database to get posts of a certain custom post type, taxonomy and field?
  37. Cannot update custom database table row
  38. SQL Error wp_commentmeta – incorrect table definition
  39. Change WordPress prefix for only one table?
  40. Two websites one database, administrator not working on second website
  41. Select two sums with single get_var statement
  42. How to get the SQL of the changes made to the database from an update or upgrade?
  43. Merging two wp_posts tables while avoiding duplicates
  44. How can i add custom fields into the contact form 7 [closed]
  45. Make an Items attribute searchable (taxonomy using existing attribute)
  46. Store partial database to an archive database time to time
  47. Move out of sync posts from one database to another
  48. MS Access to manage WordPress Database
  49. Migration: Copying database content to a different server
  50. Remove empty rows from the database
  51. Custom WordPress Table wpdb
  52. Check if post id exist in table than only update instead of inserting new row
  53. Detail explanation of wordpress database fields and metatag list [closed]
  54. CreateOrUpdate in WordPress
  55. $wpdb->get_results($wpdb->prepare(… You have an error in your SQL syntax;
  56. How to convert srcset links from https to http?
  57. How to get a list of WordPress default database tables?
  58. Can local WordPress installs share /wp-content/ folder and database?
  59. Stringing together content from different databases
  60. Backing up WordPress database and files
  61. Safely store code(html/js..) into database
  62. Creating and Using Tables in the WordPress Database
  63. Connect a membership plugin to an external database
  64. Compare User meta_value with Product meta_value
  65. Storing user’s data on external database on other server
  66. is it right choose to connect database in template page directly in WordPress site?
  67. How to insert a value to decimal type field using wpdb->prepare?
  68. Sql query to get all metadata for a post
  69. Two separate wordpress installations at one domain
  70. Is there a way to edit the WP content database in an admin panel or external page?
  71. Where do I put my create_new_table function()?
  72. SQL database import #1046 error
  73. How to import products in host instead of database on wordpress?
  74. Get all top categories, then only 3 posts for each
  75. Having all “non-PHP” files on a different server
  76. syntax error for changing user role from database
  77. Finding a page holding a specific string/URL that is used in the content
  78. “wordpress error in establishing database connection” and missing tables
  79. get_option() does unserialize and don’t remove \
  80. Set SQL_BIG_SELECTS and MAX_JOIN_SIZE on a WP_Query
  81. How to optimize wp_option table?
  82. How can I get $wpdb to show MySQL warnings?
  83. About wp database hooks (error establishing connection)
  84. How to display $wpdb->insert_id; value on redirected page
  85. Database for JQuery Autocomplete field
  86. Create Tables in WordPress
  87. Catchable fatal error in formatting.php
  88. Wrong url for the images while using same database for two WordPress installations
  89. WordPress Failed to Login (DB Error)
  90. Sending WordPress database information to cross domain the safe way?
  91. Database Name Change
  92. Share WordPress Database
  93. Where To Find bb_profile_data(); In bbPress?
  94. ERROR: “Table Prefix” must not be empty
  95. How do you build a database-centric site in WP?
  96. WordPress: Interact with Database Query Data and Login
  97. Attach posts based on category and position
  98. wp_usermeta key problem
  99. Database Queries are crashing the server
  100. Uploading to WordPress Database