Databases offer a way of managing large amounts of information over the web easily. They are needed to run many applications that are web-based, such as online retail shops, content management systems, and bulletin boards. In this article, we will go over the steps that you need to take to create a new database and a new user that will be assigned to the database successfully. When you’re setting up an application or script from scratch, this is something that is typically required. We would suggest using the Softaculous Auto-Installers when possible, which set up applications like Magento, Joomla, and WordPress for you. You need to log into your account on cPanel to start the whole process. Then, after you’re logged in, go to the tab Databases and search for the MySQL Database Wizard. Once you have managed to access this tool, there are some steps you will need to go through, and the first one is the creation of the name of the database. Your cPanel username will prefix the database name, for instance, cpaneluser_db. In order to avoid any confusion that might arise in the future, it is best that you use something descriptive. So, instead of just using “DB,” use something like “wordpress” or “wp.” You will be asked what should your database password and username be on the net page. The database user is the easiest to create with the same username as the name of the database. When it comes to the password, you can use the “Password Generator,” which is built-in, or you can just type in a password of your choice. Once you’re satisfied with your username and password, click on the button “Create User,” which will lead you to the next page. For the database you just created, you will need to assign the user, and most of the time, for the user, you will need all of the privileges. For this, you will need to tick the box next to the phrase “All Privileges.” Click on the button “Next Step” once you’ve done this. This is the last step, which means that you’ve managed to create your database and user for your cPanel account successfully. If you want to delete a MySQL database, you need to go to MySQL Databases and go to the section “Current Databases.” In the column “Actions,” click on the delete that is located next to the database you want to delete. In order to remove the database permanently, just confirm your action, and you’re good to go. If you want to delete a database user, you need to go to MySQL Databases and navigate to the section “Current Users.” Once you’re there, look for the database user that you want to delete, and then click on the delete icon that is net to the database user. In order to confirm the deletion, click the Delete User icon.

What is cPanel cPanel is a popular Linux hosting control panel that is used by many hosting providers worldwide. Often, it is included with the web hosting package. However, there are cases where you need to get a separate subscription in order to get cPanel. cPanel uses a graphical interface that simplifies the management of a site greatly. It displays key metrics about the performance of your server, and it allows you to access a range of modules such as Preferences, Files, Databases, Web Applications, Security, Metrics, Domains, Software, Email, and Advanced Modules. In order to administer your website hosting with us, we provide the cPanel control panel. You can execute the most common hosting tasks with just a few clicks, thanks to this graphical interface. Logging in to cPanel You can log into your client area, then navigate to Hosting Accounts, click the Account, and then log in to cPanel. Now that we’ve gone through the ways to log into cPanel, we’re going to get you started off with the basics of cPanel. Installing Software You can install the software in the following two ways. You can install your software manually by following their guides for installation, or you can use our auto-installers, which are recommended for most open-source platforms such as Magento, Joomla, and WordPress. Databases The data for most applications is stored in databases. For instance, WordPress uses both databases and files. You can create databases by adding them manually or using auto-install software. Uploading and Managing Files The files of your website run out of a folder called public_html, and there are several ways that you can manage files. Some advanced users use SSH, while others use SFTP or FTP through a file management application like FileZilla or use the inbuilt file manager. SSL Certificates At Hex Hosting, with every hosting account, we provide free SSL certificates. In most cases, renewal and provisioning are completely automated, and you don’t need to do anything in regard to the SSL certificates. Email Accounts Every Hex hosting account allows you to create email accounts. The emails can be set up to forward somewhere else, or they can be full mailboxes. Alternatively, MX records can be set up in order to point emails to an external provider such as Office 365 or Google Gsuite. Optimization and Performance Hex Hosting is set up to minimize potential issues or downtime and to run your website quickly. We set it up by default to run the greatest number of sites in the best manner. However, you can do some optimizations to make sure that a certain site loads quickly from your end as well, such as changing the PHP version. You get all this as standard at hexhosting.uk