• What is MariaDB?

  MariaDB is a fork of MySQL. The database structure and indexes of MariaDB are the same as MySQL. This makes MariaDB a backward compatible, drop-in replacement for MySQL. We currently run MariaDB version 10.2.29 To check the version of MariaDB: Head to Manage Hosting then phpMyAdmin. Select the database in the left-hand panel. Select the Query tab at the top. Type the query: SELECT VERSION(); and select Go. The version of MariaDB will then be outputted.Popular

• 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 ( Manage Hosting select package phpMyAdmin) Choose the database you want to import your .SQL file to from the left hand side. Click the Import tab at the top of the page. Select Choose File and locate the .SQL file on your device or computer. Click Go The .SQL file will be uploaded and imported to the databPopular

• 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 My DZHosting. 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 hoPopular

• What's the maximum MySQL database size allowed?

  At My DZHosting, each MySQL database you create can store up to 1024 MB (1 GB) of data. As databases comprise of only text, this is a lot of space in real terms; to put it into perspective, a My DZHosting 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 Linux package for this.Popular

• 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 componenPopular

• 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 iPopular

• How do I create a MySQL database?

  You can create MySQL databases in seconds directly from your My DZHosting 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: Log in to and select Manage Hosting. Choose Manage next to the hosting package you wish to create a MySQL database for. UnderPopular

• 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 'relationaPopular