Databases | Megabit Cloud Help Center

How do I manage my Microsoft SQL database?

We recommend using SQL Server Management Studio (SSMS) for managing your Microsoft SQL databases. This industry-standard software provides a comprehensive environment for Microsoft SQL database creation, access, configuration, development, and other management features. It includes a variety of components including visual database tools, code and text editors, object management, boilerplate text management, and more. With SSMS you can deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts. SSMS also helps you download and back up your MS SQL databases, which we recommend you do at regular intervals in the interests of best practice security. You can download the software for free on the Microsoft SSMS download page. To connect remotely you will need to use Server 'mssql.stackcp.com'.

Last updated on May 18, 2026

Can I view my FTP, email address, or database passwords?

We encrypt all FTP, email and database passwords so they are not visible as plain text inside your control panel. The exception is the very first FTP account: this password is visible on the right hand side when you manage your hosting. You're able to change all passwords and changes are usually processed immediately. Please note: the majority of database passwords will be saved in the configuration or connection strings for your website. For example, for WordPress, the database password is visible inside the wp-config.php file.

Last updated on May 18, 2026

What is MS-SQL?

Microsoft SQL Server is a relational database management system (RDMS) developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications. These applications may run either on the same computer or on another computer across a network, such as the internet. A relational database management system means two things. First, data stored inside SQL Server will be housed in a 'relational database', and second, the SQL Server is an entire 'management system', not just a database. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.

Last updated on May 18, 2026

How do I create a MySQL database?

You can create MySQL databases in seconds directly from your MegabitCloud Web Hosting control panel. This option is unavailable for packages hosted on our WordPress platform due to its WP-optimised nature. If you need to create a MySQL database, you'll need to move the website to our Linux platform.To create new MySQL databases: 1. Log in to cpanel.yourdomain.com and selectManage Hosting if you have multiple hosting accounts. If you have one, head directly to web tools and follow the steps. 2. Choose Manage next to the hosting package you wish to create a MySQL database for. 3. Under Web Tools,select MySQL Databases. Here you can complete the following actions: - Create new MySQL databases. Each MySQL database has a maximum size of 1024MB (1GB). - Manage existing databases. - Add additional MySQL users to databases. - Manage your additional MySQL users. 4. Under Add a new MySQL Database,choose a name for your database. Database names must be between 6 and 20 characters long, and we automatically add a suffix to avoid name collisions with other users. 5. Once you have chosen a name, clickCreate Database. Your new MySQL database will automatically appear in the Manage MySQL Databases section underneath. From here, you can change the automatically generated password, monitor usage, remove your MySQL database, or log in to your database.

Last updated on May 18, 2026

What's the maximum MySQL database size allowed?

At MegabitCloud Web Hosting, each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise only text, this is a lot of space in real terms; to put it into perspective, a MegabitCloud Web Hosting customer’s average database size is just 10 MB. In the rare event that you need more than 1024 MB, you'll need to add an additional database. You aren't able to add more MySQL databases to websites hosted on our WordPress hosting platform; you would need a web hosting package for this.

Last updated on May 18, 2026

Can I set my database hostname as 'localhost'?

No, you would need to set the database hostname as the server that it's on at MegabitCloud Web Hosting. You can find this by going to the MySQL Databases icon within a package. The hostname you’ll need to use will be something similiar to ‘shareddb1b.hosting.stackcp.net’ although it's likely the database name on your package will be different. 'localhost' generally means the MySQL databases are hosted on the same server as the websites, which is quite common in the web hosting industry with hosts that have a 'single-server' approach where all services run from the same machine. It's different at MegabitCloud Web Hosting as we split all services and have a strict 'one server, one rule' policy. At the MegabitCloud Web Hosting data centres, web traffic, MySQL traffic and storage are all physically different machines, so 'localhost' doesn't work.

Last updated on May 18, 2026

How do I import a .sql file via phpMyAdmin?

You can use phpMyAdmin to import an .SQL file with your database information. To do this: - Log in to your database via phpMyAdmin (https://cpanel.yourdomain.com > Manage Hosting > [select account if you have multiple accounts] > phpMyAdmin) , Or if you have one account, head directly to phpMyAdmin - Choose the database you want to import your .SQL file to from the left-hand side. - Click the Importtab at the top of the page. - Select Choose Fileand locate the .SQL file on your device or computer. - Click Go The .SQL file will be uploaded and imported to the database you've selected. MegabitCloud Web Hosting's shared web hosting offers 1 GB MySQL databases.

Last updated on May 18, 2026