Information, Technology & More

Environment MySQL Version: 8.0.21 OS: CentOS 7 Minimal install 64bit MySQL User MySQL user can be created using by the following command in MySQL console CREATE USER 'user1'@'localhost' IDENTIFIED BY 'password1'; If the application connects to MySQL service from a specific IP address application server IP address can be specified in create user statement. CREATE USER 'user1'@'192.168.1.1' IDENTIFIED BY 'password1'; If MySQL needs to connect from different sources using a single username and password. Wildcard(%) can be used instead of an IP address. CREATE USER 'user1'@'%' IDENTIFIED BY 'password1'; % is a wildcard - It can be used as  '%.domain.com' or '%.123.123.123'  To grant privileges to a database, the user must create a database.  Following command granting privileges to a database with name 'school' GRANT ALL ON school.* TO 'user1'@'192.168.1.1'; For localhost connect...

Enviornment CentOS 7 minimal installation Command rpm -qa -a, --all query/verify all packages -q Specify a query It lists all packages installed in system. User can filter the result by using a pipe and grep. eg Check any packages installed with name php rpm -qa | grep php

This guide explains how to setup Ruby on CentOS using Ruby version manager. Prerequisite  CentOS 8 minimal installation with latest available updates Resolve Dependencies  To begin with Ruby installation, it requires a set of packages on the system. Following steps to resolve the same.  dnf install curl     dnf install gnupg2      dnf install tar Installing Ruby Version Manager ( RVM )      RVM is a command-line tool that allows us to install, manage, and work with different ruby environments.      Install the latest stable version of RVM on your system using the following command. This command will automatically download all required files and install on your system. Install GPG keys As a first step install GPG keys used to verify installation package: Key can be found at RVM website Eg : gpg --keyserver hkp://pool.sks-keyservers.net --recv-keys 409B6B1796C275462A1703113804BB82D39DC0E3 7D2BAF1CF37B13E2069D6956105...

Once the bind package installed in a linux system to serve as DNS/ name server, the version can be identified with following command named -v output BIND 9.9.4-RedHat-9.9.4-74.el7_6.2 (Extended Support Version)