How do I change my MySQL database passwords?

It is good practice to change your passwords every 30 to 60 days to prevent unauthorised access to your information.

To change your MySQL database passwords via konsoleH follow these steps:

1.    Browse to konsoleH (rom your authoritative email address)
2.    Log in with your email address and Management password
3.    Select or search for the applicable domain
4.    Select ‘Manage Services’ in the left-hand menu
5.    Select ‘Manage MySQL’ under ‘Databases’
6.    Select the applicable database and click ‘Edit’
o    The Full Password is the most important. It allows access to the entire database and allows you to create or delete any database information, columns or rows.
o    The R/W (Read/Write) Password only allows read and write access to the database. This is most commonly used by CMS (Content Management Systems) that need to add or delete information from the database.
o    The R/O (Read Only) Password will only allow you or an application to read information from the database. No data or database structures can be changed when logged in with the R/O password.
7.    Enter your new database passwords (ensure that you use strong passwords).
8.    Click ‘Update’.

When changing your MySQL passwords, it is important that you update your database connection strings to refer to your new passwords. You can update your connection strings via File Manager/FTP or Telnet/SSH.

Please use only strong passwords. To ensure your password is strong make sure you adhere to the following guidelines:

  • Use both upper and lower case letters.
  • Incorporate numbers or punctuation marks.
  • Use at least one special character: ! @ # $ % * ( ) - + = , < > : : .
  • Ensure it is at least 8 characters long.
  • Do not use your username, email address or domain names associated with your profile.
  • Do not use your personal information, such as name, phone number, ID number, special dates, address or names of anyone you know.
  • Use different passwords for you various hosting services.
  • Use a word or phrase you can remember easily, but would be very difficult for anyone else to guess.