How To Zip and Unzip Files in File Manager

 
This tutorial assumes you’ve already logged in to cPanel’s File Manager.
Let’s first learn how to zip the files.

  1. Select the files you want to compress by clicking on each file icon while holding the control key.
  2. Click on “testfile.html”, “newtest.html” and “Chrysanthemum.jpg” one by one.
    You have selected all of the files you want to compress. If you want to select all files and sub folders in this folder, simply click Select all. Now click Compress.

    filemgr-cpanel-10-zip-scene05_1

  3. You will get a popup asking for a compression type. Let’s choose Zip Archive.

    filemgr-cpanel-10-zip-scene06_1

  4. Click on Compress File(s) to continue.

    filemgr-cpanel-10-zip-scene07_1

    As soon as it has completed, you will get a progress window like this one. Click Close to continue.
    Your files have been successfully compressed!

    filemgr-cpanel-10-zip-scene08_1

  5. Now let’s learn how to extract a compressed file. Select the “Chrysanthemum.jpg.zip” file we just compressed.

    filemgr-cpanel-10-zip-scene09_1

  6. Click on Extract.

    filemgr-cpanel-10-zip-scene10_1

  7. It will ask you where to extract the zip file. Just choose your destination and click Extract File(s).

    filemgr-cpanel-10-zip-scene11_1

  8. Again, it will show your progress in a popup. Just click close to continue.

    filemgr-cpanel-10-zip-scene12_1

    Congratulations! You have successfully extracted the files.

    filemgr-cpanel-10-zip-scene13_1

 

How To Rename Files in File Manager

 
This tutorial assumes you’ve already logged in to cPanel’s File Manager.
You can rename files and folders the same way. There are actually two ways to do this.

  1. Let’s try it. Double click on “newtest.html”.Make sure you click on the file name only and not on an icon or anywhere else.

    filemgr-cpanel-6-rename-scene2_1

  2. One way is to double click on a “File Name” and simply type a new name.

    filemgr-cpanel-6-rename-scene3_1

    Now type a new name. In this case, we will just add “my”, so the name will be”mynewtest.html”. Press enter after you’re done.

  3. Now let’s try another method. Single click on “mynewtest.html”and then click on Rename.

    filemgr-cpanel-6-rename-scene5_1

  4. Type your new name here. In this case, we will just remove “my” from the name.

    filemgr-cpanel-6-rename-scene6_1

  5. Now click Rename File to apply the changes.

    filemgr-cpanel-6-rename-scene7_1

    You have successfully renamed the file.You can rename folders the same way.

 

Understanding cPanel Security Advisor Notices

In an effort to increase security, cPanel has modified the default notification settings for certain items that the control panel monitors. Due to the change in notification settings, cPanel users may receive notifications that they previously had not encountered. In particular, a number of changes were made to the notification options for Security Advisor beginning with the release of WHM 56.

‘New security advisor notifications with high importance’

All notifications and included recommendations should be duly noted, but it is important to understand that Security Advisor notifications come from cPanel, not Liquid Web, and they are based solely upon the limited information that their software is able to access. By design, certain software and security measures run outside of cPanel, leading Security Advisor to occasionally detect false positives or otherwise flag items which may not be applicable to your server.

This article, which will be updated periodically, is meant to serve as a point of reference for such notifications.

MySQL Listening on All Interfaces

Security Advisor Notice: The MySQL service is currently configured to listen on all interfaces: (bind-address=*) Configure bind-address=127.0.0.1 in /etc/my.cnf
This most often is a false positive. Liquid Web servers include an advanced firewall that drops traffic to all ports which have not specifically been allowed, but Security Advisor’s check is unable to take this into account. Moreover, Liquid Web’s 24/7 Sonar Monitoring™ needs to be able to connect to MySQL to monitor the service’s status. Sonar Monitoring™ uses a port which is not publicly accessible, but Security Advisor does not take that into account.

SSH Password Authentication is Enabled

Security Advisor Notice: Disable SSH password authentication in the “SSH Password Authorization Tweak” area
This message indicates only that you can log into your server with a password. For maximum security, SSH keys are typically recommended, but as long as you’re using strong passwords, you may prefer to continue the practice. In any case, you will not want to disable SSH password authentication until you have set up and tested SSH keys to connect to your server.

SSH direct root logins are permitted

Manually edit /etc/ssh/sshd_config and change PermitRootLogin to “no”, then restart SSH in the “Restart SSH” area
This message indicates only that the root user can log into your server with the proper password or SSH key. For maximum security, you ideally would want to disable the root user login and add another user for that purpose.

If you need further guidance, feel free to contact Heroic SupportĀ®.

How To Manage a MySQL Database with phpMyAdmin in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to manage a database with phpMyAdmin.
  3. Click the "phpMyAdmin" icon.

    cpanel-pl-mysql-11-phpmyadmin-02

  4. This is the phpMyAdmin main page. It is from here that you can manage all MySQL databases that exist in your hosting account.

    cpanel-pl-mysql-11-phpmyadmin-03

  5. In the top left corner, you’ll see an entry with your account user name. Click the "plus sign" to its left.

    cpanel-pl-mysql-11-phpmyadmin-04

  6. You’ll now see a list of databases in your account. Click the one you want to manage.

    cpanel-pl-mysql-11-phpmyadmin-05

  7. You can now start managing your database. You can manage tables, add or delete entries, and perform queries among other things.

    cpanel-pl-mysql-11-phpmyadmin-06

 

How To Repair a MySQL Database in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to repair a database.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-10-repair-02

  4. Under "Modify Databases", and in the "Repair Database" drop down box, select the database you want to repair.

    cpanel-pl-mysql-10-repair-03

  5. Then click "Repair Database".

    cpanel-pl-mysql-10-repair-04

  6. That’s it! The database has been repaired.

    cpanel-pl-mysql-10-repair-05

 

How To Delete a MySQL Database User in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to delete a database user.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-8-deleteuser-02

  4. Locate the "Current Users" section at the bottom of the page, and click the "Delete" icon next to the user you want to delete.

    cpanel-pl-mysql-8-deleteuser-03

  5. Then click "Delete User" to confirm.

    cpanel-pl-mysql-8-deleteuser-04

  6. That’s it! The database user has been deleted.

    cpanel-pl-mysql-8-deleteuser-05

 

How To Check a MySQL Database for Errors in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to check a database for errors.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-9-check-02

  4. Under "Modify Databases", and in the "Check Database" drop down box, select the database you want to check.

    cpanel-pl-mysql-9-check-03

  5. Then click "Check Database".

    cpanel-pl-mysql-9-check-04

  6. That’s it! The check has been completed, and no errors were found.

    cpanel-pl-mysql-9-check-05

 

How To Remove a User from a MySQL Database in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to remove a user from a database.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-7-removeuser-02

  4. In the table of databases, locate the database you wish to remove a user from, locate the specific user assigned to that database that you want to remove and click the delete icon.

    cpanel-pl-mysql-7-removeuser-04

  5. Click "Revoke User Privileges from Database" to confirm.

    cpanel-pl-mysql-7-removeuser-05

  6. That’s it! The user has been removed from the database.

    cpanel-pl-mysql-7-removeuser-06

  7. The user hasn’t been deleted … you can see it’s still listed in the list of current users. It has simply been removed from that database.

    cpanel-pl-mysql-7-removeuser-07

 

How To Change a MySQL Database User’s Password in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to change a database users password.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-6-chguserpass-02

  4. Locate the user whose password you want to change, and click "Set Password".

    cpanel-pl-mysql-6-chguserpass-03

  5. Enter and confirm a new password, then click "Change Password".

    cpanel-pl-mysql-6-chguserpass-04

  6. That’s it! The database user’s password has been changed.

    cpanel-pl-mysql-6-chguserpass-05

 

How To Assign a User to a MySQL Database in cPanel

  1. This tutorial assumes you’ve already logged in to cPanel, and are starting on the home screen.
  2. Now let’s learn how to assign a user to a database.
  3. Click the "MySQL Databases" icon.

    cpanel-pl-mysql-5-assignuser-02

  4. Under "Add User To Database", select the user you want to add, and then select the database you want to add it to.

    cpanel-pl-mysql-5-assignuser-03

  5. When ready, click "Add".

    cpanel-pl-mysql-5-assignuser-04

  6. Select the privileges you want to grant the user… in this case, let’s select "All Privileges".

    cpanel-pl-mysql-5-assignuser-05

  7. Then click "Make Changes".

    cpanel-pl-mysql-5-assignuser-06

  8. That’s it! The user has been assigned to the database.

    cpanel-pl-mysql-5-assignuser-07

  9. You can see the user assigned to the database in the table of databases.

    cpanel-pl-mysql-5-assignuser-08