How to Change the default SQL Port Number of WordPress last installed on our Localhost phpmyadmin?
WordPress is one of the CMS (Content Management System) very helpful for blogging and creating any website as required from personal to the business purpose. But during installation or during the running process you may get several errors. Last time, I have also got an error after changing Apache default port 80 to any of 8080, 8088 or any just for WordPress File so “Change the default SQL Port Number of WordPress” to fix this issue.
For this, I got an idea on how to solve this issues by Changing the default SQL Port Number of WordPress last installed on our Localhost phpmyadmin that I am going to share with you. The process that I am going to mention is very simple and easy process you can follow along with this article.
NOTE: For this process, at first you need to Change the default SQL Port Number of WordPress last installed on our Localhost phpmyadmin to some other ports like localhost:8088. Before this, follow my previous link:
“How to change the port number of XAMPP Control Panel from localhost to localhost: 8088 or any as you preferred” if you have any problem regarding changing the Apache default port 80 to any of 8080, 8088 or any then after, follow this article:
- At first go to “localhost: 8088/phpmyadmin/” and I guess you have your phpmyadmin running.
- Then after, click on your WordPress phpmyadmin Database like “udemy” I have, you may differ.
- Then click on “Export” and go to:
- Export method:
Check marks on “Quick – display only the minimal options”
- Format: SQL
- Then click on “Go”
You have your SQL extension Database installed like udemy.sql
- Open this Database in any text editor and look for: http://localhost/udemy and change this to
http://localhost:8088/udemy for all and Save the file.
- Then after, go to http://localhost:8088/udemy in any browser > Structure > either check all or manually select and drop all. Finally, you have empty within your phpmyadmin of that required folder, don’t worry. I have also same issues.
Note: This is done to remove conflict when importing the updated udemy.sql file.
- Click “Import” > Go to File to import:
Browse your computer: choose File (here choose your own SQL Database, for me udemy.sql, you may differ).
- Finally, you have your WordPress file running.
- But at last, within WordPress, go to Settings and don’t forget to update Permalinks.