PHP upgrade

[Kevin]

If you go into the CNC MySQL Manager it will tell you to change your password. Just do that and it will be in the new hash. You can even change it to the same thing it is now.

I think I have misplaced by MySQL Manager password.

When I go to the panel I cannot see my existing password.

It simply shows

MySQL Username: xexample (all lower case)

And I get a dire warning: Caution! Changing your MySQL Password may cause existing scripts to fail unless they are updated with the new password.

How can I retrieve it?

Will changing this password wreck my WP install?

[Kevin]

You can't retrieve it and neither can we. That is what the hashing is for. OTOH, it will be in your WP config file so you either have to find it there to find out what it is or find it there to change it after you change it in the MySQL Manager.

OK, here is what I have in the WP Config. I am pretty sure I changed the password this year.

I've changed out the DB_Name, DB_USER, the DB_PASSWORD, and the DB_HOST:

-------
define('DB_NAME', 'xexample_5');

/** MySQL database username */
define('DB_USER', 'xexample');

/** MySQL database password */
define('DB_PASSWORD', 'xnz855x695');

/** MySQL hostname */
define('DB_HOST', 'MySQL.example.com');

-------

So to stay up to date, if I am not already there,

I go into the CNC MySQL Manager to change password for xexample.

I simply enter the EXISTING DB_PASSWORD in the boxes New MySQL Password and Verify New MySQL Password and my WP will continue humming along? I assume all databases do not need a password of their own, only the MYSQL database password?

Originally Posted by Kevin

You can't retrieve it and neither can we. That is what the hashing is for. OTOH, it will be in your WP config file so you either have to find it there to find out what it is or find it there to change it after you change it in the MySQL Manager.

[Kevin]

Hopefully that isn't the real password there.

Yes, if you change the password to the existing password the hash will be updated to the newer standard. Your web app(s) shouldn't know the difference. If you ever do change the password to a different one each app needs to know the new password but it will be the same password for all the databases.

Yes, put in a fake password here.

Well I did it , cleared cache etc. and every thing appears fine, logged in to WP etc.

Is there anyway to know if I am now on the correct hash?

Thank you so much for assistance Kevin

Originally Posted by Kevin

Hopefully that isn't the real password there.

Yes, if you change the password to the existing password the hash will be updated to the newer standard. Your web app(s) shouldn't know the difference. If you ever do change the password to a different one each app needs to know the new password but it will be the same password for all the databases.

[Kevin]

If you didn't see a warning when you went into the MySQL Manager that has now vanished then you probably already were on the new hash. Anyway, it can't set the old hash anymore and hasn't been able to for some time.

I had actually already checked to see if that was your password (I can't tell what it is from the hash but I can try it and see if it works) but I figured it was worth having it written in here that that isn't the password. Usually when people make up a fake password it is something like 'mypassword' or 'examplepass' while you made up one that actually looks real.

[Kevin]

BTW, this has come up a few times at the service desk but I don't think we have ever mentioned it on the forums...

If you want to change your MySQL password and you have a bunch of web apps to update and don't know all the config files you can log into the shell with ssh then run:

 cd /big/dom/xdomain
grep -r oldpassword .

That will list the filename and the line in the file of every file containing the old password.

Perhaps it can be considered to be included in the tips section of the CNC?

That sure looks like a huge time saver.

[martian101]

Hello. Today I read a blog from Wordfence that PHP 5 is about to reach end-of-life on Jan. 1 next year, and that it won't receive a security updates in the future. They advise website owners to upgrade to at least PHP 7.1

I assume this is not for the WordPress core because I always update to the newest release; so I think upgrading to PHP 7 is on the server level, though I am not sure. Help me if I'm missing something

That said, how do I upgrade to, at least, PHP 7.1? I checked on Server Info >>> Version Information and there are 3 PHPs:

PHP CGI Version
PHP CLI Version
PHP Module Version



So, which of these three I need to upgrade to PHP 7.1? And, again, how do I do it in a way that will not break my site?