I am a front-end developer, and I know little from MySQL and databases.
I have a Wordpress MySQL database in CPanel. Now I forgot my password, and the password for my user as seen in phpmyadmin is hashed/encrypted.
How do I get the password?
NOTE: I do not have access to the Server since this is a website on a shared hosting account, so doing the following is not possible for me:
See this post on Stack
Stop the MySQL process.
Start the MySQL process with the --skip-grant-tables option.
Start the MySQL console client with the -u root option.
SELECT * FROM mysql.user;
UPDATE mysql.user SET Password=PASSWORD('[password]') WHERE User='[username]';
Stop the MySQL process
Start the MySQL Process normally (i.e. without the --skip-grant-tables option)
If your website is working you can probably find the mysql user/password
config.php file in your wordpress filesystem.
Your best option is probably to add a user to the database and give it the needed privileges, to do that:
config.phpon your wordpress filesystem and change to the new username.
This is sub optimal, but will work.