×

This article covers the best cross-platform compatible data migration tools available in the market that not just ensure safe and secure data migration but also provide a seamless user experience. IRI NextForm tops our list due to its advanced functionalities along with a simple and easy user experience. DBConvert Studio is another great tool that offers cross-platform and cross-database compatibility and vast support for various formats and databases. 

Next in our list are the data migration tools offered by the information technology industry giants, i.e., data migration tools by AWS, IBM, and Microsoft. All the tools offer seamless data migration capability with slight features and compatibilities modifications that can change according to user preference, and so whatever platform is adopted by the user, according to their requirements, will ensure a seamless and autonomous data migration process.

Data migration is a need of every business, enterprise, and company. Sooner or later, every organization needs to tend to their database management services which always, or in most cases, involve data migrations. 



This article covers how to Install phpMyAdmin with Nginx on Ubuntu 18.04 system. When developing a website or web application, many users need the functionality of a database system like MySQL. However, interacting with the system solely from the MySQL command-line client requires familiarity with Structured Query Language — more commonly referred to as SQL — which can present a major hurdle for some users. phpMyAdmin was created to allow users to interact with MySQL through an intuitive web interface, running alongside a PHP development environment. 


How to Secure phpMyAdmin with Let's Encrypt SSL ?

Before starting, you will need to install the Certbot client to download and install Let's Encrypt SSL.

1. First, add the Certbot repository with the following command:

$ add-apt-repository ppa:ahasenack/certbot-tlssni01-1875471

2. Next, update the repository and install the Certbot client using the following command:

$ apt-get update -y
$ apt-get install certbot python3-certbot-nginx -y

3. Once the Certbot has been installed, run the following command to download and install the Let's Encrypt SSL for your domain:

$ certbot --nginx -d phpmyadmin.domain.com



This article covers how to install LAMP stack on CentOS 7. LAMP is a stack of applications that work together on a web server to host a website. With that being said, each individual program serves a different purpose.

In LAMP: 

  • Linux serves as the server's operating system that handles all the commands on the machine.
  • Apache is a web server software that manages HTTP requests to deliver your website's content.
  • MySQL is a relational database management system (RDBMS) whose function is to maintain user's data on a server.
  • PHP is a scripting language for server-side communication.


To install Apache easily using CentOS's package manager, yum:

1. Run the command.

$ sudo yum install httpd

2. Once it installs, you can start Apache on your server.

$ sudo systemctl start httpd.service

3. You can do a spot check right away to verify that everything went as planned by visiting your server's public IP address in your web browser.

http://your_server_IP_address/


Important PHP Modules:

  • php-bcmath.x86_64 : A module for PHP applications for using the bcmath library.
  • php-cli.x86_64 : Command-line interface for PHP.
  • php-common.x86_64 : Common files for PHP.
  • php-dba.x86_64 : A database abstraction layer module for PHP applications.
  • php-devel.x86_64 : Files needed for building PHP extensions.
  • php-embedded.x86_64 : PHP library for embedding in applications.
  • php-enchant.x86_64 : Enchant spelling extension for PHP applications.
  • php-fpm.x86_64 : PHP FastCGI Process Manager.
  • php-gd.x86_64 : A module for PHP applications for using the gd graphics library.



This article covers how to install mysql 8.0 and Secure MySQL on Debian 9 server. MySQL, the world's most popular open-source relational database management system is not available in the default Debian's repositories. MariaDB is the default database system in Debian 10. 

The MySQL APT repository provides a simple and convenient way to install and update MySQL products with the latest software packages using Apt. The MySQL APT repository provides MySQL packages for the following Linux distros: Debian.


How to Uninstall MySQL from Debian?

To remove MySQL, Run the following commands:

$ sudo apt-get remove --purge mysql-server mysql-client mysql-common -y
$ sudo apt-get autoremove -y
$ sudo apt-get autoclean
rm -rf /etc/mysql
sudo find / -iname 'mysql*' -exec rm -rf {} \;


How to secure MySQL ?

MySQL comes with a command we can use to perform a few security-related updates on our new install. Let's run it now:

$ mysql_secure_installation

This will ask you for the MySQL root password that you set during installation. Type it in and press ENTER. Then answer a series of yes or no prompts. 



This article covers how to install and Secure MariaDB on a CentOS 7 server. MariaDB is a fork of MySQL managed by the original MySQL developers. It's designed as a replacement for MySQL, uses some commands that reference mysql, and is the default package on CentOS 7.


To Install MariaDB 5.5 on CentOS 7:

1. Install the MariaDB package using the yum package manager: 

$ sudo yum install mariadb-server

2. Once the installation is complete, start the MariaDB service and enable it to start on boot using the following commands: 

$ sudo systemctl start mariadb 
$ sudo systemctl enable mariadb


To install MariaDB on CentOS 8:

1. Open the terminal application. Another option is to log in using the ssh command:

 ssh user@centos-8-server-ip

2. Install the MariaDB on CentOS 8 by running the command:

$ sudo yum install mariadb-server

3. Secure the MariaDB server in CentOS 8 by running the command:

$ sudo mysql_secure_installation

4. Finally test MariaDB installation by running the command:

$ mysql -u root -p


MariaDB vs MySQL:

Even though MariaDB is a fork of MySQL, these two database management systems are still quite different: 

MariaDB is fully GPL licensed while MySQL takes a dual-license approach.

MariaDB supports a lot of different storage engines. 

In many scenarios, MariaDB offers improved performance.



This article covers the PHP installation on Ubuntu 20.04 system.  Basically, popular Content Management platforms such as WordPress, Drupal, and Magento are based on PHP.


To Install PHP on Ubuntu 20.04:

1. Update your server.

$ apt-get update && apt-get upgrade

2. Install PHP on Ubuntu 20.04, just run the following command.

$ apt-get install php

3. To verify if PHP is installed, run the following command.

php -v


To Install PHP 7.4 modules (extensions):

Run the command below.

apt-get install php-pear php-fpm php-dev php-zip php-curl php-xmlrpc php-gd php-mysql php-mbstring php-xml libapache2-mod-php

To check all the PHP modules available in Ubuntu, run:

$ apt-cache search --names-only ^php


How to install PHP 8.0 on Ubuntu 20.04 or 18.04 ?

1. First, update your Ubuntu server:

$ apt-get update && apt-get upgrade

2. Add the PHP repository (by Ondřej Surý):

$ apt-get install software-properties-common
$ add-apt-repository ppa:ondrej/php

3. And finally, update your package list:

$ apt-get update

4. Install PHP 8.0 with the following command:

$ apt-get install php8.0

5. To check if PHP 8.0 is installed on your server, run the following command:

$ php -v

6. Install PHP 8.0 modules (extensions)

You may need additional packages and modules depending on your applications. The most commonly used modules can be installed with the following command:

$ apt-get install libapache2-mod-php8.0 php8.0-fpm libapache2-mod-fcgid php8.0-curl php8.0-dev php8.0-gd php8.0-mbstring php8.0-zip php8.0-mysql php8.0-xml


How to change the PHP version you're using ?

If you have multiple PHP versions installed on your Ubuntu server, you can change what version is the default one.

1. To set PHP 7.4 as the default, run:

$ update-alternatives --set php /usr/bin/php7.4

2. To set PHP 8.0 as the default, run:

$ update-alternatives --set php /usr/bin/php8.0

3. You can verify what version of PHP you’re using with the following command:

$ php -v



This article covers how to install LEMP stack on CentOS 7. LEMP stands for the Linux operating system, with the ENginx web server (which replaces the Apache component of a LAMP stack). The site data is stored in a MySQL-based database, and dynamic content is processed by PHP.

A LEMP software stack is basically a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps.


To install Nginx on CentOS:

1. Add the CentOS 7 EPEL repository, run the following command:

$ sudo yum install epel-release

2. Now that the EPEL repository is installed on your server, install Nginx using the following yum command:

$ sudo yum install nginx

3. Once the installation is finished, start the Nginx service with:

$ sudo systemctl start nginx



This article covers how to install phpMyAdmin with Nginx on CentOS 7 system. phpMyAdmin helps to handle the database administration of MySQL, MariaDB and Drizzle servers over the web. It basically provides the intuitive web interface and supports most of the MySQL features to create and drop databases, create/drop/alter tables, delete/edit/add columns, execute any SQL statement and to manage indexes on columns.


To install phpMyAdmin, run the following commands:

# yum install epel-release
# yum install phpmyadmin


To restart nginx, mariadb and php-fpm services, run the following commands:

# systemctl restart mariadb.service
# systemctl restart nginx.service
# systemctl restart php-fpm.service



This article covers how to Install phpMyAdmin with Apache on CentOS 7 system. phpMyAdmin is a database utility used for managing MySQL databases through a graphical web-based interface. It can be configured to manage a local database (on the same system), or a remote database (over a network).


To Install EPEL Repository:

1. Get access to the EPEL repository – the Extra Packages for Enterprise Linux, by running the command.

$ sudo yum install -y epel-release

2. Once that operation finishes, it's a good idea to refresh and update the EPEL repository.

$ sudo yum –y update


To Install Apache Web Server:

1. Install Apache on CentOS use the command.

$ yum install httpd -y

2. Verify the status of Apache by running with the command.

$ systemctl status httpd


To install PHPMyAdmin on CentOS, enter the command:

$ sudo yum -y install phpmyadmin



This article covers how to install phpMyAdmin with Apache on Ubuntu 18.04 system. While many users need the functionality of a database management system like MySQL, they may not feel comfortable interacting with the system solely from the MySQL prompt. phpMyAdmin was created so that users can interact with MySQL through a web interface. 


Important php packages includes:

  • php-mbstring: A module for managing non-ASCII strings and convert strings to different encodings.
  • php-zip: This extension supports uploading .zip files to phpMyAdmin.
  • php-gd: Enables support for the GD Graphics Library.
  • php-json: Provides PHP with support for JSON serialization.
  • php-curl: Allows PHP to interact with different kinds of servers using different protocols.



This article covers step by step process to Install and Configure phpMyAdmin with Apache on Debian 9 system. The phpMyAdmin utility is a graphical database management tool. By installing phpMyAdmin, you no longer need to use a default command-line interface to manage your databases.


To install wget:

1. Access your terminal window, and update your software package lists using the following command:

$ sudo apt update

2. The wget utility allows you to download files directly from the terminal window. Enter the following command to install the wget tool:

$ sudo apt install wget -y


To install Apache on Debian:

1. Open a terminal window, and install Apache by entering the following command:

$ sudo apt install apache2 -y

2. Enter the following command to make sure the Apache service is running:

$ systemctl status apache2

In the output, you should see a green status that says active (running).


To Install PHP on Debian 10:

1. Install core PHP packages and Apache and MySQL plugins with the following command:

$ sudo apt install php php-cgi php-mysqli php-pear php-mbstring php-gettext libapache2-mod-php php-common php-phpseclib php-mysql -y

2. Once the installation process is complete, verify that PHP has been installed:

$ php --version

The system displays the current version of PHP, along with the date of the release.



This article covers how to install MariaDB on Ubuntu 18.04 server. Also, you will learn how to secure and connect to MariaDB server. MariaDB is an open-source relational database management system, commonly used as an alternative for MySQL as the database portion of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. Basically, It is intended to be a drop-in replacement for MySQL.


How to Install MariaDB ?

1. To install it, update the package index on your server with apt:

$ sudo apt update

2, Then install the package:

$ sudo apt install mariadb-server



This article covers how to install and secure a MySQL server on a CentOS 7 server. MySQL is one of the most widely used database management systems for websites and server applications.


To start the MySQL server daemon with the following command:

$ sudo systemctl start mysqld

systemctl doesn't display the outcome of all service management commands, so to be sure we succeeded, we'll use the following command:

$ sudo systemctl status mysqld

To configure MySQL, run the following command:

$ sudo mysql_secure_installation

To Current MySQL Version, run the command:

$ mysql -u root -p


Terms used in Managing MySQL User Permissions:

  • SELECT – users can read through the database using the select command.
  • CREATE – they can generate new tables.
  • DROP – allows users to remove tables.
  • DELETE – users can take out rows from tables.
  • INSERT – lets users add in rows into tables.
  • UPDATE – enable them to update the rows.
  • GRANT OPTION – they can grant or remove the privileges of other users.



This article covers how to install MariaDB version on a Debian 10 server, and verify that it is running and has a safe initial configuration.


How To Install MariaDB on Debian 10 ?

1. To install MariaDB, update the package index on your server with apt:

$ sudo apt update

2. Then install the package:

$ sudo apt install mariadb-server

3. To Configure MariaDB, Run the security script:

$ sudo mysql_secure_installation



This article covers steps to install a LEMP stack on a Debian 10 server using MariaDB as the database management system. The LEMP software stack is a group of software that can be used to serve dynamic web pages and web applications. The name "LEMP" is an acronym that describes a Linux operating system, with an (E)Nginx web server. The backend data is stored in a MariaDB database and the dynamic processing is handled by PHP.

Although this software stack typically includes MySQL as the database management system, some Linux distributions — including Debian — use MariaDB as a drop-in replacement for MySQL.


To install Nginx Web Server.

1. Run the apt commands:

$ sudo apt update
$ sudo apt install nginx

On Debian 10, Nginx is configured to start running upon installation.



This article covers how to install LAMP on Debian server along with PHPMyAdmin to manage your database. LAMP stands for Linux OS, with Apache web server, Data store in a MySql or MariaDB database, and dynamic content is processed by PHP.


To install Apache on Debian:

1. Run the following command:

$ apt-get install apache2

2. To restart your web server by typing the following command:

$ service apache2 restart



This article covers how to Install a LEMP Stack on Ubuntu 20.04 LTS. LEMP stack is a group of open-source software that is typically installed together to enable a server to host dynamic websites and web apps. LEMP stands for Linux OS, with the Nginx (pronounced like "Engine-X") web server, Data store in a MySQL database, and dynamic content is processed by PHP.


To install Nginx Web Server:

1.  Run the commands below to install Nginx.

$ sudo apt update
$ sudo apt install nginx

2. Allow traffic on port 80.

$ sudo ufw allow 'Nginx HTTP'

You can verify the change by running:

$ sudo ufw status



This article covers step by step process to install a LAMP stack on an Ubuntu 18.04 server. LAMP stack is a group of open-source software that is typically installed together to host dynamic websites. LAMP stands for Linux OS, with Apache web server, Data store in a MySQL database, and dynamic content is processed by PHP.


To Install Apache and Update the Firewall.

1. Install Apache using Ubuntu’s package manager, apt:

$ sudo apt update
$ sudo apt install apache2

2. Allow incoming HTTP and HTTPS traffic for this profile:

$ sudo ufw allow in "Apache Full"



This article covers how to install MySQL version 8.0 on an Ubuntu 20.04 server. By completing it, you will have a working relational database that you can use to build your next website or application.

MySQL is an open-source database management system, commonly installed as part of the popular LAMP (Linux, Apache, MySQL, PHP/Python/Perl) stack. It implements the relational model and uses Structured Query Language (better known as SQL) to manage its data.


To install MySQL using the APT package repository:

1. Update the package index on your server if you've not done so recently:

$ sudo apt update

2. Then install the mysql-server package:

$ sudo apt install mysql-server

This will install MySQL, but will not prompt you to set a password or make any other configuration changes. 

Because this leaves your installation of MySQL insecure, we will address this next.



This article covers steps To Install Linux, Apache, MySQL, PHP (LAMP) stack on Ubuntu Linux System. PHP stands for Hypertext Preprocessor, and it’s a script-based server-side programming language. PHP is often used to automate server tasks. It handles tasks like dynamic content, database requests, and processing and displaying data.

A "LAMP" stack is a group of open source software that is typically installed together to enable a server to host dynamic websites and web apps. 

This term is actually an acronym which represents the Linux operating system, with the Apache web server. 

The site data is stored in a MySQL database, and dynamic content is processed by PHP.


To Install PHP 7.2 with Apache on Ubuntu:

1. Ensure you are using the latest Ubuntu updates by entering the following command into a terminal window:

$ apt-get update && apt-get upgrade

2. To install PHP 7.2, enter the following command:

$ sudo apt-get install php libapache2-mod-php

Confirm the installation by hitting Enter. The system will download and install PHP from the software repositories. This command also installs dependencies and modules for use with Apache.

3. Verify PHP was installed, with the command:

$ php -v



This article covers how to install the Zabbix Agent on a Ubuntu 20.04 system very conveniently.
You can ensure the successful installation of the Zabbix Agent by checking its Active status on your system. However, you can also uninstall it anytime you want.
Zabbix agent is installed on the remote host (target) to monitor the hard drive, memory processor, etc. The agent collects data and sends back to Zabbix Server.
Zabbix agents can use passive or active checks to pass information.
In passive check, Zabbix server (poller) requests an agent for certain information, and the agent sends back a value.
In the active check, the agent process all data and pushes it to the Zabbix server.
However, agent periodically connects the server to collect metric which needs to be monitored.


To Configure Zabbix agent:
Make necessary changes on the Zabbix Agent configuration file "/etc/zabbix/zabbix_agentd.conf".
After making changes, Save the changes and exit the file.
Then restart Zabbix agent service to the changes to be effected.

$ sudo systemctl restart zabbix-agent


To Configure the firewall on Zabbix agent:
1. If you have UFW firewall enables, execute the commands:

$ sudo ufw allow 10050/tcp

2. Then reload the firewall

$ sudo ufw reload

3. And verify that the port has been opened or allowed on the firewall.

$ sudo ufw status



This article covers how to reset or change your MySQL root password on Red Hat Enterprise Linux 8.

MySQL is an open source relational database management system (RDBMS) with a client-server model for creating and managing databases based on a relational model.


To Reset the MySQL root password:

You must run the commands in the following steps as the root user. 

Therefore, you can either log in directly as the root user (which is not recommended for security reasons), or use the su or sudo commands to run the commands as the root user.

To reset the root password for MySQL, follow these steps:

1. Log in to your account using SSH.

2. Stop the MySQL server using the appropriate command for your Linux distribution:

For CentOS and Fedora, type:

$ service mysqld stop

For Debian and Ubuntu, type:

$ service mysql stop

3. Restart the MySQL server with the —skip-grant-tables option. To do this, type the following command:

$ mysqld_safe --skip-grant-tables &

4. Log into MySQL using the following command:

$ mysql

5. At the mysql> prompt, reset the password. To do this, type the following command, replacing new-password with the new root password:

UPDATE mysql.user SET Password=PASSWORD('new-password') WHERE User='root';

6. At the mysql> prompt, type the following commands:

FLUSH PRIVILEGES;
exit;

7. Stop the MySQL server using the following command.

You will be prompted to enter the new MySQL root password before the MySQL server shuts down:

$ mysqladmin -u root -p shutdown

8. Start the MySQL server normally. To do this, type the appropriate command for your Linux distribution:

For CentOS and Fedora, type:

$ service mysqld start

For Debian and Ubuntu, type:

$ service mysql start



This article covers how to Install MySQL Version 8 on Red Hat Enterprise Linux 8. Now, you should now have a fully functioning MySQL server version 8 running on your Server.


To Install MySQL 8.0 On CentOS 8 / RHEL 8:

1. Install MySQL 8.0 from MySQL Dev Community

Add the official repository of MySQL to install the MySQL community server:

$ rpm -ivh https://dev.mysql.com/get/mysql80-community-release-el8-1.noarch.rpm

Make sure the MySQL repository has been added and enabled by using the following command:

$ yum repolist all | grep mysql | grep enabled


To Manage MySQL server Service on Linux:

1. After the installation of MySQL, start MySQL server service using the following command:

$ systemctl start mysqld

2. The below command will Enable MySQL server at system startup:

$ systemctl enable mysqld

3. Verify that MySQL server is started using the following command:

$ systemctl status mysqld



This article covers how to take Backups and restore a MySQL database on Red Hat Enterprise Linux 8.


Advantage of logical backup:

The main advantage of logical backup over physical backup is portability and flexibility. 

The data can be restored on other hardware configurations, MariaDB versions or Database Management System (DBMS), which is not possible with physical backups.

Note that physical backup must be performed when the mariadb.service is not running or all tables in the database are locked to prevent changes during the backup.


The mysqldump client is a backup utility, which can can be used to dump a database or a collection of databases for the purpose of a backup or transfer to another database server. 

The output of mysqldump typically consists of SQL statements to re-create the server table structure, populate it with data, or both. 

Alternatively, mysqldump can also generate files in other formats, including CSV or other delimited text formats, and XML.


Advantages of Physical backup:

1. Output is more compact.

2. Backup is smaller in size.

3. Backup and restore are faster.

4. Backup includes log and configuration files.


You can use one of the following MariaDB backup approaches to back up data from a MariaDB database:

1. Logical backup with mysqldump

2. Physical online backup using the Mariabackup tool

3. File system backup

4. Replication as a backup solution


To Backing up an entire database with mysqldump:

Execute the command:

# mysqldump [options] db_name > backup-file.sql


Using mysqldump to back up a set of tables from one database:

To back up a subset of tables from one database, add a list of the chosen tables at the end of the mysqldump command:

# mysqldump [options] db_name [tbl_name …​]



To restore the data while keeping the original backup files, use the following procedure:

1. Run the mariabackup command with the --copy-back option:

$ mariabackup --copy-back --target-dir=/var/mariadb/backup/

2. Fix the file permissions.

When restoring a database, Mariabackup preserves the file and directory privileges of the backup. However, Mariabackup writes the files to disk as the user and group restoring the database. 

For example, to recursively change ownership of the files to the mysql user and group:

# chown -R mysql:mysql /var/lib/mysql/

3. Start the mariadb service:

# systemctl start mariadb.service



This article covers how to resolve the above maiadb problem "Job for mariadb.service failed because the control process exited with error code" which may arise during the installation of #MariaDB on #CentOS 8.

The /var/lib/mysql directory is not empty when MariaDB is installed, it contains e.g. the 'mysql' database and some other files. 

Recreating the folder, even with correct permissions, will not help you. 

Either MariaDB has not been successfully installed or the directory was removed. Reinstall MariaDB to get a working basic database system back.

Also, you can give access /var/log/mysql/* to mysql by running the command:

sudo chown mysql:mysql /var/log/mysql/*


MariaDB offers more and better storage engines, NoSQL support, provided by Cassandra, allows you to run SQL and NoSQL in a single database system. 

MariaDB also supports TokuDB, which can handle big data for large organizations and corporate users.


To view mysql error logs:

1. edit /etc/my.cnf [mysqld] log=/tmp/mysql.log.

2. restart the computer or the mysqld service service mysqld restart.

3. open phpmyadmin/any application that uses mysql/mysql console and run a query.

4. cat /tmp/mysql.log ( you should see the query )



This article will guide you on how to install MariaDB on your CentOS 8 system. Now you can create new databases and grant privileges to other database users. Also, you can add users and create new databases for web or desktop applications which will be written in PHP, Python, and so on.

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.


To uninstall MariaDB and install mysql:

1. Purge mariadb sudo apt purge mariadb-* Remove all databases ('Yes' answer)

2. Purge mysql sudo apt purge mysql-*

3. Remove folders: sudo rm -r /usr/share/mysql/ sudo rm -r /etc/mysql/ sudo rm -r /lib/systemd/system/mysql.service.

4. Now you can try to install oracle mysql: sudo apt install mysql-server.



This article will guide you on the different methods to conveniently install and start the MariaDB service on a Debian 10 system. Also, we dealt with how to easily remove MariaDB from your Debian 10 system. 

In MariaDB replication is faster whereas in MySQL replication is slower. 

MariaDB is Open Source whereas MySQL uses some proprietary code in its Enterprise Edition. 

MariaDB doesn't support Data Masking and Dynamic column while MySQL supports it. Comparatively MariaDB is faster than MySQL.

Since MariaDB is a fork of MySQL, the database structure and indexes of MariaDB are the same as #MySQL. 

This allows you to switch from MySQL to MariaDB without having to alter your applications since the data and data structures will not need to change. Data and table definition files are compatible.


To install #MariaDB on #Debian , follow these steps:

1. First update the apt packages index by typing: sudo apt update.

2. Once the packages list is updated, install MariaDB by running the following command: sudo apt install mariadb-server.

3. The MariaDB service will start automatically.



This article will guide you on how to #install #MySQL server on Debian 10 #Linux system. Also we looked into how to secure the installation and connect with the MySQL shell. Using the Validate password #plugin you can make a more secure database MySQL password #authentication.

MySQL is an #RDBMS tostore, retrieve, modify and administrate a database usingSQL.

The mysql #command:

1. -h followed by the server host name (server.linuxapt.com).

2. -u followed by the account user name (use your MySQL username).

3. -p which tells mysql to prompt for a password.

4. database the name of the database (use your database name).



This article will guide you on methods to install MongoDB on #Linux #Mint 20 system. You can check #MongoDB status, and can also access its shell to pass #commands to this database.

MongoDB installs as a #systemd service, which means that you can manage it using standard systemd commands alongside all other sytem services in Ubuntu. To verify the status of the service, type: sudo systemctl status mongodb.

Companies and development teams of all sizes use MongoDB because: The document data model is a powerful way to store and retrieve data that allows developers to move fast. MongoDB's horizontal, scale-out architecture can support huge volumes of both data and traffic.

To start MongoDB in Debian:

1. Start MongoDB. Issue the following command to start mongod: sudo service mongod start.

2. Stop MongoDB. As needed, you can stop the mongod process by issuing the following command: sudo service mongod stop.

3. Restart MongoDB. Issue the following command to restart mongod: sudo service mongod restart.



This article will guide you on how to install and configure #MySQL server on the #Linux system Ubuntu 20.04 in this article. Also, we have explored different basic commands to run MySQL server. MySQL is a relational #database that uses SQL to query a database. It facilitates data storing, modifying, and management in a tabular format. To install the latest version of MySQL in #ubuntu: 1. Enable MySQL #Repositories. 2. Install MySQL Repositories. 3. Refresh the Repositories. 4. Install MySQL. 5. Set up MySQL Security. 6. Start, Stop, or Check Status of MySQL Service. 7. Launch MySQL to Enter #Commands.



This tutorial will guide you on how to get Nginx server installed and configured on an Ubuntu Linux 18.04 LTS server.

Nginx is one of the most popular web servers in the world and is responsible for hosting some of the largest and highest-traffic sites on the internet. It is more resource-friendly than Apache in most cases and can be used as a web server or reverse proxy.


Nginx Configuration Files Structure

  • All configuration files are located in the /etc/nginx/ directory.
  • Nginx main configuration file is at /etc/nginx/nginx.conf.
  • It's best practice to create a separate configuration file of each domain for better maintainability.
  • New server blocks (configuration file) of each domain should be stored in /etc/nginx/sites-availabledirectory. You need to make symlink of these configuration files at /etc/nginx/sites-enabled to take in used by Nginx.
  • Activating server blocks is done by creating a symlink (a pointer) from the configuration file sites in a /etc/nginx/sites-enabled directory to the sites-enabled directory.
  • The default server web root directory is /var/www/html
  • It's best practice to to follow standard naming convention. Nginx server block files name should as domain name and must end with .conf extension. For example, your domain name is example.com then server block file name should example.com.conf
  • Nginx log files (access.log and error.log) are located in the /var/log/nginx/ directory. It's also recommended to have a different access and error log files for each server block.




More Linux Tutorials

We create Linux HowTos and Tutorials for Sys Admins. Visit us on IbmiMedia.com

Also for Tech related tips, Visit forum.outsourcepath.com or General Technical tips on www.outsourcepath.com