Need db info without htaccess file

The database info isn’t stored in the .htaccess file. It’s in the wp-config.php file. If it’s the database name, username, and database password you’re after, it should be in your last backup copy of the wp-config.php file. Otherwise you may need to use the SQL management tools in your hosts control panel to retrieve the name of your WordPress database, the database username, and the password.

Ah I see. I only backed up the wp content folder and the htaccessfile so I don’t have wp-config.
Can I do what you suggest via phpmyadmin?

Open phpMyAdmin, identify the database that is being used by that WordPress installation, then look at the user that has been assigned permissions on that database. As far as the password goes, I can’t recall if it’s md5’d or not, so if you don’t know the password, and can’t reveal the user password as plain text, you may need to change it.

– Do that at your own risk. If you aren’t comfortable yet with the features and options available for database and user management in your host control panel, you may be able to get your hosts support group to help walk you through the steps to recover the database user info.

Hi jackson.kelly.

@claytonjames is right.

If you dont have any documentation of your WordPress install, e.g. an email from Softaculous when it was first installed, and you didn’t backup your wp-config file, then your best bet would be to visit your hosting account (cpanel or plesk) to retrieve database information.

You may be able to get the database name from the list of databases in your hosting account. If WordPress was installed automatically, you’ll probably find them named something like wrdp_03 or similar.

In many cases, the database username and password will be the same as your hosting account one. Sometimes it isn’t (in fact, it shouldn’t be). In that case, you will have to check each user account that has permission to each database. That should help you identify database username and password.

You may then need to visit each database on your hosting account, using phpmyadmin, to determine if it is the one you want.

From phpmyadmin go to the database, and go to the wp_options table.

In there, look for siteurl in option_name field. This should help you identify the site you want.

You will also need to change the WordPress admin password if you don’t have a record of that.

Hope that helps.