Forgot Admin Password

[frenchie69]

Hi, i goofed...i forgot my info i picked for my MySQL Account.

Where can i find that?

[TCH-Tim]

You can look in your MySQL databases through cPanel. It lists your databases and database users.

[frenchie69]

You can look in your MySQL databases through cPanel. It lists your databases and database users.

That's where i am now, but it doesn't give me my password...that's what i forgot.

[TCH-Tim]

I don't think you can retrieve a lost password. Or at least not easily.

 

You could just delete the user and recreate it.

[frenchie69]

I don't think you can retrieve a lost password. Or at least not easily.

 

You could just delete the user and recreate it.

 

Ok, i was thinking the same...but a stupid question again LOL

 

// ** MySQL settings ** //

define('DB_NAME', 'wordpress'); // The name of the database

define('DB_USER', 'username'); // Your MySQL username

define('DB_PASSWORD', 'password'); // ...and password

define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

 

Here, where do i change it...where it says 'DB_NAME' or where it says 'wordpress' ?

[TCH-Don]

In MySql

go down to where the users are listed and select the user and delete

Then create the user with a password

then fid the add user to database

select the user and the database and add user.

[frenchie69]

In MySql

go down to where the users are listed and select the user and delete

Then create the user with a password

then fid the add user to database

select the user and the database and add user.

Already did that...now it's the config i'm trying to figure out where to change it

[TCH-Don]

You should only have to change the password.

 

define('DB_PASSWORD', 'password'); // ...and password

[frenchie69]

You should only have to change the password.

 

define('DB_PASSWORD', 'password'); // ...and password

I have to add the other 2 also...

But what i mean is:

 

Do i add that where it says" 'DB_PASSWORD'

or: 'password'

In what place?

[TCH-Don]

change password

define('DB_PASSWORD', 'password'); // ...and password

[frenchie69]

change password

define('DB_PASSWORD', 'password'); // ...and password

Well, tried everything...deleted MySQL Databases and restarted like 5 times...and

un-installed Wordpress as many times...but no go

I keep getting this:

It doesn't look like you've installed WP yet. Try running install.php.

[TCH-Mark]

Hello,

 

Without knowing the exact error can I just ask, did you add the user to the database from your cPanel?

[frenchie69]

Hello,

 

Without knowing the exact error can I just ask, did you add the user to the database from your cPanel?

No, i added the one i got for MySQL

[TCH-Bruce]

You Wordpress config file should look like the following:

 

// ** MySQL settings ** //

define('DB_NAME', 'cpanelname_dbname'); // The name of the database

define('DB_USER', 'cpanelname_db-user-name'); // Your MySQL username

define('DB_PASSWORD', 'password-for-db-user'); // ...and password

define('DB_HOST', 'localhost'); // 99% chance you won't need to change this value

 

Make sure you add the user to the database after creating the user.

[TCH-Tim]

And after you get the user properly added in MySQL and you change the config.php file, WP will probably want you to run install.php again, even if you already did it. Anytime database information changes.

[frenchie69]

And after you get the user properly added in MySQL and you change the config.php file, WP will probably want you to run install.php again, even if you already did it. Anytime database information changes.

Did all that guys....over and over LOL

Nothing. It's ok, i deleted all...will just go back to normal blog on normal site.

Thanks anyway for helping.

[TCH-Rob]

Should this happen in the future where you forget your admin information the following site may help;

 

http://www.tamba2.org.uk/wordpress/phpmyadmin/