How to Create a MySQL Database in Cyberin Hosting

If you are setting up a website or web application one of the first things you will need is a MySQL database. Everything important lives in your database. Your content, user accounts, settings, orders and more. Whether you are installing WordPress manually, configuring a CMS such as Joomla or Drupal, or building a custom PHP application, your database is where all the magic happens.

The good thing is it’s easy to create a MySQL database on Cyberin hosting and it only takes a few minutes. This guide takes you step-by-step through the entire process.

Test Your Hosting Plan Before You Start

But before we start, there is one thing we need to confirm. Please note that if your website is on a Cyberin WordPress hosting package, manual creation of MySQL databases is not supported on this package. WordPress hosting is a managed environment designed and optimized specifically for WordPress, and manual database management tools are not part of that environment.

If you want to create and manage your own databases (for a custom application, non-WordPress CMS, or any project that requires multiple databases), you’ll need to be on a Linux hosting package. Linux Hosting gives you the ability to create databases and manage and configure users, putting you in the driver’s seat. A better choice for developers and more advanced projects.

If you already are on a Linux hosting plan then everything below applies directly to you.

Creating your MySQL database (Step by Step)

Step 1: Sign in to Your Cyberin Account

First, log in to your Cyberin client area and go to your dashboard.

Step 2: Open Your Hosting Package

Locate the hosting package where you want to create the database and click Manage to open the hosting management panel.

Step 3: Go to MySQL Databases

Log in to your control panel and find the MySQL Databases section. Your central resource for all database needs. Build new databases, manage users, view hostnames, reset passwords and monitor usage.

Step 4: Enter Your Database Information

You will need to in the MySQL Databases area:

And done. Your database is created instantly and ready to connect.

Save Your Credentials Immediately

This is a step that is easy to skip in the moment but important not to. Once your database is created, make sure to save the following four details somewhere you can easily access them:

All four will be required when connecting your website or application to the database, whether that’s during a WordPress install, inside a config file, or through a CMS setup wizard. It’s a frustrating and avoidable problem to lose track of these details mid-setup.

Hostname Is Not 'localhost' – Here’s Why

This is where most people get it wrong when they set up a database on Cyberin for the first time (especially if they are coming from other hosting providers).

For many traditional hosting environments the webserver and database server are on the same machine so applications can connect to the database using localhost as the hostname. Cyberin, is different. It also separates web hosting, database hosting, and storage on dedicated servers – a modern architecture that provides better performance, stability, and security across the board.

localhost will not work because your database is on another server. Instead, you'll be provided with a remote hostname that appears as follows:

shareddb1b.hosting.stackcp.net

Your hostname will be specified in the MySQL Databases section of your hosting panel. Just copy it from there and use it where ever your application asks for a database host. This is a tiny but important difference, and if you miss it you get a lot of unnecessary confusion.

Maintaining a Healthy Database

After everything is connected and running, a few simple habits will keep your database healthy over time. Create strong passwords and use different ones for your accounts. If you suspect your password has been compromised, change it. Get rid of any databases you’re not using — they’re just clutter and a potential security risk.

Back up your data regularly, and from time to time, optimize your database tables to keep queries running fast. Be aware of plugins or extensions that add their own database tables but don’t clean up after themselves.

You don’t have to do all of this every day, but keeping on top of it as part of your regular site maintenance really does make a difference to speed and security as your website grows.

Conclusion

It’s a quick and easy process to create a MySQL database on Cyberin and once it’s created you have all you need to get your website or application up and running.

Just remember to:

With that done, your database is ready to power your website or application smoothly and securely.