Posts

MySQL 8 User creation and grant privileges

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...
Post a Comment
Read more

Get the list of RPM installed in CentOS

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
Post a Comment
Read more

Setup Ruby on CentOS 8

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...
Post a Comment
Read more

Ruby Gem Environment Path

By running following command helps to retrieve environment of details of Ruby Gem gem environment sample output from centos 8  RubyGems Environment:   - RUBYGEMS VERSION: 3.0.8   - RUBY VERSION: 2.6.5 (2019-10-01 patchlevel 114) [x86_64-linux]   - INSTALLATION DIRECTORY: /usr/local/rvm/gems/ruby-2.6.5   - USER INSTALLATION DIRECTORY: /root/.gem/ruby/2.6.0   - RUBY EXECUTABLE: /usr/local/rvm/rubies/ruby-2.6.5/bin/ruby   - GIT EXECUTABLE:   - EXECUTABLE DIRECTORY: /usr/local/rvm/gems/ruby-2.6.5/bin   - SPEC CACHE DIRECTORY: /root/.gem/specs   - SYSTEM CONFIGURATION DIRECTORY: /usr/local/rvm/rubies/ruby-2.6.5/etc   - RUBYGEMS PLATFORMS:     - ruby     - x86_64-linux   - GEM PATHS:      - /usr/local/rvm/gems/ruby-2.6.5      - /usr/local/rvm/rubies/ruby-2.6.5/lib/ruby/gems/2.6.0   - GEM CONFIGURATION:      - :update_sources => true      - :verbos...
Post a Comment
Read more

Laravel 5.1with PHP 5.6 and MySQL 8.0

MySQL server 8.0 enabled with new user authentication mechanism. This mechanism may not supported by Laravel 5.1.x with PHP 5.x versions. It also throws exception from Laravel library for database connection. Error example: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client The server requested authentication method unknown to the client [caching_sha2_password] To resolve errors, run the MySQL service with support of old authentication mechanism. Open mysql my.cnf (Path : 'C:\ProgramData\MySQL\MySQL Server 8.0' in windows 10 Pro) using any text editor. Update the value of  'default_authentication_plugin'  to  'mysql_native_password'. Restart MySQL service to make the updated configuration in effect.  Testing Environment Used. Windows 10 Pro MySql 8. PHP 5.6.0 Laravel 5.1
Post a Comment
Read more

Windows build in checksum / hash calculator

This explain how we can create hash / checksum of any file using windows command line.  Environment  Window 10 Pro - 64Bit certutil  option -hashfilec exmaple. certutil -hashfile <fileNamewithPath> SHA256 Official Documentation >>  https://docs.microsoft.com/en-us/windows-server/administration/windows-commands/certutil https://onthefencedevelopment.com/2017/08/15/windows-10-builtin-md5-checksum-calculator/
Post a Comment
Read more

Project Management Tools

Open Project   url  -  https://www.openproject.org/ Community edition / free edition for the self-hosted environment with limited feature compare to cloud-hosted edition. https://wekan.github.io/ Open-Source kanban
Post a Comment
Read more