Nic

PHPMyAdmin is a tool for the management of MySQL databases. This tool lets you manipulate and manage data in the databases of your hosting—for instance, Magento stores user data, pages, and posts in a MySQL Database. You can use phpMyAdmin to delete or add records in a MySQL database. What are the basic functions of phpMyAdmin? This article will cover the steps that you need to take to use and access your phpMyAdmin. You need to login into your account on cPanel in order to access PHPMyAdmin. Once you’re logged into your account, you need to look for the icon that says PHPMyAdmin, or you can just go to the top right-hand corner and use the search bar. Once you’ve clicked on the icon PHPMyAdmin, a new tab will be Infront of you, and this tab will be the interface of Using phpMyAdmin. You will see a list of your databases under the cPanel account on the left-hand side of the screen. Nothing will be listed here if you do not have any databases. You can see the database that you are currently in at the top of the bar, as well as the actions that you can take in this database (such as Import database, Export database, Search, SQL query, and so on). You can also see the listed tables. You will see the contents of this tabling by clicking on it to expand it. An important thing to keep in mind is that unless you don’t have any other choice left, we don’t suggest that you work directly in the database.

When running a complex website, it makes sense to have a way of automating regular tasks, and never have to remind yourself to do them. This is what Cron Jobs is for – Linux commands that schedule things. That means, it is armed with a good knowledge of Linux commands, and you can make the best use of these Cron Jobs. A Cron Job can be quite handy, as it can be instructed to run in hourly or minutely increments, on a certain day every week or date every month – you can even mix and match these. Be advised, though, that running too many Cron Jobs too often can lead to undue stress on the servers. However, such limits may not be applicable to non-shared resources like a dedicated server. These Cron Jobs can be used for good old storage housekeeping, or for more advanced task flows that can free up time for more immediate concerns. There are even scripts that depend on Cron Jobs to run. The good thing is that such scripts will clearly detail what needs to be done with regard to the Cron Job.How Cron Jobs Work A Cron Job is made of three parts: A script that is meant to run A command (specified in cPanel) that runs the script at set intervals or at set times. An action or result generated by the script, as the nature of the script might be. Adding Cron Jobs via cPanel Here in cPanel, you can also view all ‘Current Cron Jobs’ where, under the ‘Action’ column, you also get to ‘Edit’ or even ‘Delete’ any existing job. cURL, GET, and WGET Here’s some good news when it comes to these request commands. As common as they are in Cron Jobs, there are no additional steps needed to access them; they’re all enabled by default with us. To Keep in Mind for Running Cron Jobs

An SSL certificate on your site gives you the padlock icon in your browser, and this encrypts communications between visitors to your site and the server. Google is now giving sites without SSL certificates a warning in the browser so it is more important than ever to have an SSL certificate on your site. All sites/domains hosted by Hex Hosting are automatically enrolled in the Auto SSL system – this is included free of charge with all hosting packages on Hex Hosting. This means that as long as the domain points to us (via the nameservers or A record) the system will request an SSL for the domain and install it automatically if it doesn’t already have one. This process is transparent and requires no intervention from you. Generally speaking, it takes 4 hours after pointing the nameservers for the SSL to be requested and installed, but, if it takes longer than this or if your SSL certificate is not working, please let us know. or try the following steps below There you will see the list of all the domains and subdomains in cPanel along with their SSL certificates. To force your site to work over SSL, generally speaking, you can use a rewrite rule or go to domain and force SSL, e.g. RewriteEngine On RewriteCond %{HTTPS} off RewriteRule ^(.*)$ https://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] This will redirect all requests for http:// to https:// but it is important that you only do this after your SSL is installed and working. If you’re running a CMS like WordPress, it is also important to set the Site URL and Homepage in the wp-admin area to include the https://. This is important so that images and stylesheets and so on are loaded over https:// as well. You can also install a plugin such as Really Simple SSL that can help you set these redirections automatically.

Hex Hosting manages a folder structure that is similar to the one of a desktop computer file system. A subfolder called public_html is where the site files are located. If you add additional subdomains and domains to your hosting, they will have their own folders outside the subfolder public_html. This will be the case if, when you’re adding them to your plan, you don’t specify a different “Document Root.” When talking about cPanel, there are a few ways to manage your folders and files. You can find an online File Manager in cPanel. This file manager is quite similar to a file manager on a computer from a graphical interface perspective. On the cPanel dashboard, you can find a File Manager link. The File Manager is pretty straightforward and easy to use. On the left side of the screen, you will find the browser folders, and from there, go to specific files. You can edit these online. There are several functions that are available to you, including compress to a z, view and edit files, file permission changes, and file uploads. If you want numerous or advanced changes, we recommend that you use a protocol for full file management, even though File Manager is great for quick operations. SFTP and FTP SFTP is a more secure form of file transfer protocol that functions through the SSH protocol. FTP is short for File Transfer Protocol. This is a method for communication you can use to connect from a computer (for instance, your desktop computer) to a web server in order to manipulate files. Filezilla is one of the most popular desktop software applications for FTP. Both SFTP and FTP are used with your cPanel password and username. Your domain name can be the FTP hostname, and the posts are 22 (SFTP) and 21 (FTP). Under FTP Account in cPanel, you can also set up additional FTP accounts. One important thing to remember is that by clicking “Configure FTP Client,” you can check out the settings you need to put in your FTP client. When setting up the places that your FTP Account has access to, make sure that you set the preferred path. Only home/user/ should be present, and everything else should be deleted if you want to have full account access.SSH SSH, or shell access, is enabled by default port 22 with the cPanel password and username if you’re an advanced user. SSH is a way to connect to your webspace by using the command line. For power users, this is such an important feature, and you can run commands and manage files. You need to use an SSH client to connect to the server if you want to use SSH. Within a terminal application, you can run commands manually once you are connected fully to the server, with the use of an SSH client.

If you want to see more detail of your disk usage, you should click on the icon that says Disk Space Usage. Otherwise, you can use the cPanel statistics panel to see the total of your disk space usage. The usage is broken down into several categories by the Disk Space Usage section, and this way, you can efficiently manage your space. You can look into specific folders in the web space. When talking about unexpectedly increased usage of disk space, there are reasons that are commonly blamed. These include the following: E-mails – The account usage also includes e-mails. If you receive a large amount of spam, you have a default e-mail address on all of your messages that are kept on a server; this can take up disk space on your account. Also, you should remember that e-mails that can be found in your Trash folder use up disk space. Make sure that you empty the folder Trash if you have a lot of e-mails there, so you can clear up the space that you need. Website Error Logs – Website error logs are usually files with an error_log name and are created because of a website PHP error, as well as enabled logging details of the reason for the error will be included in the log, or you can go to PHP Selector and disable logging in the PHP options. Cache Files – Cache files can be created by the software. In theory, these cache files should be removed, but sometimes they are not. Cache files are another thing that should be regularly cleaned since they can unnecessarily take up a lot of space. Software Website Backups – Software website backups are backups that your software takes, such as WordPress, and they are typically configured in a plugin. Your entire cPanel account is regularly backed up by us, so there is no need to take this. We suggest that you store your backups else if you want to take your own backups. Log Files – Log files let you monitor the activity of your hosting while you’re away, and they are useful in that way; however, there is no reason for them to remain on the server. Once you have reviewed and downloaded the disk files, you can free up disk space by removing the log files from your server. Unused Installation – Another reason for increased disk usage can be unused and old installations. Keeping these files on a server doesn’t have a point. These files don’t serve the needs of your website and only eat up the disk space, so make sure that you get rid of them. You can use the cPanel FTP or File Manager once you have found the cause of the increased disk usage and clear the source. If the cause is e-mails, then you should use Mail Client or Webmail to clean it up.

Softaculous is an auto-installer that makes installing web apps simpler and easier. You can install some of the most popular hosting software in the industry on your cPanel server, thanks to the hundreds of scripts that Softaculous provides. To keep the sites secure, Softaculous provides automatic updates through their service, as well as regularly adding new software to their library of scripts. It can be quite intimidating for some users to install software on a server. Softaculous makes the installation process easier by providing a graphical interface with trusted scripts. The Softaculous Autoinstaller enables hundreds of apps that cover a wide array of categories like eCommerce, CMS, blogs, forums, ERP, wikis, project management, social networking, and much more. Not only does Softaculous simplify script installation, but it also allows users to manage their applications with backups, updates, restores, and many more features.Features of Softaculous Over 100 popular web applications with automated installation One-click update for newer versions of applications It is possible to have multiple installations of the same application in different directories Applications can be installed on addon domains and subdomains, not only in subdirectories of the main domain You can uninstall applications that you don’t need to use any more only with one click Using the Softaculous Autoinstaller Softaculous is really straightforward to use. With just a few simple steps, you will be able to install hundreds of software titles, and it has multiple layers of settings that you can customize to suit your needs better. To use the Softaculous Autoinstaller, you need to take the following steps. First, you will need to log into your cPanel. You can find the Softaculous icon at the bottom of the control panel. You can click the main Softaculous icon or various software shortcuts. Next, the Softaculous dashboard will appear in front of you. On this dashboard, you will be able to browse software by rating and category. Pick what you would like to install and go to the installation screen. On your display, you will find details regarding that script, which includes an overview, install, demo, screenshot, features, reviews, ratings, import option, and more. User options in Softaculous allow the default time zone to be redefined, the screen display of side menus to be adjusted, and the language to be changed. Many of the applications are associated with scripts written in standard PHP, although Softaculous also offers some PHP, Perl, and JavaScript functionality. Lastly, click on the install button. In order to reduce the amount of information that needs to be provided on the installation form, click on Quick Install under the Install dropdown arrow. If you want to configure more information and settings for installing the script, click on the Custom Install button. Then, you will need to fill in the information that is listed on the form. Depending on which script you are installing, the following information might be included on the form: Admin Account: Configure that Admin Username and Password and Admin Email address. Create a strong password by using the password strength indicator. Software Setup: Select the domain, protocol and add a directory if needed to configure the installation URL. Always choose https:// when prompted for the site protocol. Choose Language: You might be able to choose a different language for the script application you’re installing. Advanced Options: In the custom install, you might get some advanced options for the script that you are installing. These options may vary, but they usually include set auto-upgrade, disable update notification emails, table prefix, database name, and more. There is an option to have the installation information emailed to you if you want to. You can do this by filling out the Email Installation details to: section that can be found at the bottom of the form. Your software should now be installed and entirely usable. The database and files should be automatically uploaded by Softaculous . After you’re done with the process, Softaculous will display a message about whether the installation process was successful or not. In order to access the admin dashboard of the script, make sure you use the links that are provided on the successful installation page. Softaculous can be pretty beneficial. They are well known for providing timely support and quality, as well as keep their products up to date. Server management is made easier with one-click installations and automatic updates thanks to this robust tool and its excellent features.

Almost everyone knows how crucial a website and its content are. Having a full backup of your site in case something goes wrong is not only necessary but indispensable. Hex Hosting, as one of the best hosting companies there are, offers automatic 6-hourly backups to make sure you always have a Plan B. If your website suddenly stops working, you can easily restore it to the time when it last worked properly through the cPanel’s Jetbackup feature. In this article, we will provide a step by step guide on how to restore your website files and database through Jetbackup 5. Alternatively, you can download a backup of your website on your local machine if you do not wish to restore. The download button is beside the restore button, all you need to do is click the Download button and this downloads a copy of your website on your device.

FTP is a protocol used to transfer files between your hosting account and your local system. An essential part of the process of setting up the website is to publish it online, which includes uploading its files to the server where the website is supposed to be located. One of the quickest and easiest ways to do this is to access the server via FTP. . For users to connect to the host server via an FTP client, they must have access rights to this server. These authorization access rights are assigned to users as an FTP account. Each FTP account consists of a unique username and password that allows users to access files in the cPanel account. By default, you already have an FTP account in your cPanel which you can log in with your cPanel username and password. You can create new FTP accounts to provide access to other users without providing them with cPanel login credentials. For each additional FTP account created, you can also assign each user different levels of access by assigning the user to a specific directory. All our hosting plans allow you to create FTP accounts for your service. Follow the instructions below to create FTP accounts Log In: Enter your desired username, this will be your FTP usernameDomain: If you have more than one domain, select the domain this user should be tied to from the drop-down arrowPassword: This will be the password used to authenticate with your FTP user. The password must be a strong password, you can generate the password using a password generatorStrength: This field informs you about the security of your password. The strength level could range from Very Weak to Very Strong.Directory : This is the default directory on your web hosting account that the FTP user willconnect to and upload files to when you create an FTP account, it is limited to the directory specified here. cPanel will automatically populate an assumed directory based on your FTP username. You can remove everything after public_html/ and provide the directory you want the user to go to.You can also type a single / and the user will have access to your home directory this is going to be everything outside of the public_html folder).PLEASE NOTE: The FTP user will not be able to browse outside of the specified directory. However, he will be able to access all the files and subfolders in this folder. It is possible to determine the access level of a user.Quota: The maximum size of the total number of files this FTP user can upload and store in their default directory, you can limit the disk space available to an FTP user here or set it to Unlimited When all the required fields have been completed, click on the Create an FTP account button to add the new user. A message will appear indicating “Account created” and your new FTP account will appear in the FTP Accounts section.

Websites frequently use PHP scripting language for content and applications. PHP is an acronym for Hypertext Preprocessor. PHP is typically embedded in the HTML code and processed on the server. The most common CMSs, or Content Management Systems, such as WordPress, run on this technology. PHP is frequently offered along with MySQL, which is a database management system, and it is extremely simple and straightforward for new programmers. Your hosting account has PHP installed by default unless you’re on a Virtual Private Server or VPS plan. You don’t need any manual installation; you can use it directly on your sites. Usually, the last version of PHP is the best one to use from a security, performance, and features perspective. However, there are some applications that are older and are not compatible with the latest version of PHP. For this reason, you may need to make them run on an older version of PHP. The prerequisites are you need a cPanel username and password, a web hosting account that supports PHP and cPanel, and a domain name (for instance, www.example.com).Changing Your PHP Version Firstly, go into your account on cPanel and navigate to the Software Tab, in which you will find the Select PHP Version tool. Here, you can select the PHP version that your website requires. Once you’ve selected the version you need, you can press Set as current. Below, you will see the modules that are available for this precise PHP version that you’re running at the moment. In order for your website to work without any issues, you can disable or enable them as you need. At the top, you’ll find the Options tab where the PHP settings can be changed, such as upload_max_filesize, max_execution_time, memory_limit, and so on. Below, we will go over the options that you will be tweaking in most cases. That is all it takes to change the PHP version used on any site you choose. The best thing about cPanel is that PHP customization is made very easy. We hope that our guide will assist you in adjusting the settings according to your needs.

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.