Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

wordpress site and https

Posted on 2016-09-15
10
Medium Priority
?
43 Views
Last Modified: 2016-09-20
This must be the 5th question I have asked in september, versus an average of 2 questions a year previously.  I have just changed the url settings in my wordpress site to https from http and now have lost access (can still ftp).  Is there an easy way to change the url back using ftp?

Some things I have already tried:

I turned wp_debug on
I can't find http settings in the wp--config.php file
I don't see an https setting in the functions.php or vars.php files
0
Comment
Question by:Thomas Zucker-Scharff
  • 6
  • 3
10 Comments
 
LVL 37

Expert Comment

by:Kimputer
ID: 41799921
it's in the database. FTP phpmyadmin files, and login through there (or your ISP already has phpmyadmin).
Should be in the options database, option_id = 1 and option_name = siteurl
0
 
LVL 30

Author Comment

by:Thomas Zucker-Scharff
ID: 41799932
I don't believe I have phpmyadmin, do I?  How would I tell?  I don't believe I have ever seen it (I have seen this when I set up my own wordpress on my local machine).

BTW, I get an error of:"threatswidget_Widget is deprecated since version 4.3.0! Use __construct() instead. in /home1/chronoto/public_html/tom/wp-includes/functions.php on line 3767"
0
 
LVL 37

Expert Comment

by:Kimputer
ID: 41799936
PHPMyAdmin should be available in one of the portal / control panel sites provided by your ISP.
Otherwise, do it yourself, download it from here: https://www.phpmyadmin.net/downloads/
Put it in a folder with a unique name (don't use the standard name, malware/crackers/crawlers just love it).
Point your browser to that url, and it will present you with a login screen, use your mysql credentials to access your WP database.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 31

Expert Comment

by:Marco Gasi
ID: 41799938
No points for this, thanks.
You can download HeidiSQL and establish a connection to your remote database through this light, effective and free software :)
0
 
LVL 30

Author Comment

by:Thomas Zucker-Scharff
ID: 41800004
I am a user when it comes to wordpress.  I have had some success in somethings, but I don't know php or much about the wp core.  So keeping that in mind, How exactly am I suppposed to do this.  Do I upload the phpadmin download?  HeidiSQL seems like a great tool if I can get it to work, no luck so far.  I am not sure of the settings it wants and even if I get them correct will it allow me to access the site files when I have 2fa turned on?
0
 
LVL 37

Assisted Solution

by:Kimputer
Kimputer earned 2000 total points
ID: 41800051
Download the newest zip file from phpMyAdmin, create a a new folder on the FTP server just under the root folder of where your web files are give it a somewhat random name, like phpmyadmin00111--
Unzip or transfer it with the folder structure intact.

create a new config subfolder
move config.sample.inc.php to the config folder and rename it config.inc.php

Now point your browser to:

yourwebsite.com/phpmyadmin00111--

Login with your mysql credentials

If the MySQL server is not the same server as the webserver (for bigger hosting companies), adjust it in the config.inc.php file:

$cfg['Servers'][$i]['host'] = 'othermysqlserver.com';
0
 
LVL 30

Author Comment

by:Thomas Zucker-Scharff
ID: 41800093
I believe I need more help.  I don't know if my webserver and mysql server are different or the same.  My son created this wp subsite on his server. He is very literate when it comes to wordpress, and I have asked him for help as well.  Unfortunately he is at a online journalism meeting for the next couple of days.  Even so I have been communicating with him via google hangouts, but so far, no luck.
0
 
LVL 30

Accepted Solution

by:
Thomas Zucker-Scharff earned 0 total points
ID: 41800108
I have backups, is a restore easier?
0
 
LVL 30

Author Comment

by:Thomas Zucker-Scharff
ID: 41800109
The only error I see in the error logs recently is

[14-Sep-2016 22:01:53 UTC] WPHP-> called: wphp_query_posts_where
[14-Sep-2016 22:01:53 UTC] WPHP-> called: wphp_query_posts_join
0
 
LVL 30

Author Closing Comment

by:Thomas Zucker-Scharff
ID: 41806217
I have decided to go the restore route.  I intend to install the phpmyadmin again after the restore id finished - so thanks Kimputer.  As far as HeidiSQL goes, it looks great, but I, for one, don't know the settings to put in.  If I find this to be the tool of choice - as it looks like it could be -, I will post a comment here regarding that.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
The purpose of this video is to demonstrate how to exclude a particular blog category from the main blog page. This is can be used when a category already has its own tab, or you simply want certain types of posts not to show up on the main blog. …
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question