Forum Moderators: open

Message Too Old, No Replies

Can a password be edited by editing mysql database?

         

Wmff

3:56 am on Aug 12, 2023 (gmt 0)

Top Contributors Of The Month



Is it possible to edit the database to disable password protection for a directory/folder?

not2easy

1:06 pm on Aug 12, 2023 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



You might be able to change the permissions of a directory but that would not normally be available in a database. You do not mention whether your database is part of a platform CMS such as WP. Is the directory/folder a physical folder or generated by the CMS?

Wmff

7:02 pm on Aug 12, 2023 (gmt 0)

Top Contributors Of The Month



The database is from a Joomla system.
The folder is a server/physical folder with password protection added via the control panel from the host provider.

Wmff

7:05 pm on Aug 12, 2023 (gmt 0)

Top Contributors Of The Month



Note: password protection is added/edited via ".HTACCESS EDITOR" from the control panel of the hosting company.

phranque

7:30 pm on Aug 12, 2023 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



the .htaccess file contents are processed by Apache before control is passed to Joomla.

the Joomla db would therefore have no effect on HTTP Basic Authentication.

Wmff

9:54 pm on Aug 12, 2023 (gmt 0)

Top Contributors Of The Month



Thanks for the info.
I recently ran into an issue after my web site was migrated to another host.
The password wouldn't work for the administrator directory so I couldn't get into the back end to work my site.
Does that mean that all I had to do was modify the migrated .htaccess file and I could have disabled the password protection?
My new host insisted that the only "fix" was to disable the password protection from the current active site and create a new backup so that backup could be used for a new migration.

phranque

3:55 am on Aug 13, 2023 (gmt 0)

WebmasterWorld Administrator 10+ Year Member Top Contributors Of The Month



it may require creating a new .htpasswd file or equivalent

lucy24

5:53 am on Aug 13, 2023 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member Top Contributors Of The Month



password protection is added/edited via ".HTACCESS EDITOR" from the control panel of the hosting company
That may be the name of the function on the control panel, but note that this is not actually an .htaccess function; it's .htpasswd. Are you able to edit these files directly, or does the host not allow this? Both are fundamentally text files that can be modified in any text editor and uploaded via any ftp-type program. It's just the form of the filename (leading “.ht") that gives them their special potency. But it's a little odd that configuration files of any sort came along for the ride when moving hosts, which presumably meant physically moving the site to a new server.

Wmff

7:46 am on Aug 13, 2023 (gmt 0)

Top Contributors Of The Month



That's a relief. I was beginning to doubt the competency of the techs at Hostinger.
At least I know that I didn't go through all of the trouble of creating the new backups for nothing. Thanks again.