Wednesday, September 13, 2017

Preparatory Task for Mysql Upgrade - Reset Mysql users Passwords

MySQL

It has been our constant endeavour to make continuous improvements to our infrastructure in terms of stability and security. For the next step in this process, we are planning to upgrade the MySQL version from v5.5 to the latest stable version supported by cPanel on all our shared linux hosting servers. This will help us to improve the performance, enable new features and enhance the security of the server.


cPanel Linux Shared Hosting


What is the impact?

The older version of MySQL stores password in a 16 byte format. However, post MySQL upgrade the password will be stored in a 41 byte format which provides better security and reduces the risk of password sniffing.

What has to be done?

To prevent service disruption, we request you to reset your existing MySQL user password from cPanel. Doing so will automatically store the new password in a 41 byte format and ensure that you do not face any issues post the upgrade process.

Steps to reset the password of a MySQL database user:

https://documentation.cpanel.net/display/ALD/MySQL+Databases#MySQLDatabases-CurrentUsers

MySQL Databases


Once the password has been reset, you need to update the configuration files of the database driven websites with the new password.




Note:
You can also reset the password using your existing password itself. Eg, if your existing password is “pass@123” and while resetting you enter the new password as “pass@123”, you do not need to update your connection strings but the password format will change from the current 16 byte hash to 41 byte hash.


When do you need to change?

We are planning to schedule the MySQL upgrade at the earliest. Hence, we request you to reset the password of all MySQL database users under your account by 15th November, 2017.


Support and Helpdesk.


For any further clarifications, please contact our Support Helpdesk.

Support (at) PeaceNic.com

Skype: PeaceNic


WhatsApp: +923215431286

PeaceNic Support Knowledge Base


Saturday, July 16, 2016

Limited Time Promo 47% OFF Linux USA cPanel Web Hosting

47% OFF Linux USA cPanel Web Hosting

Cheapest Web Hosting Offer in Pakistan

Now Rs 4000 Per Year


Promo Ends on July 31 2016

Unlimited Everything!

  • Unlimited Disk Space
  • Unlimited Bandwidth
  • Unlimited Domains & Sub-Domains
  • Unlimited Email Accounts, Forwarders, Auto Responders
  • Unlimited FTP Accounts
  • Unlimited MySQL Databases

Powerful Control Panel - cPanel (View Demo)

  • World's Leading Hosting Control Panel
  • Manage Web Pages, View Website Statistics, Create Email Accounts etc.

Reliable Support

  • 99.9% Uptime Guarantee
  • 30 Day Money Back Guarantee
  • 24x7x365 Support

Robust Infrastructure

  • State-of-the-art Datacenters
  • Dual Quad-Core Xeon powered Servers
  • Redundant Scalable Servers

Advanced Email Hosting Included

  • Unlimited POP3 Email Accounts with SMTP
  • IMAP Support
  • Easy to use Webmail Interface

eCommerce ready

  • Private SSL Available
  • Add-on Dedicated IP
  • Supports osCommerce, CubeCart, Zen Cart

Server Specifications

  • Dual E5530 2.40GHz Xeon quad core hyperthreaded processors
  • 24 GB RAM
  • 250 GB RAID 1 (mirrored) OS drive
  • 1 TB RAID 1 (mirrored) customer data drive cached
  • Battery backed, RAID controller for all drives
  • Redundant Power, HVAC & Fire-Detection Systems
 

Programming Support

  • PHP 5.3x, 5.4x, Perl, Python, RoR, GD, cURL, CGI, mcrypt
  • Apache 2.2x
  • MySQL 5
  • Ruby On Rails
  • Zend Optimizer, Zend Engine, ionCube Loader
 

Security & Access

  • Anti Spam & Virus Protection
  • Password Protect Directories
  • Secure FTP Access
  • IP Blocking
  • phpMyAdmin Access
  • Hotlink & Leech Protection
  • Cron Jobs for Scheduled Tasks
  • Customizable Error Page
  • Website Statistics with AWstats
 

Email & Domain Name Features

  • Outlook, Thunderbird and Windows Mail compatible
  • Blackberry, iPhone, Android and PDA support
  • Feature packed Webmail
  • Advance Spam/Virus Protection
  • Mail Forwards, Email Aliases, Auto Responders
  • Unlimited Mailing Lists, Catch All Accounts, Mail Spam Filters
  • Parked Domains
  • Free DNS Management
  • Domain Forwarding, Path Forwarding, URL Masking