How to access MySql root user using the command line?

Often in the case of big databases or lack of user interfaces you need to do MySQL functions using the command line on your server. In this article, we will discuss How to access MySql root users using the command line?

We try to minimize this article as we can.

  1. Login to SSH using your credetial vis putty/bitvise etc.
  2. Now copy this comand and paste on your ssh terminal.
mysql -u root -p

After this terminal will ask for the root MySQL password provide a password to be processed.

In the case of cyberpanel Mysql root password location is. /etc/cyberpanel/mysqlPassword. use cmd to show.

cat /etc/cyberpanel/mysqlPassword

Read: How to connect CyberPanel with CyberPanel Cloud?

Read more: How to create, delete and manage Child Domains in CyberPanel?

Follow US on Facebook / Twitter Instagram .

CyberPanel Features List

This article will discuss the CyberPanel features list. All the features discussed in detail. This CyberPanel features list has all the features CyberPanel has.

CyberPanel Dasboard:

After login, you come to the base page, which is the CyberPanel dashboard. On the dashboard, you can see a sidebar on the left side, in this sidebar you can almost the feature of CyberPanel. In the center of the page you see those feature buttons you can access these feature from the sidebar lists or you can access through these buttons. On the right, you can see the Resources bar here you can see CPU usage, Ram usage, and Disk usage in percentage, how much you used the resources.

compelet cyberpanel features list

This is the all I discuss above are belong to the base/dashboard page of CyberPanel. now I’m discussing the sidebar feature list one by one.

CyberPanel Features List details

Sidebar in CyberPanel Dashboard:

here is the whole sidebar or CyberPanel Dashboard, the Sidebar is divided into three section that is Overview, Main, and Server.

Overview

In the Overview section, there is the general information of your server,
On the Top, you can see the IP address(255.255.255.255) that IP is your server IP address.
The next button is the Dashboard button, after clicking on this button go to the dashboard.
The next button is version management, if you want to know about your CyberPanel version click on this button.
The last button in this section is Connect if you want to connect your server to the CyberPanel Cloud then click on this button

CyberPanel Dasboard:

Read More: How to Change Upload limit On CyberPanel?

Main

On the second section of the CyberPanel dashboard sidebar, you can see a lot of feature dropdown lists,

Users

This first feature is Users when you click on Users a dropdown list shown on your sidebar that has a lot more features.
View Profile, this feature shows your account details e.g Username, Account ACL, Email, etc.
Create New User, if you want to create a new user click on this button.
List Users, if you want to list all users of CyberPanel click on this button the all use show on your screen.
Modify Users, as the name shows, this button is for update/modify your user’s information.
Reseller Center, This feature issue the Reseller account.
Create New ACL, This feature is for Creating a new ACL (Access Control List)
Delete ACL, if you want to Delete ACL (Access Control List) this feature is for deleting.
Modify ACL, if you want to modify or update ACL (Access Control List) click on this.
API Access, Enable or disable via this button.


Main

Websites

On the Section, the whole information about your websites that you are deployed on this server.
Create Website, You can create a new website by clicking on the button
List Website, You can list you all website that are deployed on your this server
List Child Domains, if you want to List all Child domain you can view all by clicking on this button
Modify Website, if you want to update/Modify your website click on this button
Suspend/Unsuspend,
Delete Website, if you want to delete your website click on this button.

Websites

Packages

Packages on CyberPanel help you assign resources to an individual website, you must create at least one package before you start creating websites.
Create Packages, You can create a package according to your requirement.
List Packages, List all Packages.
Delete Package, Delete the packages you won’t need anymore.
Modify Package, If you feel the need to modify the parameters for the existing package you can do so via modify package page.

Packages

Database

On the Database, you can create, delete, list, and access your database
Create Database, if you want to create a new database click on this button
Delete Database, On this button, it will delete the database
List Database, On this button it will list the database after selecting the website
PHPMyAdmin, if you want to access your PHPMyAdmin click on this button.

Database

DNS

On this Button the whole information about DNS(Domain Name Server)
Create Nameserver, You can create a NameServer according to your requirement via this button.
Config Default Nameservers, Configure Nameserver via this Button
Create DNS Zone, Before you can use the “ADD/MODIFY DNS Records” page you have to create a DNS zone first, this is the first step to start using the DNS server.
Delete Zone, Once the DNS zone is created you can delete the zone using this button.
Add/Delete Records, Once the DNS zone is created you can add or delete records using this button.
Cloudflare, In version v2.0.0, CyberPanel has added the ability to synchronize DNS entries between Cloudflare and CyberPanel DNS on your own server

DNS

Email

In this section, you can create, list, delete email, etc,
Create Email,
if you want to create a new email then click on this
List Email, This button is for List all Email created on the website.
Delete Email, if you want to delete Email click on this button
Email Forwarding,
Change Password, if you want to update or change the password of your email click on its button
DKIM Manager, access DKIM manager through this button
Access Webmail, access Webmail(Rainloop) through this button

email

FTP


Create FTP Account, click on this button to create a new FPT account
Delete FTP Account, if you want to delete an FPT account click on this button
List FTP Accounts, This button is for List all FTP account

ftp

Backup

Taking complete backup of a website account is simple.
Create Back up, If you want to create a backup click on this.
Restore Back up, Backup restore only works with backups generated through the backup generation tool in CyberPanel.
Add/Delete Destination, if you want to Add or Delete Back up Destination click on this
Schedule Back up, if you want to schedule your website’s backup then click and produce.
Setup Google Drive, This feature is for Google drive one-click backup
Remote Backups, this feature is for Remote backup

backup

Incremental Back up

CyberPanel version v1.9.1 adds supports for incremental backups,  Local, SFTP, S3 backup
Create/Restore Back up, you can create a local or remote incremental backup.
Add/Remove Destinations, From this button, you can directly go to backup destinations.
Schedule Backups, if you want to schedule your website’s backup then click and produce.
Restore from Remote this feature is for Incremental Remote backup

incbackup

SSL


Manage SSL, If you want to Manage SSL click on this button and manage
Hostname SSL, If you want to issue Hostname SSL you can issue it via this button
MailServer SSL, this button is for Mailserver SSl

ssl

Server

The third and last section of CyberPanel sidebae is server.

Web Terminal:

CyberPanel v1.9.2 onwards has a web terminal (to access your server SSH). However, in some browsers, you might not be able to use Web Terminal with default self-signed SSL. In that case, just set up CyberPanel on SSL. Now access CyberPanel using that domain.

server

Cloudlinux

CloudLinux and CageFS is available with CyberPanel v.1.8.6, but before using any of its features, you need to convert your operating system to CloudLinux OS. Use the commands below to convert your server to CloudLinux OS.
Create Package,
List Packages,
Monitor Usage,

cloudlinux

Containerization

Containerization feature (v1.8.0 and above required, currently only CentOS is supported) offers to limit website resources and have no link to our Docker Manager feature. With containerization you can limit various system resources for a website, groups are used on the back end to enforce these limits. You can limit:

  1. CPU Usage.
  2. Memory Usage.
  3. Network Usage.
  4. Disk Usage (IO and IOPS)
Containerization

Docker Manager

CyberPanel gives you the ability to manage your Docker container and images the easy way. Some of the exciting features of CyberPanel Docker Manager:

  1. Search and pull images from Docker Hub (Along with tags).
  2. Prune the system.
  3. Create Container from available/pulled images.
  4. List and manage container that includes:
    1. Start/Stop Containers.
    2. View Logs.
    3. Export the file.
    4. View Processes inside the container.
    5. Delete Containers.
    6. Re-create containers.


Manage Images,
Manage Containers,
Create New Container,

Containerization

Tuning
LiteSpeed Tuning,
PHP Tuning,

tunning

Server Status

This feature is for check your server status and maintains it.
Top Processes, from this feature you can check Top process.
LiteSpeed Status, from this feature you can LiteSpeed status
CyberPanel Main Log File, from this feature you can check CyberPanel Mail log files
Services Status, from this feature you can check your servers Status
Change Port, if you want to change your port then this feature is for that
Package Manager, from this feature you can access your package manager

status

PHP


Install Extensions, if you want to install extensions e.g. redis etc extension you can install via this option
Eidt PHP Configes if you want to change or configure your PHP version or anything else then you can change from this option

php

Logs

This is main featuer of CyberPanel. if you want see your server log you can watch from the option you can see:
Server Mail,
Access Log,
Error Logs,
Email Log,
FTP Logs,
ModSec Audit Logs,

logs

Security

This feature is for your server security. there is a lot of more feature in this.
Firewall, you can stop, start, reload, and add/delete firewall through his option
Secure SSH, Securing SSH is one of the most important tasks of a system administrator. CyberPanel allows you to change SSH port, disable root login and save your SSH keys.
ModSecurity Conf, this feature is for ModSecurity configuration.
The ModSecurity Rules, if you want to add/remove update or anything else with ModSecurity Rule you can from this option
For the ModSecurity Rules Packs, you can check the ModSecurity Rule pack from this option.
CSF, You can configure CSF(ConfigServer Security & Firewall) from this button
CageFS, you can enable/disable CageFS from this button
Immunity 360, you can enable/disable Imunify 360 from this.
ImunifyAV, you can enable/disable ImunifyAV from this.

security

Mail Settings

This feature is related to your emails.
Mail Queue, If you want to see your mail Queue(pending mails) you can see.
Email Policy Server, this feature s for Email policy.
Email Limits, this feature is for email limits
SpamAssassin, you can Install SpamAssassin through this feature.
Email Marketing, this feature is for Email Marketing
MailScanner, If you want to install or remove MailScanner you can from this feature.

mail

Manage Services

This feature is related to your server Service and application that you can install and check status.
Applications, you can install and uninstall applications from this feature.
Manage PowerDNS, PowerDNS is the service you can check this form this option
And Manage Postfix, you can check postfix service form this option
Manage FTP, you can check FTP form this option

manage

Plugins

You can install new plugin and uninstall installed plugin from this feature.

plugin

This are the main CyberPanel features list.

Here you can read How to log in to the Rainloop admin dashboard?

Read More: How to Change Upload limit On CyberPanel?

How to Change Upload limit On CyberPanel?

You can follow us on Facebook too.

How to Access Rainloop Webmail in CyberPanel?

A lot of CyberPanel user uses Rainloop to handle their email. Rainloop is an internal email solution with CyberPanel. Here in this article, we will discuss how you can access Rainloop webmail in CyberPanel?

Rainloop is an efficient memory webmail solution. it is a fast, simple, and modern web-based client email client. Rainloop is the email solution that comes with CyberPanel. It has an amazing user interface. Not only the interface also works great as any other email services.

This article is specifically about access rain loop webmail in CyberPanel.

Follow these steps Access Rainloop Webmail in CyberPanel:

Login you CyberPanel:

First of all, you need to log in to the CyberPanel dashboard. For this, you must have a username and password (admin or non-admin). Visit your the server IP or hostname with port 8090 to login to cyberpanel.

https://<ip/hostname>:8090
CyberPanel Login

2. Create and Email to Login:

Here you can read How to create email account. After creating mail keep these records so you can use to login.

3. Access WebMail:

To access webmail simple go to the Email->Access WebMail. you will be redirected to the link:

https://<IP/Hostname>:8090/rainloop/index.php

provide your email and password to login.

How to Access Rainloop Webmail in CyberPanel?
How to Access Rainloop Webmail in CyberPanel?

4. Rainloop Admin settings:

if you want to change Language, Layout, Default Text Editor, Message on Page, Notifications, etc settings. Login into rainloop admin dashboard and change there.

Here you can read How to log in to the Rainloop admin dashboard?

Read More: How to Change Upload limit On CyberPanel?

How to Change Upload limit On CyberPanel?

How to log in to the Rainloop admin dashboard?

Sometimes we need to log in to the rainloop dashboard to do some configurations. Here in this article, we will tell you how to log in to rainloop admin dashboard?

Rainloop is an efficient memory webmail solution. it is a fast, simple, and modern web-based client email client. Rainloop is the email solution that comes with CyberPanel. It has an amazing user interface. Not only the interface also works great as any other email service.

RainLoop Admin Dashboard access address:

To access rainloop dashboard you just need to go to.

http://your-webmail.domain.com/?admin

But in case of cyberpanel it will be like:

https://<IP/Hostname>:8090/rainloop/?admin

You can access rainloop web admin using this link.

How to login to Rainloop admin dashboard?
How to login to Rainloop admin dashboard?

RainLoop admin Password:

Default login is “admin”, password is “12345”. But in the case of CyberPanel and changed password here is the location of rainloop admin password.

CyberPanel Rainloop admin password location:

/usr/local/CyberCP/public/rainloop.php

General Rainloop admin password location:

/var/www/rainloop/data/_data_/_default_/configs/application.ini

How to Access Rainloop Webmail in CyberPanel?

How to force redirect HTTP to HTTPS website in CyberPanel?

In this article we will tell you how to force redirect HTTP to HTTPS website in CyberPanel?

What is HTTP?

HTTP stand foe Hypertext Transport Protocol. When you enter http:// in your address bar in front of domain, it tells the browser to connect over HTTP. HTTP use TCP(Transmission control protocol), generally over port 80, to send and receive data packets over ther web.

What is HTTPS?

HTTPS stands for Hypertext Transfer Protocol Secure (also referred to as HTTP over TLS or HTTP over SSL). When you enter https://in your address bar in front of the domain, it tells the browser to connect over HTTPS. Generally sites running over HTTPS will have a redirect in place so even if you type in http:// it will redirect to deliver over a secured connection. HTTPS also uses TCP (Transmission Control Protocol) to send and receive data packets, but it does so over port 443, within a connection encrypted by Transport Layer Security (TLS).

Redirect from HTTP to HTTPS

if you forcefully redirect your website HTTP to HTTPS in Cyberpanel, you will need to add a rewrite rule to that website in order to have it automatically forward to HTTPS instead of HTTP.

In CyberPanel you can forcefully redirect HTTP to HTTPS website using rewrite rules.

To add this:

Force redirect HTTP to HTTPS website in CyberPanel:

  1. Select Websites on the left menu
force redirect HTTP to HTTPS website in CyberPanel

2. Choose the SSL enabled website from the list

force redirect HTTP to HTTPS website in CyberPanel

3. Select “Rewrite Rules” in the Configuration section

force redirect HTTP to HTTPS website in CyberPanel

4. Copy and paste the following code:

force redirect HTTP to HTTPS website in CyberPanel
rewriteCond %{HTTPS} !on
rewriteCond %{HTTP:X-Forwarded-Proto} !https
rewriteRule ^(.*)$ https://%{SERVER_NAME}%{REQUEST_URI} [R,L]

5. Now just save your changes, and you’re done!

After doing this on OpenLiteSpeed you must have to restart your webserver. Beacuse OLS need to restart to read the rewrite rules properly.

How to add ZeroSSL on your site? Free SSL for your website?

Read More: How to Change Upload limit On CyberPanel?

How to Change Upload limit On CyberPanel?

How to add ZeroSSL on your site? Free SSL for your website

How to add ZeroSSL on your site? Free SSL for your website

You always need a secure URL for your website. Secure means your website will be accessible with SSL(Secure Sockets Layer). It’s very important to access your site on HTTPS instant of HTTP. Today I will tell you how you can add ZeroSSL to your website. ZeroSSL is totally free for your website.

ZeroSSL allows the free start of three domains. You can add free-of-cost SSL to your first three sites after those you have to buy if you want to issue SSL for more sites.

Create ZeroSSL account:

In first step you have to create an account on ZeroSSL website. For this go Here.

Here on this page you can see the Get Free SSL button click on that and visit to registration button.

On this page you have to provide some information to signup.

  1. Subscription Plan
  2. Email Account
  3. Password

After providing these all press to the Next Step button.

Once you press this button you can see the ZeroSSL dashboard.

Create New SSL Certificate:

Here on Dashboard you can see New Certificate button press this button present in the above image.

On the next page you have to provide following information:

  1. Enter Domain (Enter your domain name for which you want to issue SSL)

You will see this Green ticks for a valid domain name.

2. Validity (For how many time this ssl is valid )

Usually for 90 days its free and if you want for 1 year you have to buy.

3. CSR & Contact

Finalize Your Order (you have to select )

You have limit to issue three free ssl to your domain. Once the process of plan selection done now you have to verify your domain.

Verification Method:

ZeroSSL allow three types of verification:

  1. Email Verification
  2. DNS (CNAME) HTTP  
  3. File Upload

You can chose any one you are comfortable with. If you have this email then use it, or update DNS records according to the second or upload the file to dns.

Verification Method:
Verification Method:

After this you will get a option to download SSL. you can download crteficate.

download SSL
download SSL

Add ZeroSSL to your Website?

When you got your SSL file there must be three files after extracting. ca_budle, certificate, private key

Add these files values according to the require mint on your site.

Read More: How to Change Upload limit On CyberPanel?

How to Change Upload limit On CyberPanel?

How To Uninstall Or Stop ImunifyAV?

What is ImunifyAV?

A lot of users install ImunifyAV but after some issue, if they want to uninstall they do not know how to do this. Here in this article, we will tell you How To Uninstall Or Stop ImunifyAV?

ImunifyAV – an intelligent antivirus and security monitoring tool for websites with one-click automatic malware cleanup, domain reputation monitoring, and blacklist status check. Read more about ImunifyAV

A lot of users install ImunifyAV but after some issue, if they want to uninstall they do not know how to do this. Here in this article, we will tell you How To Uninstall Or Stop ImunifyAV?

In this artical we provide the way where you can able to uninstall or Stop ImunifyAV.

Uninstall ImunifyAV:

To uninstall ImunifyAV, you need to first download the imav-deploy.sh script with the following command:

wget https://repo.imunify360.cloudlinux.com/defence360/imav-deploy.sh

Then run this command to uninstall ImunifyAV from the server:

bash imav-deploy.sh --uninstall

Processing the above two steps you are able to uninstall imaunifyAY.

Stop ImaunifyAY:

ImunifyAV runs as a daemon so the service can be managed using the standard service management commands.

For CentOS/CloudLinux OS 6, run the following command:

service imunify-antivirus stop

For all other operating systems, run the following command:

systemctl stop imunify-antivirus

How to Change Upload limit On CyberPanel?

How to solve the can’t upload the file on file manager issue in CyberPanel?

if you are uploading a file on file manager in CyberPanel. and getting some error there. Follow this short solution for can’t upload the file on CyberPanel file manager.

Solution

There is very easy and short solution for this issue. Access your root through Bitvise or putty open your terminal(CLI) and run this Command

Systemctl restart lscpd

This simple command will restart all of your CyberPanel services and now if you can try you can easily upload any file but there may be upload limit issue if so you can follow this tutorial to solve that Link below.

How to Change Upload limit On CyberPanel?

Reset or Change CyberPanel Admin Password

Reset or Change CyberPanel Admin Password

Do you know how to change CyberPanel Admin Password? Read this short article to check and know how to change or reset the admin password on CyberPanel.

Methods to Change or reset CyberPanel Password:

  1. Reset Cyberpanel Password using Command line.
  2. Change Password From CyberPanel

Reset CyberPanel Password using Command line

Mostly you use this method when you don’t have your CyberPnael Credentials are forgotten your CyberPanel password. And you have root SSH access to your system.

To change the Cyberpanel password from the command line you just need to run a simple command.

adminPass Your_New_Password

This command helps you to reset your password easily without having any CyberPanel access.

Reset CyberPanel Password using Command line
Reset CyberPanel Password using Command line

Change Password From CyberPanel:

If you have your CyberPanel admin account access and you want to change it you just need to follow these easy steps.

Login to your cyberpanel account using your credentials on port 8090.

https://<your_ip>:8090

Once you login into your account clicks on the arrow on the top of your cyber panel account.

CyberPanel Profile
CyberPanel Profile

Then click the Edit Profile button. You can see a screen that ask you to select the account for which you want to change the password of CyberPanel.

Edit Profile
Edit Profile

On this page, you can see you can change the password for your account and you can easily generate a password by clicking the generate password button.

Generating a password is a good move because CyberPanel auto-generate password will always generate a strong password.

Change CyberPanel Admin Password
Change CyberPanel Admin Password

Read more: How to create, delete and manage Child Domains in CyberPanel?

Follow US on Facebook / Twitter Instagram .