Menu
whm logo
  • News
  • Websites
  • Business
  • Servers
  • Services
    • CPanel Hosting
    • EZ Website Builder
    • VPS Hosting
    • Dedicated Servers
    • Reseller Hosting
    • Domain Registrstion
whm logo
January 19, 2016

MySQL Password Alert

Share it here
twitter facebook pinterest linkedin

The latest version of MySQL has forced a stricter password format for all databases. This only effects databases made several years ago so most are just fine. If it has effected your website you will just need to create a new MySQL user for your MySQL database connection. It’s pretty easy to use and we are happy to do it for you. We suggest to do this even if you are not effected yet to be sure you have the most recent security.

Here is how to create and add into your script/app a new MySQL user. 

1. Log into CPanel
2. Click MySQL Databases
3. Scroll down to “Add New User” and fill in the details under it and click “create user”
4. Scroll down to “Add User To Database” and choose the database and user in the drop down options and click “add”
5. Choose “all privileges” on the “manage user privileges” screen that will pop up and click”make changes”.

Almost done..

6. Now in your script find the configuration file. For wordpress it is in the main folder and called: wp-config.php
7. Now just add the new user and password in the config file.

Here is an example of the user and password to changed to the new user you just added.

define(‘DB_USER’, ‘USERNAME_WP5’); // Your MySQL username
define(‘DB_PASSWORD’, ‘PASSWORD’); // …and password

In this example you would replace USERNAME_WP5 and PASSWORD with the new one you just created.

We are happy to do this for you, just add a ticket with the location of your config file and we will do the rest. Most databases are fine, this only effects databases that created a user several years ago and have never added a new one since the upgrade. Again though we are suggesting everyone do this to make sure they are on the new MySQL password system that is more secure.

Make sure and remove your old MySQL user in CPanel after you see everything is switched over and working. The less files the chance of any issues!

Continue Reading

← What to do in 10 steps after being hacked.
What’s new? →

Leave a Reply Cancel reply

You must be logged in to post a comment.

Connect with us
twitter facebook instagram youtube pinterest linkedin

Click to view coupon lup

Recent Posts

  • How to make an awesome about us page

    How to make an awesome about us page

    December 5, 2022
  • Is AI taking over SEO?

    Is AI taking over SEO?

    November 10, 2022
  • Transferring domains can be easy

    Transferring domains can be easy

    October 26, 2022
  • 6 highly effective ways to market a small business online

    6 highly effective ways to market a small business online

    September 28, 2022
  • A successful marketer

    A successful marketer

    August 22, 2022
  1. albertdavid123 on MySQL 5.5 is officially dying this weekApril 3, 2019

    Good bye 5.5. And thanks for we explaining the password change steps.

  2. Web Host Pro on Proper computer postureDecember 1, 2015

    Thanks!

  3. frank on 85% of people use the internet to find local businessesAugust 8, 2015

    I always do!

  4. Danny Walton on Free word invoice templateJuly 4, 2014

    Nice download

  5. Ken on Using Google Public DNSFebruary 22, 2014

    Great article!

All Rights Reserved Web Host Pro 2022