Skip to main content

DevOps Techie

  • Home
  • DevOps
    • Ansible
    • Python
    • ELK
    • Docker
    • Jenkins
    • Maven
    • Java
    • Nagios
  • Ansible
  • Docker
  • Python
  • PHP
    • Drupal
  • Linux Commands

Tag: MySQL

How To Install Linux, Apache, MySQL, PHP (LAMP) stack On CentOS 7

February 12, 2018January 2, 2019 Avinash Pawar 4 Comments

install-linux-apache-mysql-php-lamp-stack-on-centos-7

Introduction (LAMP Stack)

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.

Read More

Creating custom dynamic inventory with Ansible using Python

January 19, 2018January 9, 2019 Avinash Pawar Leave a comment

Introduction – Dynamic Inventory

In our previous articles, we have seen how Ansible works? Ansible works against multiple systems in your infrastructure at the same time.

Read More

Create User In MySQL With ReadOnly Access

March 11, 2013March 11, 2013 DevOpsTechie 2 Comments

To create a user in mysql with readonly access, following is the useful command.

Login with root access and use following commands.

CREATE USER ‘use’@’localhost’ IDENTIFIED BY ‘password’;
GRANT SELECT ON database.* TO user@’localhost’ IDENTIFIED BY ‘password’;

Read More

How to get tables statistics / tables status in MySQL

June 21, 2011June 21, 2011 DevOpsTechie Leave a comment

MySQL tables statistics / MySQL tables status 

To get the MySQL table status and to get more information about table (size, engine, no. of rows etc.), following is the very useful command.

Read More

MySQL Engines: InnoDB vs. MyISAM

April 29, 2011April 29, 2011 DevOpsTechie 2 Comments

MySQL databases are 2 major storage engines InnoDB and MyISAM.

Following are the important differences of features and performance,
1. InnoDB is newer while MyISAM is older.

Read More

Popular Posts

  • How to get CPU utilization and Memory Usage in Python – psutil
  • Ansible: Install and Configure Ansible Tower On CentOS 7
  • How to install and create python virtualenv on CentOS
  • Creating custom dynamic inventory with Ansible using Python
  • Ansible: Manage Windows machine with Ansible by CredSSP

Latest Tweets

  • RT @avinash6784: Top 15 Docker Commands You Should Know by @Saurabhk1094 link.medium.com/GLXQEzyOH9

    February 27, 2021 1:32 pm

  • RT @CMOMaharashtra: Congratulations Team India for this historic win! https://t.co/P6M9HlHIfq

    January 19, 2021 9:11 am

  • RT @virendersehwag: Khushi ke maare pagal. This is the new India. Ghar mein ghuskar maarta hai. From what happened in Adelaide to this,… https://t.co/rlbm1vSQ74

    January 19, 2021 8:46 am

  • Rest in peace. Football will always remember you great Diego Maradona twitter.com/virendersehwag/sta…

    November 25, 2020 5:50 pm

  • RT @RRPSpeaks: अमेरिकेच्या पहिल्या महिला उपराष्ट्राध्यक्ष कमला हॅरिस यांनी आपल्या विजयाचं श्रेय आपल्या आईला दिलं. भारताची माती काय… https://t.co/JOQJyumQYU

    November 8, 2020 11:43 am

Tag Clouds

Adserver Ansible ansible-vault ansible playbook Ansible Role Ansible Windows Apache Apache Security Array Authentication Case insensitive Array centos CentOS 7 check jquery loaded or not Check Loaded JQuery CI Continuous Integration Convert URL into Link Cookies Core Modules In Drupal CSS Properties Database Delete Old Files DevOps DevOpsTechie Docker Docker CE Drupal CMS Drupal Modules Elasticsearch ELK elk stack File Httpd Jenkins Kibana Linux Logstash MySQL passwords python python virtualenv secrets virtualenv windows
  • About Us
  • RSS Feed
  • Contact Us
Copyright ©2019. DevopsTechie Theme by Colorlib Powered by WordPress