let us take a closer look at how to set up and set up the Remote MySQL CyberPanel. With the support of our Server support services at Bobcares, we can give you a step by step guidance on the configurations.

1. Setting up a remote MariaDB server for CyberPanel

1.1 Using Remotely-hosted database service

Just consider that we are using Amazon RDS, Google Cloud SQL, or Azure SQL. So in this case, we have to ensure the SQL user has the right to create new databases. We must ensure that we have hostName, Port, username, password, and Schema Table Name.

1.2 Setting up remote MariaDB for CyberPanel

We can consider this step as the initial step for setting up the remote MySQL CyberPanel.  To install and set up, we must first log in to the clean server that will host the database.

1.2.1 Adding the latest MariaDB Store

Run the following command to add the most recent version of the MariaDB repo to the Linux system:

sh <(curl https://downloads.mariadb.com/MariaDB/mariadb_repo_setup || wget -O - https://downloads.mariadb.com/MariaDB/mariadb_repo_setup)

1.2.2 Installing the latest MariaDB

Use the following command for Ubuntu 18/20:

apt install mariadb-server mariadb-client

And for version 7 of Centos we have to type in the following command line for remote MySQL CyberPanel:

yum install mariadb-server mariadb-client

Similarly, for version Centos 8, we have to type in:

dnf install mariadb-server mariadb-client

1.2.3 Installation security and remote root login access

After the install, please use the following command to enable MariaDB so that it begins upon bootup:

systemctl enable mariadb

Following that, we must run the following command to secure the installation:

sudo mysql_secure_installation

Please set a root password, delete the anonymous user, and delete the test database, but leave remote root access enabled.

1.2.4 Binding MariaDB to the main server

As the next step in setting up the remote MySQL CyberPanel, change the line beginning with the term bind to:

 in/etc/my.cnf.

bind-address=user_main_server_IP_here

1.2.5 Allow firewall access

Add a firewall rule to enable access to port 3306 from the IP address of the main server.

1.2.6 Testing the installation

Log in to the primary server and execute the following command:

mysql -u user_name -h mysql_server_ip -p

We can enter the password we chose, and we must log into the remote MariaDB installation.

2. Setting up CyberPanel with remote SQL

Run the command to install as the next step to set up the remote MySQL CyberPanel and proceed as follows:

• In the first step, select 1 to install CyberPanel.

  You are running as root...
CyberPanel installar v2.01
1. Install CyberPanel.
2. Addons and MIscellaneous
3. Exit
POLeae enter the number [1-3]: 1
CyberPanle installer v2.01
RAM check: 270/1987 MB (13.59%)
Dick Check: 6.19GB (37%) (Minimal 10 GB free space)
1. Install Cyberpabel with OPenlitespeed.
2. Install CYberpanle wurth Litespeed Enteirprise
3. Exit
Please enter the number[1-3]
• We can install CyberPanel with either OLS or LS Enterprise.
• We can choose whether or not to install FTP, Mail, and other services.

  Install Full service fpr CyberPanel? This wil include POwerDNS, Postfix and pure-FTPD
Full installation [y/n]: Y
Full installation selected.....

Now an option will appear asking if we want to install Cyberpanel with Remote MySQL or not. Enter Y to confirm the setup. After that, we have to enter all of the details.

DO you want to setup Remot MySQL? (This will skip installation of local MySQL)
(Default= no) Remote MySQL [Y/n]: Y
Remote MySQL Selected...
Remote MySQL Hostname: 555.555.555.555
Remote MySQL Database that contains meta information regarding MYsql.(Usually mysql): mysql
Remote Mysql username: root
Remote MySQL password: Padd
Remote MySQL port: 3906

Continue the install, and CyberPanel will install with the remote MySQL. And also all of the databases for the websites. CyberPanel will install on a remote database server in less than 20 minutes.

[Need assistance with similar queries? We are here to help]

Conclusion

To sum up we have now learned how to set up the remote MySQL CyberPanel. We have gone through all of the configurations to set up the environment and secure remote access with the support of our Server management support services at Bobcares.