Weird issue with database migration and SSL links

Found a problem. Basically there were 2 options that forced my permalinks to https:

  1. Settings > General: change the site url from https to http.
  2. SEO by Yoast plugin, under section permalinks needed to change Canonical Settings to force HTTP.

Related Posts:

  1. Multiple developers / editors working on a site in progress
  2. How can I make updates to a site, on a development copy, but then move updates back without overriding live site’s evolving database?
  3. Fastest way (least amount of steps) to locally import a remote database using WP-CLI
  4. Solution for database version control and deployment?
  5. How to migrate a HTTPS WordPress installation to localhost?
  6. How can I migrate from another platform to WordPress (using the same domain) and launch when ready?
  7. Migrating data between local and development server
  8. Best way to import users, post and categories from an external database
  9. Syncing local content with development / staging sites
  10. Organizing WP Pages based on old website database
  11. Presentation vs Content in WP DB-Tables
  12. Migrating non-WordPress CMS to WordPress, lots of data to move — possible solutions?
  13. Migrate a Non WordPress database to wordpress [closed]
  14. How to fix unchanged URLs in Database after running serialized search and replace script?
  15. WordPress DATABASE Update Manually?
  16. Migrating database / content of non-CMS site to WordPress
  17. How do I reset a self-hosted WordPress URL?
  18. I don’t see site_url and home_url fields in wp_options table (phpMyAdmin)?
  19. Export all content from wordpress
  20. Migrating WordPress from DreamHost to Azure WordPress Resource via UpdraftPlus “wp_options table does not exist…” error
  21. Moving minor updates between local and live sites – just database?
  22. How to move the WordPress site Layout from test site to Production site?
  23. Merging two databases without borking it
  24. Why does importing copies of the database dump and the document root make WordPress data inconsistent?
  25. Able to use all admin pages but in the frontend there is a “Error establishing a database connection”-Error
  26. Trouble Migrating all data blog from WordPress.com to WordPress.org
  27. Copying database tables to new database
  28. Migrating from PDO using SQLite to clean new install using MySQL
  29. Migration: Copying database content to a different server
  30. Change WordPress URL in sql file via Terminal
  31. Strange characters added to the database
  32. After database migration, theme mods don’t show [closed]
  33. Problem migrating to localhost
  34. WordPress url transformation script
  35. How to transfer from localHost to live but use the already existing database on the server?
  36. Image link issues after importing a database backup to my local web server
  37. Database migration issues – Error #1046 No database selected
  38. echo site_url() returns a different value than what is in the database siteurl field
  39. Migrate Users From laravel to wordpress
  40. /wp-admin not accessible after migrating to local host (no plugin issue)
  41. How to fix Uploaded to this post option to see group of images uploaded to a post?
  42. How do you enable scripts on a WordPress installation in Softaculous?
  43. WordPress site migration – locked out of admin area
  44. Malware in old website – how to migrate?
  45. WP website showing blank page after moving from subdomain to main domain
  46. WordPress Migration – Issue with admin panel changes
  47. Do I need to be selective about where I search and replace when pointing a domain to a subfolder used for development?
  48. How to edit posts/pages without making the change live?
  49. Migrate not successful, DB is broken. How to fix, or at least output static HTML without plugins?
  50. After Migration From dev, Only my Links to the Homepage Still Redirect to dev
  51. I cannot change anything in my wordpress database from within wordpress?
  52. Media library images “missing” after migrating them using SQL
  53. Restoring .sql backup results in “Error establishing a database connection”
  54. import (migration) user database to wp-users
  55. Database question while Migrating from one domain to another on same WebHost [Bluehost]
  56. Moving database from WP 2.6 to 3.5 problem
  57. Importing Concrete5 content to WordPress
  58. Getting an error when trying to migrate to DV server from Grid with Media Temple [closed]
  59. How to properly configure SSL connection to remote azure database for running queries within a WordPress environment
  60. Database not loading after transfer via phpmyadmin
  61. What is an ORM, how does it work, and how should I use one? [closed]
  62. What is the difference between an ORM and an ODM?
  63. What is this JavaScript “require”?
  64. Rename a table in MySQL
  65. How should I tackle –secure-file-priv in MySQL?
  66. What is this JavaScript “require”?
  67. What is “Advanced” SQL?
  68. What’s the difference between identifying and non-identifying relationships?
  69. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  70. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  71. Can’t connect to MySQL server on ‘127.0.0.1’ (10061) (2003)
  72. What are the differences between B trees and B+ trees?
  73. MySQL SELECT increment counter
  74. How to resolve ORA-011033: ORACLE initialization or shutdown in progress
  75. Example of a strong and weak entity types
  76. Oracle SQL query for Date format
  77. phpMyAdmin – Error > Incorrect format parameter?
  78. Strange Characters in database text: Ã, Ã, ¢, â‚ €,
  79. Difference between partition key, composite key and clustering key in Cassandra?
  80. How SID is different from Service name in Oracle tnsnames.ora
  81. What is a relation in database terminology?
  82. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)
  83. Database vs File system storage
  84. Can I have multiple primary keys in a single table?
  85. Exclude Statement in SQL
  86. How do you query for “is not null” in Mongo?
  87. What is a file based database?
  88. Is it fine to have foreign key as primary key?
  89. Storing Images in DB – Yea or Nay?
  90. Using wpdb to connect to a separate database
  91. how to Optimize WordPress database for 10 million post? [duplicate]
  92. MySQL Database User: Which Privileges are needed?
  93. Why is my database import losing text widget data?
  94. After server migration only the homepage works
  95. Database synchronization between dev/staging and production
  96. Keeping WP database synced across multiple developers using git
  97. WPDB Insert or if exists Update
  98. get_results using wpdb
  99. Will it break my site if I delete all transient records in wp_options table?
  100. Checking if Database Table exists
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)