Welcome to iServerO

Archive

How to Create a MySQL Database Using the cPanel Database Wizard

MySQL databases are a way to manage the data needed to operate your website. They are an essential requirement for many website platforms, such as WordPress and Magento.

In this tutorial, we’ll show you how to create a new MySQL database and set up a username and Password for it using the cPanel Database Wizard.

1.Log into your cPanel account.

2. Scroll to the Databasessection and click on the MySQL databases Wizard icon.

3. In the Create a Database field, type a name for the database and then click Next Step.

4. In the next step, you will need to create a username and password for the database.

5. Type the username in the Username field.

6. Create a strong password and enter it into the Password and the Password (Again) fields. Use the Password Generator, if required.

7. When finished, click Create User.

8. In the next section, you will decide which privileges the user has.

9. If you are the website administrator and are creating the database for yourself to manage,  check the ALL PRIVILEGES box at the top of the page.

If you are creating a username for someone else, only check the privileges you wish them to have.

10. When finished, click on Next Step.

11. You have now completed the set up of the new MySQL database, created a username and password to manage it and assigned privileges to that user.

12. The final page of the Database Wizard (see below) gives you the options to carry out a range of related tasks.

How to Add a New (Addon) Domain in cPanel

If you want to add an additional domain (i.e. a new website) to your hosting account you can do this via cPanel. Here we’ll explain how.

1. Log in to your cPanel Account.

2. Scroll to the Domains section and click on the Addon Domains icon.

3. In the section which appears, you’ll see the following form.

4. In the New Domain Name field, enter the addon domain’s name, e.g., newadomain.co.uk.

5. When you create an addon domain name in cPanel, a subdomain is created automatically for it. Once you have filled in the new domain name section at the top, the subdomain name field is automatically populated for you. If you prefer a different subdomain name, you can change it here.

6. At the same time, the Document Root is created and named automatically for you. This is the folder where the website files for your new domain name are stored. Again, you can change the name of the folder if you wish.

7. If you want to upload files to your Document Root folder using FTP, you can set up a new FTP account by ticking the checkbox which says, ‘Create an FTP account associated with this Addon Domain.’ When you check this box, a new section appears.

8. The FTP Username will be created automatically for you. You can enter a different one if required.

9. Enter the password you want for the FTP account in the Password field and then repeat in the Password (Again) field.

10. Once you have completed the form, click Add Domain and the addon domain will be created.

How to Set Custom php.ini Values in Cagefs for PHP Selector

CloudLinux’s Cagefs allows each user to have their own custom php.ini settings with the php selector. However the options presented inside have pre-defined limits that may not work for all users.

It is possible to modify custom settings by hand through the command line.

Start by going into the command line. After you’re in, run the following command to get into the specific user’s caged environment:

cagefsctl -e <username>

This will take you to a new prompt. Once there, you can use a text editor to modify the php settings directly:Make sure to edit the correct file for the version of PHP you have selected otherwise the changes will not go into effect. Replace the XX with your version of PHP, so for version 5.4 the path would be /opt/alt/php54/link/conf/alt_php.ini

nano /opt/alt/phpXX/link/conf/alt_php.ini

Once there, you will see a section like this:

;>=== Start of PHP Selector Custom Options ===
;<=== End of PHP Selector Custom Options =====

Inside of this section, you can put in your custom PHP Variables such as memorylimit, postmax_size or any other thing you may need to change. You should put them just as if you were modifying any php.ini file, but keep them in that section to make it easy to find later if you need to change it again.