Database
How to create a database in cPanel?
Here are the steps to log into your Databases: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click the MySQL Databases icon. 3. Under Create New Database, enter the name you want to give to your database. 4. Click the Create Database button. CSome readersHow to create a MySQL database?
MySQL is a popular relational database management system (RDBMS), offering a variety of practical tools. It can be used to create, edit and extract data from relational databases. To do this, it uses the SQL programming language. It can also be used to control each user’s access to a database. Here are the steps to create a MySQL database: Log into your cPanel interface (via your customer accoSome readersHow to add a user and his privileges to a database?
Here are the steps to add a user and his privileges to a database: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on MySQL Databases Icon. 3. Scroll down to the end of the page and under Add User to Database, select a user from the dropdownFew readersHow to repair database via phpMyAdmin in cPanel?
Here are the steps to repair database via phpMyAdmin in cPanel: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on the phpMyAdmin icon. 3. Under your cPanel username, you can see a list of all databases. Select the appropriate database which you wFew readersHow do I delete a database in cPanel?
Here are the steps to delete your database: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on MySQL Databases Icon. 3. Under Current Databases, you can see a list of all your databases. Locate the Database you wish to remove and then clickFew readersHow to optimize the database via phpMyAdmin in cPanel?
Here are the steps to optimize the database via phpMyAdmin in cPanel: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on the phpMyAdmin icon. 3. Under your cPanel username, you can see a list of all databases. Select the appropriate database whichFew readersHow to set up a remote MySQL access via cPanel?
Before you can remotely connect to your databases, the IP operating via a remote connection must be allowed on your account. Here are the steps to configure a remote MySQL access: Log in to your cPanel account (via your customer account or https://www.bmoname.com:2083). In the Databases section of the control panel, click the MySQL Remote icon. (https://storage.crisFew readersHow to back up your MySQL database?
The Ex2 system offers you two different ways to back up your MySQL database: by using the backup wizard you will find on the cPanel, or by using phpMyAdmin. Back up your MySQL database using the cPanel Backup Wizard Ex2 provides you with a very complete backup wizard that you will find in your cPanel. This backup wizard allows you to back up your entire website, including your database, or to back up only certain elements of your website. By clicking this link, you will find all the informaFew readersHow do I create a database username in cPanel?
Here are the steps to create a database username: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on MySQL Databases Icon. 3. Under MySQL Users in the Username field, enter the new username you wish to create. 4. Enter your new password orFew readersHow to connect to a MySQL database?
In order for the MySQL database to work, you will first need either to use a calling script or to query the database for the information it stores. To do this, you need to connect your script to the database using a configuration file. What are my database configuration settings? Platforms like WordPress, WHMCS, and Joomla usually have a default configuration file ready for you to edit with the appropriate information. Hostname = localhost Database name = cpanelUsernamedatabasFew readersHow to repair a MySQL database?
MySQL is a popular relational database management system (RDBMS), offering a variety of practical tools. It can be used to create, edit and extract data from relational databases. To do this, it uses the SQL programming language. It can also be used to control each user’s access to a database. However, there may be a problem with your databases. In this case, you may have to repair them. Fortunately, the process is very simple and easy to perform. Here are the steps to repair a MySQL databasFew readersHow to export database table via phpMyAdmin in cPanel?
Here are the steps to export database table via phpMyAdmin in cPanel: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on phpMyAdmin Icon. 3. Under your cPanel username, you can see a list of all databases. Please select an appropriate database whiFew readersHow to delete database table via phpMyAdmin in cPanel?
Here are the steps to delete database table via phpMyAdmin in cPanel: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on phpMyAdmin Icon. 3. Under your cPanel username, you can see a list of all databases. Select the appropriate database, and it wFew readersHow to rename a database in cPanel?
Here are the steps to change the name of your database: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on MySQL Databases Icon. 3. Under Current Databases, You can see a list of all your databases. Locate the Database and then click on RenaFew readersHow to edit database table via phpMyAdmin in cPanel?
Here are the steps to edit database table via phpMyAdmin in cPanel: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on the phpMyAdmin icon. 3. Under your cPanel username, you can see a list of all databases. Select an appropriate database which yoFew readersHow to import database via phpMyAdmin in cPanel?
Here are the steps to import database via phpMyAdmin in cPanel: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on phpMyAdmin Icon. 3. Under your cPanel username, you can see a list of all databases. Select an appropriate database in which you wanFew readersHow to access phpMyAdmin via cPanel?
phpMyAdmin is a powerful tool for managing your database content. It is accessible via your cPanel hosting control panel. Here’s how to access phpMyAdmin. The steps to follow in order to access phpMyAdmin via cPanel: 1. Log into your cPanel interface "https://www.domainname.com:2083" or by going through your client area. 2. In the Databases section, click on phpMyAdmin Icon. (https://sFew readers
FTP
How to Access or Connect to Your FTP Account via the FileZilla FTP?
You can access your FTP Account using the FileZilla FTP Client or any FTP Client. Here's how to access or connect to your FTP account via the FileZilla FTP 1. Open the FileZilla FTP Client. 2. Enter your FTP Host, Username and Password. You can use your cPanel username and password as your FTP User and Password. In the Host field, Enter your domain name such as ftp.example.com or example.com. 3. Click on Quick Connect,Some readersHow to use Filezilla to transfer files via FTP?
To transfer files, the first step is to locate the FTP access credentials. A. Locate your FTP access credentials Log into your cPanel account. Click the FTP Accounts button in the Files section. Scroll down to the FTP Accounts section. Click ConfiguSome readersHow to configure my FTP client ?
If you want to use an FTP client to upload your web files to the server, you will need to use the correct login credentials, which includes your FTP hostname, username and password. You can then use the FTP information to set up your FTP client. If you are using : FileZilla, CoreFTP or Cyberduck, then you can use the Configure FTP Client tool in cPanel to auto-configure your FTP client. Here's how to configure your FTP client The first step is to locate your FTP access credentials.Some readersHow to create an FTP account in cPanel?
You can use your cPanel username and password to access all folders and files via FTP. However, if you want to create an FTP user account for a specific folder or you don't want to allow access to your root files then you can create a separate FTP Account. Here's how create an FTP account in cPanel 1. Log into your cPanel account. 2. In the Files section, click on FTP Accounts Icon. (https:Some readersHow to Install the FTP Client Filezilla on Windows?
Installing the FileZilla FTP Client on Windows OS is easy. Just follow this tutorial. Here's how to install the FTP Client Filezilla on Windows 1. Download the Filezilla FTP Client Installer file for your Windows OS. 2. Double click to Run the FileZilla FTP Setup File. It will show a security warning. Please read and accept it or click the Run option. 3. The FiFew readersHow do I delete an FTP user account from cPanel?
If you have created too many FTP User accounts and some of these have not been used, and you want to remove an FTP Account, then you can accomplish this by following this tutorial. Here's how to delete an FTP user account from cPanel 1. Log into your cPanel account. 2. In the Files section, click on FTP Accounts Icon. 3. Under the FTPFew readersHow to download files and folders to your computer using FileZilla?
Here's how to download files from your website to your Computer using FileZilla Client. 1. Open FileZilla FTP Client. 2. Enter your FTP Host, Username, and Password. You can use your cPanel username and password as your FTP User and Password and then click on the Quick Connect button. In the Host field, You can use your domain name like ftp.example.com or example.com. 3. In the right-hand side inside the Filename box seFew readersHow to use Cyberduck to transfer files via FTP?
Cyberduck is a powerful and free software for transferring files over the Internet. It is a very popular FTP client and is used by webmasters around the world. Here's how to log in to your account with Cyberduck? To access your account via FTP with Cyberduck, open the app and click the Open Connection button. In the new screen that opens, you must provide the following connection information: Server: the hostFew readersHow to Create or Delete a Directory Using the FileZilla FTP Client?
Here's how to create or remove directory on your website using the FileZilla FTP Client. 1. Open the FileZilla FTP Client. 2. Enter your FTP Host, Username, and Password. You can use your cPanel username and password as your FTP User and Password and then click on the Quick Connect button. In the Host field, you can use your domain name like ftp.example.com or example.com/ 3. Now, should you wish to create a directoFew readersHow to change the password of the FTP account in cPanel?
If you want to change the main root FTP Account, then you need to change the password of your cPanel Account. However, if you're going to change the password of a specific FTP Account, you should follow this instruction. Here's how to change the password of the FTP account in cPanel 1. Log into your cPanel account. 2. In the Files section, click on FTP Accounts Icon. (https://www.ex2.com/clFew readersHow to change the FTP user quota in cPanel?
If you want to increase/decrease the FTP Quota or to use an Unlimited FTP Quota but also want to set a limit, then follow these steps to modify the FTP User quota. Here's how to change the FTP user quota in cPanel 1. Log into your cPanel account. 2. In the Files section, click on FTP Accounts Icon. 3. Under the FTP Accounts list, clickFew readersHow to change the extension of a file via FTP or SSH?
Sometimes it might be necessary to change a file extension to make sure it works as intended. For example, if you create a text file on your computer, it is saved with the .txt extension. If the file should be a phpinfo.php file, . htaccess, or other, the extension must be modified or removed. This article explains how to adjust the file extension via FTP or SSH. File extensionFew readersHow to upload the Index file to your site using FileZilla?
Maybe you are a web designer, or you have an index file and want to upload it to your site. You can follow this tutorial to upload your web site files on your hosting account. Here's how to upload the Index file to your site using FileZilla 1. Open FileZilla FTP Client. 2. Enter your FTP Host, Username, and Password. You can use your cPanel username and password as your FTP User and Password and then click on the Quick Connect button. In the Host field, You can use your domain name like ftFew readers
Htaccess
What is the .htaccess file and what is it used for?
The .htaccess file A .htaccess (hypertext access) file is a unique configuration element that controls the operation and execution of a web server. Only some servers support the use of .htaccess, including sites running Apache. The file, however, plays an important role in keeping your site accessible. WordPress software adds a list of directories to a web server at each installation on a hosting account. Core directories include wp-admin, which stores administrative files, and wp-contSome readersHow to change the PHP version of a folder or subdomain?
If you want to update the PHP version applicable to your account, you can do so directly from cPanel. You can also modify the PHP version for only one of your domains, subdomains or folders. Simply add a line of code to the .htaccess. Steps to change the PHP version of a folder or subdomain Log in to your cPanel account (via your customer account or https://www.bmoname.com:2083). In tSome readersHow to restrict directory access by IP address?
Here's how to restrict directory access by IP address To secure your admin area from hackers, we recommend that you allow access only from a selected IP address to your admin directory. You need to create a .htaccess file in the directory where you want to restrict access to specific IP addresses. For example, if you have a WordPress blog installed on your main directory and log in via example.com/wp-admin, you should create an .htaccess file in /wp-admin/.htaccess, and you should puSome readersHow to redirect non-www urls to www?
Redirecting non-www requests to the www version of your website URL is good for SEO. Not only will this help you avoid duplicating content on Google, but it will also avoid splitting your inbound links on 2 different URLs. In this article, we will learn how to redirect non-www URLs to www URLs using the .htaccess file in your publichtml folder. Here's how to redirect non-www urls to www Editing the .htaccess file To redirect a non-www url to www, we need to add a rule in the .htaccessFew readersHow to create a .htaccess file?
Steps to create and upload a .htaccess file You can create a file . htaccess with any text editor (Notepad, MS Word, etc.). You must aboslutely name the file exactly .htaccess otherwise it won't work. It is necessary to include a dot in front of the name to hide the file. Use your favorite text editor, create a file named .htaccess on your desktop or any other local folder. AdFew readersHow to redirect a page to another page or website using htaccess?
If a page on your website no longer exists and you want to redirect it to your new page or site, then you can use the .htaccess file for redirection without waiting. Redirect from a page/directory to another domain or the main domain: Redirect from a specific page to a domain: RewriteEngine on Redirect 301 /mypage.html http://example.com Redirect from a page to another page: NoFew readersHow to protect your htaccess file?
For security purposes, we recommend you to prevent access to your .htaccess file from unauthorized access. Add this code to your .htaccess file:Few readersHow to create a user-friendly url using htaccess?
If your website is using long URL like example.com/files/folder/sitemap.html, you can change it into "example.com/sitemap" in .htaccess Here's how to create a user-friendly url using htaccess Modify this line according to your needs and then add this code to your .htaccess file.Few readersHow to disable browsing on a directory with htaccess?
Here's how to disable browsing on a directory with htaccess For security purposes, we recommend that you disable directory browsing on your website so no one can see the files/folders of your website. You can disable Directory Browsing by adding this line to your .htaccess file. Options -IndexesFew readersHow to ban any IP address via htaccess?
Here's how to ban any IP address via htaccess If someone is trying to hack your website or you want to block their IP Address, you can add this line to your .htaccess file. Replace "IP-ADDRESS" with the IP Address you want to block.Few readersHow to fix a PHP error: maximum size allowed for memory of x bytes exhausted?
Here's how to fix a PHP error: maximum size allowed for memory of x bytes exhausted If you are getting an error like "Allowed memory size of... in file /directory/folder/yourscript.php", then you can use a .htaccess trick to resolve this problem. If this error does not go away even after applying this .htaccess code, you should contact us, and we will help you. Place this code in the .htaccess file of your main domain and if this error persists even after you have used the code, enter it iFew readersHow to protect your .htaccess file?
Here's how to protect your .htaccess file For security purposes, we recommend you to prevent access to your .htaccess file from unauthorized access. Add this code to your .htaccess file: .htaccess protection order allow, deny deny from all satisfy allFew readers
How to use SSH access on Ex2 hosting?
Validate your access To benefit from SSH access on your Ex2 hosting, and for security reasons, please contact support by providing us with a copy of your identity document. Once your access is unlocked, there are three methods to authenticate yourself: with a username and password ("classic" method) with an SSH key or directly (autologin) in the terminal available on your cPanel For the SSH connection with an identifier and a password, you must use the same identifiers as foPopularHow do I restore my website?
To restore a backup of your website to a given date, you need to: 1- Restore your files Log in to your cPanel, click on "Jetbackup" Select "File backups" Jetbackup 2 Cpanel Ex2 Choose the date that suits you, then "FiFew readersWhat are the differences between SSH and FTP ?
SSH (or Secure Shell) is a cryptographic network protocol used to secure network connections over an unsecured network. To use SSH, you must use an SSH client to connect to the server. Once logged in, you can manually run commands in a terminal application. All connections within your SSH client go through a secure connection rather than plain text. As a result, the connection is encrypted and secure. The differences between SSH and FTP FTP FTP uses an FTP client (such as FilezillaFew readersWhich folder should I use, public_html or www?
About the publichtml and www folders The publichtml and www directories as the same function. We invite you to drop the content of your website in the "publichtml" directory. At Ex2, we recommend Filezilla or FlashFXP software for uploading content to your website. However, hundred of softwares are compatible with our servers. If you have any questions, please do not hesitate to contact us.Few readersHow can I see the PHP limitations for my account?
Here's how to view the PHP limitations on your server's phpinfo page: log into your cPanel then in your File Manager, create the phpinfo.php file in your publichtml folder. You need to add the following code to your newly created phpinfo.php file: Save and close the file. Once it's done, call this file by gFew readersHow do I download the free backups from ex2 hosting plans?
When you purchase a CMS plan, shared, Ecommerce or Wordpress with Ex2, you automatically have daily free backups. We keep the last 6 days as well as a backup on D-15 and D-30 For example, if it is July 28, you will have access to these backups: July 1, July 14 and July 22-23-24-25-26-27. Here’s how to download a backup of your site from cPanel. Log in to your cPanel account. Go to tFew readersHow to do a backup of your Ex2 website?
*For security purposes, it is essential that you regularly back up, locally or on a hard drive, all the folders and files that make up your website. Ex2 provide you with a very complete backup wizard accessible directly from the cPanel to give you a perfectly secure service. This service will allow you to very easily and quickly create a backup of all the files on your website, or only certain parts, then download the archive created on your computer in order to guarantee maximum security (you cFew readers