MySQL 5.5 to 5.7

Hi

I've received the message about needing to update mySQL 5.5

I have 20+ websites on our server with databases. Is updating mySQL like updating php where each account needs to be fully checked after updating, or should sites that worked in 5.5 still work in 5.7? Or are there certain things I should look out for?

Regards
Wayne

 

Great, thank you.

I'll give it a try over the weekend. Don't fancy doing this at 4 on a Friday

 

After doing quite a bit of checking of our sites, I can't be 100% sure the coding will be compatible as some is a few years old. I've searched around about disabling strict mode all with different ways to achieve it. Is there a preferred whm/cpanel method? Can this be done in whm? Or should I be using SSH?

 

Thanks keat63

Thats good info and glad to know I'm not the only one worrying about updating services.

Regarding the my.cnf file. How do you connect to the file in /etc for the whole server? I can access the root of each cPanel account in ftp, but how to I access the one at the root of the server?

 

I'm viewing using the CSF file view, but I can't see my.cnf in /etc - Should it be in there? I wonder if I should do the SSH route to do this. I've looked on the main cPanel site, but I can't find any info on the steps to take...

 

I was looking at the root folder in whm. I've googled about editing via SSH, but I'm finding lots of different ways and I can't find any info on cPanel site (unless I'm looking in the wrong place?)

I've used SSH before, but find I need to follow step-by-step instructions to help

 

My mistake, found the file. I didn't see it in the top list (which was directories) and it was in the list below.

 

OK, I've updated. Thanks everyone for helping.

Just to confirm, I've checked with the command;

Code:

mysql -e "SELECT @@sql_mode;"

and got this response;

Code:

@@sql_mode                                                                                                                                |
+-------------------------------------------------------------------------------------------------------------------------------------------+
| ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

Would that suggest disabling Strict mode was successful?

 

Hi cPanelMichael

Sorry, I should have explained all the steps I made.

I added to my my.cnf file;

Code:

sql_mode=NO_ENGINE_SUBSTITUTION

Then did

Code:

mysql -e "SELECT @@sql_mode;"

To check if it had worked.

As I've done the top bit, do I also need to do the steps you mentioned in your last post?

 

I've now re-booted mySQL and re-checked and get this response;

Code:

@@sql_mode             |
+------------------------+
| NO_ENGINE_SUBSTITUTION

Does that mean its worked?