Managing MySQL Databases Via The New Control Panel

MySQL

Image via Wikipedia

Since our new control panel works a bit differently from its predecessor I will be trying to post short tutorials on various aspects of it over the coming weeks and months – sorry for not having done more recently!

Today we’ll have a very quick look at managing MySQL databases from the control panel.

When you login to your hosting account you should be presented with a screen similar to this one:

mysql manage stage1Please bear in mind that if you have multiple subscriptions (packages / plans) on your account that you may need to use the “Select Subscription” link to switch over to the hosting account you want to work with.

Once you’re able to see the screen shown above you can select the “Databases” option to manage your existing databases OR to create new ones.
Bear in mind that we offer several database engines on our new system so please be sure that you create the correct type!

adding a new databaseWe offer MySQL versions 4 AND 5, as you can see from the screenshot, so please make sure you choose the correct version.

Once you’ve created your databases you can easily manage them via the control panel system (click to enlarge image):

database manage list databasesIf you click on any of the database names you’ll be taken to the following screen:

mysql database host settings

here you can see the database server details that you will need to access your database either from a remote server or from one of our webservers.

NB: you should only use the external IP address if you are accessing the database from a 3rd party provider. If your site is hosted with ourselves please use the internal hostname.

You can also manage users and access hosts from the same area.

So there you go .. some really basic notes on MySQL management on the new control panel

If there are specific things that you’d like us to cover do let us know!

Reblog this post [with Zemanta]

, , , , , , ,

Comments are closed.