How to manage your MySQL databases

Applies to:
Professional Hosting
Business Hosting

Difficulty:
Easy

Time Needed:
15 minutes

Introduction

This is a quick step-by-step guide to viewing, editing, adding and removing MySQL databases & database users via the 34SP.com Control Panel.


Article Contents



How to view your databases


Step 1

Login to your account

Firstly, you'll need to login into your 34SP.com account at http://account.34sp.com.

Login to your account

Step 2

Choose 'Manage Sites'

Once you have logged in, click on the 'Manage Sites' icon.

This will bring up a list of websites or domain names you have in your 34SP.com account. Simply choose the website you wish to edit by clicking on it.

Choose 'Manage Sites'

Step 3

Choose 'Databases'

After you have clicked on the website you wish to edit, you will be presented with your website overview page. Choose 'Databases' from the product navigation.

Choose 'Databases'

Step 4

Managing your databases

The 'Manage Databases' page provides an overview of your databases, with each database listed in a table. Along with viewing each database name, you can access 'phpMyAdmin' and remove databases via the table, by clicking on the relevant icon.

Please note: phpMyAdmin is a third party web interface for editing and managed your databases.

Managing your databases

How to add a new database


Step 1

Add new database

If you wish to add a new database, simply click on the button labelled 'Add New Database' when viewing the 'Databases' page.

Add New Database

Step 2

Enter database information

This will bring up a form. Simply fill in the form with the relevant information. When you're done, click 'Create Database' to save your changes.

Please note: Once you have clicked on 'Create Database', a new database will be added to your list of databases. A new database user will also be added to your list of database users.

Enter database information

How to edit your database


Step 1

Edit your database

If you want to edit or clean up your database, you can do so via phpMyAdmin. To edit a database, simply click on the 'phpMyAdmin' button (the box with an arrow icon) for the database you wish to edit, when viewing the 'Databases' page.

Please note: We do not recommend editing a database via phpMyAdmin unless you have previous experience with SQL databases.

Edit your database via phpMyAdmin

How to delete an existing database


Step 1

Remove a database

If you wish to delete a existing database simply click on the 'Remove' button (the 'trash' icon) for the database you wish to remove, when viewing the 'Databases' page. This will remove the database permanently. It will also remove the database user associated with this database.

Remove a database

How to view your database users


Step 1

Managing your database users

When viewing the 'Databases' page, just click on the tab labelled 'Manage Database Users'.

When you create a new database via the Control Panel, a new user is automatically created for that database. The 'Manage Database Users' page provides an overview of your database users, with each user listed in a table. Along with viewing information on each user, you can edit, add or remove database users via the table, by clicking on the relevant icon.

Managing database users

How to add a new database user


Step 1

Add new database user

If you wish to add a new database user, simply click on the button labelled 'Add New Database User' when viewing the 'Manage Database Users' page.

Add new database user

Step 2

Enter database user information

This will bring up a form. Simply fill in the form with the relevant information. When you're done, click 'Create New User' to save your changes.

Enter database user information

How to edit a database user


Step 1

Edit a database user

Due to security reasons, it is not possible to view a password for a database user. If you do not know the user's password, we recommend you reset it. To change or reset a database user password, simply click on the name of the user you wish to edit, when viewing the 'Manage Database Users' page.

Edit a database user

Step 2

Enter your new password

This will bring up a form. Simply fill in the fields with your new password. When you're done, click 'Save Settings' to save your changes.

Please note: It is not possible to edit a username of an database user, or change the database they are associated with.

Enter your new password

How to delete an existing database user


Step 1

Remove database user

If you wish to delete a existing database user simply click on the 'Remove' button (the 'trash' icon) for the user you wish to delete, when viewing the 'Manage Database Users' page. This will remove the user permanently.

Please note: Deleting a database user does not remove the associated database.

Remove database user

Was this helpful?

   
118 people found this article helpful