SMALL BUSINESSABOUT MELBOURNE IT

How do I manage databases like MySQL?

Suggest Edits

Note: If you are using our Cloud / cPanel plans please refer to 'The Console' category.

PHP and MySQL are databases that can be used to help run certain types of website. If you’ve built a site yourself using a program like Dreamweaver, chances are that you don’t have to worry about these aspects of your hosting plan and changing settings on these databases can break your website. So if you are not sure, check it out with your developer or give us a call.

If you are confident that the site build requires use of these databases, please follow the steps below:

How to enable MySQL

  1. Log in (How do I access my hosting control panel?)
  2. Scroll to the bottom of the Control Panel and under 'Databases' click MySQL.
  3. By default, the status should read 'MySQL is disabled. You may enable it now'. Click Enable MySQL.
  4. A confirmation message will display 'Your MySQL database has been enabled'.
    Note: By default, the MySQL password will use your Control Panel password.

How to enable phpMyAdmin

  1. Log in (How do I access my hosting control panel?)
  2. Scroll to the bottom of the Control Panel and under 'Databases' click phpMyAdmin.
  3. By default the status should read 'phpMyAdmin is disabled. You may enable it now'. Click Enable phpMyAdmin.
  4. A confirmation message will display 'Your phpMyAdmin has been enabled'.

How to administer mySQL with phpMyAdmin

Note: The following set of instructions assume the user has already logged into the control panel. ( How do I access my hosting control panel? )

  1. Within your Control Panel, scroll down until you see the 'Databases' section. Click phpMyAdmin.
  2. Under 'phpMyAdmin' section click Administer MySQL with phpMyAdmin.
  3. A new window will appear requesting you to enter log in information. Enter your Control Panel user name and password and click Go.
  4. Once logged in, you will have access to the phpMyAdmin panel. Please refer to the phpMyAdmin documentation for assistance configuring your database.

How to backup a MySQL database

Note: The following set of instructions assume the user has already logged into phpMyAdmin. Please see the above instructions if you are unsure of how to do this.

  1. Once you are logged into phpMyAdmin, select the database you wish to export from the left hand side.
  2. Click the Export button from near the top of the screen.
  3. Leave the settings as they are and click Go at the bottom of the screen.
  4. The database will be exported into a single file and saved on your computer.

How to Reset PHP password

  1. Log into control panel
  2. Select "Databases"
  3. Select "MySQL" and enter and confirm the new password
  4. Click "Change password"

Updated 2 months ago