Lunarpages Web Hosting Forum

Author Topic: MySQL updates on wend.lunarservers.com  (Read 3552 times)

Offline Jassi

  • Administrator
  • Über Jedi
  • *****
  • Posts: 1557
  • Waheguru Ji Ka Khalsa, Waheguru Ji Ki Fateh
MySQL updates on wend.lunarservers.com
« on: February 05, 2019, 09:28:57 PM »
Dear Customer,

We will be upgrading MySQL from the version tree 5.5 to version 5.6 on wend.lunarservers.com.

We have backups on hand for all databases in the event of any issues with the upgrade process. For more details on MySQL and specifically MySQL 5.6 series, please review the change log at http://dev.mysql.com/doc/relnotes/mysql/5.6/en/index.html

Most scripts should run normally without issues on MySQL 5.6, however this will also imply having MySQL-dependent connectors such as python, java (you will need to update your web.xml configuration), so if you are running any scripts which are older or not up-to-date, please ensure to obtain the most current copy of the script from the script development site so that the script will function properly with the new MySQL 5.6 release. There are following changes in mysql 5.6 release:

http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-16.html

MySQL users that were last updated more than approximately 6 months ago are likely using the 16 bytes (old, deprecated) password hash, so if your script can not establish the connection with the database once MySQL gets upgraded you'll need to consider doing the following:

1) Change your CPanel password if you use the CPanel username for ANY mysql connections (it doesn't matter to what - you can even set the same one, however it'll be picked up in a 41 bytes hash once you do it);
2) Change your MySQL users password if you haven't done so in the past ~6months for every user that you use (and delete the users that are unused) - this can be done from CPanel -> MySQL databases -> Clicking on the mysql user and filling the needed fields. Sometime you need to remove mysql user and re-add same user and password and allow mysql grant privileges else your site will show database connection issue.

Please note that you may check the current status for this server at any time in CAP via https://account.lunarpages.com with your cPanel username and password, then by clicking the Network Status icon.

Thank you for your patience and we apologize for any inconvenience this may cause. If you have any issues with your site, please contact us at support@lunarpages.com or through our helpdesk at https://support.lunarpages.com/dashboard.

Lunarpages System Administrator Team
--

Er. Sarwan Singh Jassi
Manager - IT Systems

Lunarpages Internet Solutions
Website: http://lunarpages.com
Email: support@lunarpages.com
Phone: 1-714-521-8150
Community - http://www.lunarforums.com
Tutorials - http://www.lunarpages.com/tutorials/