?
Solved

wordpress site and https

Posted on 2016-09-15
10
Medium Priority
?
52 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 31

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
Worried about phishing attacks?

90% of attacks start with a phish. It’s critical that IT admins and MSSPs have the right security in place to protect their end users from these phishing attacks. Check out our latest feature brief for tips and tricks to keep your employees off a hackers line!

 
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 31

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 31

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 31

Accepted Solution

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

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 31

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
Laravel is the most sought after web development framework. It comes with ample amount of features that make it easy for developers to work around it. Know about its features in detail.
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

589 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