How do I create and manage a MySQL database?
Print Email
Email this article
Close
Email this article
CloseYou are here: Home > Website Support > MySQL
When you require access to a database (available for those holding a Basic hosting package or higher), visit the ‘Manage Services’ area of your online control panel, konsoleH, from where it can be created and maintained conveniently via a MySQL management tool (including PHPMyAdmin).
On the main page of the MySQL Database manager in konsoleH, you will see your database list. This is a list of databases you currently have installed on your domain. If no databases are installed, only the database quota will be visible.
Set-up a MySQL Database using konsoleH:
- Browse to konsoleH (http://myaccount.hetzner.co.za)
- Login with your Client number and Management password
- Select or search for a domain name in the ‘Hosting Service’ tab
- Click ‘Manage Services’ on the left-hand menu
- Select ‘Manage MySQL’ under ‘Databases’
- To add a database, click [ADD] (top middle)
- The database access information is displayed. It is recommended that you keep the default information but you can change the access details to your liking.
- 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. No data or database structures can be deleted when logged in with the R/W password.
- 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.
- Once all the necessary changes have been made, click on ‘Add’ to create the database.
- If successful, a message will appear stating that the database has been created. The database connection string will also be displayed that can be used in a PHP application.
Once you have installed your database, you will see that three more buttons are added to the top of the page: ‘Edit’, ‘Delete’ and ‘phpMyAdmin’.
Clicking on ‘Edit’ allows you to change the passwords to the databases and clicking on ‘Delete’ will delete your database. If you choose to delete a database, konsoleH will ask you to confirm your action before a database is deleted. Be careful when executing this command as it cannot be undone.
To manage your database you can click on ‘phpMyAdmin’ and then select your database name from the top left under the ‘Databases’ tab.
Was this information helpful?
Yes NoThank 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.
Related articles
-
Login Now
Our award winning proprietary control panel empowers customers to manage their hosting environment.
Take the Tour
