netstat

To see all connections, run

To see all listening connections, run

Ubuntu find Dependencies for a package

To find dependencies for a package, run

Example

In above example, when you install php7.2, it install “libapache2-mod-php7.2”, that will install Apache web server. I had a server with ngtinx, when i install php7.2 package, apache get installed.

You can also use

To find reverse dependency, run

Upgrade MariaDB 5.5 to 10.1 on CentOS 7 Plesk Server

CentOS 7 Plesk Server come with MariaDB 5.5

The rpm packages installed where

To upgrade MariaDB, first take a backup of all databases.

Stop MariaDB databases

Make another backup of data files

Create file

Add following content

Now run

This will upgrade your MariaDB 5.5 to MariaDB 10.1

Start MariaDB

At this point, you have newer MariaDB 10.1

You need to upgrade databases, for this, run

Restart MariaDB

update the package version inside Plesk

Remove old MySQL symlink

Open MySQL Port 3306 in CentOS 7

To allow MySQL to connect from remote server on CentOS 7 server, you need to enable port 3306 in firewall.

To do this, edit file

Find

Add above

Restart server.

yum repolist

List all Repositories

List packages from a specific repo

Following command disable all repos and enable EPEL repo.

See yum