How do I change my MySQL database passwords? Print
Submit Cancel
Email this article

Close

You are here: Home > Website Support > MySQL

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 (http://myaccount.hetzner.co.za)
  2. Log in with your Client number or 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’
    • 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.
    • 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.
    • 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 note: Hetzner will only accept 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.

Was this information helpful?

Yes No

Thank you for your feedback
We are delighted to find that our article resolved your query.

Thank you for your feedback
We will resolve your query as soon as possible.

Please take a few moments to comment on your unresolved query. Simply tell us what your problem is. We guarantee that we'll get back to you within two hours (during office hours) in response to your query.


  Partially resolved    Unresolved
Enter your query here:
Your name:
Your email address:
Contact number:
Customer number or domain name:
 
Preferred contact method: Email     Call me
Please enter the text in the picture below into the text box:
CAPTCHA Image:
ID Number:
 

Related articles

  • What is phpMyAdmin?
  • What is MySQL?
  • What does database administration involve?
  • What can I use for database optimization?
  • How do I update my web application database connection strings via File Manager or FTP?
  • How do I update connection strings on a Linux server via SSH?
  • How do I secure my database?
  • How do I repair my MySQL database?
  • How do I repair my MySQL database?
  • How do I create or import a MySQL dump file?

    • Hosting for Beginners

      Step-by-step guide to hosting with Hetzner.

      VIEW NOW

    • Application Tutorials

      Use our installation guides to get up and running.

      VIEW NOW

    • Login Now

      Our award winning proprietary control panel empowers customers to manage their hosting environment.

      Take the Tour

    • Contact Us

      support@hetzner.co.za

      Phone: 0861-0861-08
      Fax: 0861 0861-09
      Contact Us