Category "Latest News"

As the admin of a cPanel server, you can create or add a new package using WHM.

To Add a Package

1. Log in to your root account of WHM.

2. Select the Packages option from the navigation menu.

3. Click the Add a Package option.

A form with options to define resources and settings for the package will appear.

4. Enter the Package Name.

5. Set the resource limits for the package under the Resources section.

6. The Settings section allows the admin to include/deny your users:

• Dedicated IP
• Shell Access
• CGI Access
• Digest Authentication at account creation

7. Click the Add button to save the package.

You can use this process to add any new package for your WHM hosting.

Steps for creating backup of a MySQL database:

• Login to your control panel and go to ‘MySQL Database’.
• On the left hand side, select a database that you wish to manage.
• A list of usernames will be displayed on the right hand side, click on the Access icon for the selected username. When you click on the Access icon, phpMyAdmin page will be displayed through which you can manage the selected database.
• While your database is selected on the left hand side pane:
  • Click on the Export tab
  • All the tables will be exported quickly
  • Format SQL and Go

• Now your database will be available for downloading and other options.

How to schedule specific tables in a database for an on-demand backup?

• Login to your control panel and go to ‘MySQL Database’.
• On the left hand side, select a database that you wish to manage.
• A list of usernames will be displayed on the right hand side, click on the Access icon for the selected username. When you click on the Access icon, phpMyAdmin page will be displayed through which you can manage the selected database.
• While your database is selected on the left hand side pane:
  • Click on the Export tab
  • Change the Export method to ‘Custom’
  • Select all the tables that you want to Export
  • Change the other Export options
  • Format SQL and Go
• Now your database will be available for downloading and other options.

What to do when you are unable to schedule a MySQL database backup?

Issue : When you go to MySQL Beta >> ‘Manage Backups’ tab and when you click on a particular database name for creating the backup, nothing happens.

Why does this happen? This happens because the server is trying to post an error and it is not getting displayed. The error is : Server is busy. Please try again later.

The solution : The simple solution is that you should try to schedule the data backup at a later point of time.

phpMyAdmin is a tool that allows users to modify, alter and carry various other functions on MySQL and MariaDB databases. This tool is available on cPanel, Plesk and DirectAdmin as well.

To Modify Table Columns in phpMyAdmin

1. Log in to your control panel(cPanel, DirectAdmin or Plesk) account.

2. Browse and click on phpMyAdmin.

3. The phpMyAdmin window will open. Select a database from the list on the left side of your screen.

4. A list of tables will appear. Click on the ‘+’ icon beside the table whose columns you want to modify.

5. Click on the  ‘+’ icon beside Columns to display the list of columns in the table.

6. A panel where you can enter and modify column attributes will appear. You can change the column’s name, field length(character limit), default value, and more.

Note: Changing certain things in the table columns may result in data loss or change. For example, if the field length is changed from 20 characters to 15 characters, all data in that column will get cut down to 15 characters.

Once you have made all the modifications, click on Save.

phpMyAdmin will apply the changes and modify the table accordingly.

On a development server, at least once this situation occurs when the MySQL won’t set up with a root password.

Preflight Check

• Login without a password is not allowed by configuration (see AllowNoPassword).
• Here we will be using Ubuntu 15.04 server, and logged in as root.

The Error

You will get an error as “Login without a password is forbidden by configuration (see AllowNoPassword)” as shown below:

The Solution

You can easily enable the ability to manage MySQL via phpMyAdmin (when the root login has no password). It is as easy as changing two lines in the configuration file.

Let’s set the AllowNoPassword variable, included in phpMyAdmin’s configuration file, to TRUE. On an Ubuntu 18.04 LTS server, modify the below file:vim /etc/phpmyadmin/config.inc.php

Type in a forward slash “/” to start searching of the file. Type in “Allow” which will display the below line:// $cfg[‘Servers’][$i][‘AllowNoPassword’] = TRUE;

Now, uncomment that line. For this, just remove the two forward slashes “//” at the start of the line. Also note that there are two instances of this line in the configuration file.

Ensure that you uncomment both!

Next, exit and save the file with the below command::wq

Conclusion

After making this change, and later re-adding a password to phpMyAdmin, you can any time go back in and re-comment these lines if you want to disable this setting. You can easily modify configuration settings like these to behave in the way you want because Linux addresses almost all files as flat files.

In order to reset the phpBB admin password, you have to first locate the database for your phpBB.

You will find the database details in the config.php file; this file is situated in the installation directory of the application. Open the file through File Manager in cPanel and go to $dbname where you will find the database. For instance – $dbname = ‘user_phpdb’;

Once you locate the exact file, you can go ahead and change the phpBB admin password through phpMyAdmin, here are the steps:

• Login to cPanel and go to phpMyAdmin.
• Select the phpBB database present on the left hand side.
• Click on the ‘users’ table (for example – phpbbs_users).
• Click on ‘Browsers’ and find the username that you want to edit (admin).
• Click on ‘Edit’.
• Enter the new password in the ‘user_password’ row.
• Click on the ‘Function’ drop down menu and select MDS.
• Save all the changes by clicking on the ‘Go’ button.

After completing this process, access the phpBB admin page and check if you can login with your new password.

If you want to modify the location or time zone settings in Moodle 3, you can do this through the administration dashboard. You need to go to Site Administration >> Location >> Location settings for getting started.

The Location settings page enables you to configure many regional settings like adding the default time zone, city and country. You can also try to detect the location of a user IP address automatically.

In the location settings, you need to configure the following options:

• Default Timezone: This is the default timezone for showing the dates. Every user can overrule this setting in their profile. You must change this setting if it shows ‘Invalid Timezone’.
• Force Timezone: Through this option, you can enable the users to choose their timezone, or you can forcefully add a timezone for every user.
• Default Country: If you select a country in this option, then that country will be displayed by default on the new user accounts. You need to leave this option unset to encourage users to choose a country.
• Default City: A city entered here will be shown as the default city while creating new user accounts.

When you have made all the necessary changes, click on ‘Save changes’ for completing the configuration.

You can delete or remove pages from MediaWiki when spammers create unwanted pages on your website. When you delete a page, the page is not deleted right away. MediaWiki removes the page from the website in case the page got deleted by accident. It is possible to restore the pages from the deleted pages list.

Steps for deleting a page

• Login to MediaWiki.
• Go to the page that you wish to delete.
• Click on the drop down menu present on the right top corner of the page and click on ‘Delete’.
• The page will display a message – Delete ‘the name of the page’?
• Click on ‘Delete page’.

Note – you can restore the deleted pages later. Although the pages are removed from the website, the deleted pages can be restored again in case the page was deleted by accident.

Steps for restoring a deleted page

• Login to MediaWiki.
• Click on the ‘Special pages’ option on the left side of the sidebar.
• Go to the ‘Page Tools’ section and click on ‘View deleted pages’.
• You will find a section that says – ‘recent deleted pages’, in this section, find the page that was deleted and click on ‘view/restore’ option present in the deleted pages information.
• The ‘restore revision’ option will be displayed for restoring the page. You will have to enter the reason for deleting the page in the reason text box.
• Click on ‘Restore’.

MediaWiki will provide a confirmation that the page was successfully restored on the View and restore pages page.

This tutorial presents 2 primary methods for creating new wiki pages in MediaWiki.

Creating New Page From A Link:

Wikis are similar to most web authoring platforms and they do not consist of a ‘New Page’ option.

New pages are created by:

• Creating a link to a non-existent page.
• Following this link and adding content to it.
• Saving the page that finalizes the content creation.

Creating A New Page With The ‘Add to category’ option:

Creating a new page through the link is a slightly confusing process. Wiki authors can also create a new page through any category page.

• Go to the category page where you want to add an article.
• Enter the page name in the ‘Add page…’ section.
• Click on ‘Create.

MediaWiki is a widely used wiki platform that can be used by many users. Refer to the steps mentioned below to create a user in MediaWiki:

• Login to your MediaWiki account
• Click on the ‘Special Pages’ option present on the bottom left
• Now click on ‘Log in / create an account’ and create a new MediaWiki user account

The two ways to delete installed WordPress themes are:

• WordPress dashboard
• FTP manager

Steps for deleting WordPress themes through WordPress Dashboard

1. Log in to your WordPress account.

2. Open your WordPress dashboard and go to Appearance  -> Themes.

3. Activate the default WordPress theme i.e. Twenty Fourteen to delete the required theme.

4. To delete the theme, select the theme that you want to delete and press the Delete button in the right bottom corner.

Your theme has now been successfully removed using WordPress dashboard manager.

Steps for deleting WordPress themes through FTP (File Transfer Protocol)

1. Using the FTP manager log into your server through FileZilla and open the WordPress installation folder.

2. Go to the themes folder from the wp-content.

3. Select the theme that you want to delete from the themes folder.

4. Right-click on the theme to be deleted and delete your theme folder by clicking on Delete.

Your theme has now been successfully removed using FTP manager.