There are a few cases where you might need to go in and change a URL in the WordPress database.
|
This requires a little MySQL trick. It's two simple edits in the database. |
1. First, make sure that your WordPress installation is complete, and you know what the name of the database is. If Fantastico installed WordPress for you, it's likely the name of the database is something like:
or
and so forth. |
If Simple Scripts installed WordPress for you, it's likely the name of the database is something like: |
|
2. If you don't know the database name, you can use the File Manager to look inside the wp-config.php file to find out its name. |
3. Right click wp-config.php and select Code Edit. You can now see the database name. |
4. Next, log into your cPanel. Look for the Databases section. |
5. Select the icon named phpMyAdmin (looks like a sailboat.) |
6. Once here, you need to select the database name on the left. (i.e. "_wrdp1") |
7. This will display the names of the Tables to the right. Click on the one called "options". |
8. Now there are icons to the right of the tables. The First one is called "Browse". Click "Browse". |
9. Next, the database entries are listed in columns and rows. You want to select the pencil icon (for Edit) on the left for the VERY TOP row (option_name is "site url") |
10. Once you've clicked the pencil icon, you will see your domain name listed something like this:
|
11. You want to change that to something like this:
|
12. This step is crucial you don't make a mistake. Please take a moment to verify the URL you are typing in here is correct, or you won't see any change. |
13. Once you've changed the URL, down at the bottom there is a "Go" button. Select the "Go" button. |
14. This will save your URL change and should show a screen like this: |
|
15. Select the pencil icon for Edit. |
16. Make the same URL change here as you did for siteurl earlier. And click the "Go" button. |
17. Visit your Temporary URL (http://70.103.189.86/~username/blog/) for your blog, and all the images will show up just fine. |
***Follow-up |
|
- 113 användare blev hjälpta av detta svar