the password plugin name is validate_password but some versions of MySQL have  “validate.password”

OR

UPDATE user SET password=PASSWORD(‘your_password’) WHERE user=’root’;

mv mysql-5.1.73-linux-x86_64-glibc23  /home1/replication/Mysql-204

./bin/mysql_install_db –datadir=/home1/replication/Mysql-204/ –datadir=/home1/replication/Mysql-204/data/ –user=mysql

mysql -uroot -p –socket=/home1/replication/Mysql-204/data/mysql.sock –port=3308

or

cat /root/.mysql_secret

=>  Product Version:”5.1.23″
=>  Operating System:’Linux – Generic’
=> download Linux – Generic (glibc 2.3) (x86, 64-bit), Compressed TAR Archive
=> Download it using “wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.1.23-linux-x86_64-glibc23.tar.gz”

mkdir /home1/replication/

mv mysql-5.1.73-linux-x86_64-glibc23   /home1/replication/Mysql-187

#cp /etc/ansible/ansible.cfg /home/anil/ansible

#vi /home/anil/.bashrc
And add
export ANSIBLE_CONFIG=/home/anil/ansible/ansible.cfg

#vi /home/anil/ansible/ansible.cfg
And add
inventory      = =/home/anil/ansible/anil-hosts

vi /etc/ansible/hosts this file used for managing clients and groups.

Example of /etc/ansible/hosts 

#Making a comment in my hosts’ file

rainbows.nitwinngs.com

[testServer]
52.36.167.137 ansible_user=ec2-user ansible_ssh_user=ec2-user
test1.nitwinngs.com:2222

[testServer:vars] ansible_user=ec2-user

[webServers]
apache[01:50].nitwinngs.com
nginx[50:100].nitwinngs.com
Postfix.us[1:50].nitwinngs.com

[appServers]
app[a:f].nitwinngs.com

-a is an argument
-k for asking password

Or

Ansible all -m file -a ‘path=/etc/httpd/ssl/wings.key state=touch”

Or

Ansible all -m file -a ‘path=/etc/httpd/ssl/wings.key mode=777”

Or

Ansible all -m file -a ‘path=/etc/httpd/ssl/wings.key state=absent”

Or

Create file.

Or

Change file or folder permission.

Or

Delete the file or Folder.

or

Ansible group-name -ba “yum install httpd -y”

or

Ansible group-name -b -m module-name  -a “pkg=httpd status=present”

eg:-

Ansible mail -b -m yum  -a “pkg=postfix status=present”

-b = –become  sudo  and -a is an argument

(-a for argument and -m for the module)

when you use -m (module) syntax always into YAML language.

-m Yum -a “pkg=postfix status=present”
-m service -a “name=postfix status=started”
-m user -a “name=raj”
-m copy -a “src=main.cf  dest=/etc/postfix”

Ansible mail -m setup

 -a “filter=*ipv4*”

Eg:-

Ansible-playbook info.yml

hosts: demo
user: ansible
become: yes
connection: ssh

tasks:

–  name: install httpd server on centos
action: yum name=httpd state-installed
notify: restart httpd

handlers:
– name: restart httpd
action: service name=httpd         state=restarted

– hosts: demo
user: ansible
become: yes
connection: ssh

 tasks:
– name: add list of users in my nodes
user: name='{{userslist} }’ state-present
with_userslist:
– Anil
– jalela
– Nilax
– Arti

OR Install packages

—

– name: install and configure packages
hosts: “{{myHost}}”
remote_user: ec2-user
become: yes

vars_files:
– Maria_vars.yml

tasks:
– name: install packages
yum: name={{item}} state=installed
with_item
– bind-utils
– netcat
– fping
– nmap
– httpd

OR Loop like

—

– name: testing loops
hosts: testServer
remote_user: ec2-user
become: yes

tasks:
– name: looping over environment facts
debug
msg={{item.key}}={{item.value}}
with_dict: ansible_env

 – name: looping over files and then copy copy: src={{item}} dest=/tmp/loops with_fileglob: “/tmp/*.conf”

 – name: do until something
shell: echo hello
register: output
retries: 5
delay: 5
until: output.stdout.find(‘hello’) != -1

-hosts: demo
user: ansible
become: yes
connection: ssh

tasks:
–          name: Install apache server for debian family
command: apt-get -y install apache2
when: ansible_os_family == “Debian”
–          name: install apache server for redhat family
command: yum -y install httpd
when: ansible_os_family =”Redhat”

Ansible-playbook -i hosts Mariadb.yml

– name: install and configure mariadb
hosts: testServer
remote_user: ec2-user
become: yes

vars:
mysql_port: 3306

tasks:
– name: install mariadb
yum: name=mariadb-server state=latest

– name: create mysql configuration file
template: src=my.cnf.j2 dest=/etc/my.cnf
notify: restart mariadb

– name: create mariadb log file
file: path=/var/log/mysqld.log state=touch owner=mysql group=mysql mode=0775

– name: start mariadb service
service: name=mariadb state=started enabled=yes

handlers:
– name: restart mariadb
service: name=mariadb state-restarted
my.cnf.j2 template file look  like :-

#cat my.cnf.j2

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
port={{ mysql_port }}
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mariadb/mysqld.pid 

With log path and port variable

– name: start mariadb service
service: name=mariadb state=started enabled=yes

handlers:
– name: restart mariadb
service: name=mariadb state-restarted

With Maria_vars.yml

And define hostname in run time

Ansible-playbook -i hosts Mariadb.yml

–extra-vars “hosts= testServer”

– name: install and configure mariadb
hosts: “{{myHost}}”
remote_user: ec2-user
become: yes

vars_files:
– Maria_vars.yml

tasks:
– name: install mariadb
yum: name=mariadb-server state=latest

– name: create mysql configuration file
template: src=my.cnf.j2 dest=/etc/my.cnf
notify: restart mariadb

– name: create mariadb log file
file: path=/var/log/mysqld.log state=touch  owner=mysql group=mysql mode=0775

– name: start mariadb service
service: name=mariadb state=started enabled=yes

handlers:
– name: restart mariadb
service: name=mariadb state-restarted

Maria_vars.yml vars file look  like :-
#cat Maria_vars.yml

—
mysql_port: 3306
log_path: /var/log/

Ansible-playbook -i hosts Var_cases.yml

Ansible-playbook -i hosts Conditionals.yml

# – fail: msg=”unicorns require rainbow variable to be set”
#when: rainbow is undefined

– name: test to see if selinux is running
shell: getenforce
register: sestatus

– name: configure SELinux if not enforcing
seboolean: name=mysql_connect_any state=true persistent=yes when: sestatus.rc != 0

– name: checking systems
shell: cat /var/log/messages
register: log_output

– name: next task
shell: echo “systemd knows when we’re doing ansible stuff”
when: log_output.stdout.find(‘ansible’) != 0
register: shell_echo
– debug: var=shell_echo

Executes annual goals and priorities as established with input from the next-level manager.

Delivery/Production Focus: Position has a direct impact on the productivity of the work unit.

Oversees the work of a team of at least three or more non-exempt employees within a single work unit.

Ensures that subordinates perform work as prescribed by policies and procedures in order to achieve productivity, service, and quality standards, quotas, and goals.

Assigns work and resources to subordinates to achieve productivity, service, and quality standards within the parameters of the operating plan and budget.

Administers and executes policies & procedures typically affecting subordinates.

Has limited authority to make exceptions to policy and procedure—decisions are subject to frequent in process review.

Responsible for input on pay, performance appraisals, work schedules, day-to-day personnel issues, discipline and hiring employees they supervise.

Resolves operational problems within provided guidelines.

Requires a high school diploma; may require associate/bachelor’s degree or specialized training.

Establishes annual goals and priorities, and influences the direction for new or revised services, programs, processes, standards, or operational plans, based upon the Organization’s longer-term strategies.

Operational/Delivery Focus: The position has a direct impact on the work unit or department and may impact the entire Organization.

Manages three or more exempt individuals within a work unit or department. Typically oversees the work of a team or teams of non-exempt employees through subordinate-level M1s.

In addition, may be responsible for coordinating and monitoring the work of external vendors, contractors, etc.

Estimates staffing needs and schedules and assigns projects/work for the department. Is ultimately responsible for the success of all departmental projects.

Has authority to make exceptions to policy or procedures under guidelines that require judgment and discretion on issues of importance.

May have some responsibilities for managing financial or external risks that require occasional interaction with senior management.

Responsible for making decisions on pay, performance, discipline, and hiring for the employees they manage.

Identifies issues, gathers facts, and resolves operational problems. Recommends and collaborates with a next-level manager to resolve strategic issues.

Typically requires a bachelor’s degree in a related discipline.

Establishes annual or mid-term priorities, goals, and operational plans for the department or work units. Leads definition and direction for new or revised services, programs, processes, policies, standards, or operational plans, based on the Organization’s longer-term strategies. Recommends departmental strategic plans within Organization’s strategic direction to the next-level manager.

Tactical/Strategic Focus: The position has a significant impact on the specific work units or departments and impacts the entire Organization.

Oversees the work of a team or teams of exempt individual contributors through subordinate-level M2s. In addition, may be responsible for managing the work of external vendors, contractors, etc.

Often recommends innovation and improvement to policy or procedures under guidelines that require judgment and discretion on issues of the significant dollar or stakeholder relationship impact.

Decisions affect mid to long-term operational results delivered, and typically affect the financial, employee or public relations aspects of the Organization.

Has responsibility for managing significant financial or external risks that require frequent interaction with executive leadership.

Responsible for all human resource management, integrating work throughout the area, and developing and monitoring budgets for the department or several work units.

Problems are both operational and strategic and may require the integration of knowledge from several disciplines or areas of expertise.

Typically requires a bachelor’s degree in a related discipline and may require an advanced degree.

OR

2) Has responsibility for a material portion of Organization assets or processes – operations, financial, human capital – as determined by the President, Provost, Executive Vice President committee.

Typically not more than one or two M4s per function. (Provost departments must take into account faculty administrative positions that are equivalent to this level).

Tactical/Strategic Focus: The position has a significant direct impact on a large function and a direct impact on the entire Organization. Actions can measurably increase or decrease Organization-wide operating results.

Manages teams of professionals  (multiple M2’s and M3s).

Makes regular presentations to the Organization’s Trustees.

Advises senior leadership outside his or her own function on Organization issues with high, quantifiable impact on the success of the Organization as a whole Is and is perceived to be, an authoritative representative of the Organization on a variety of issues.

Expected to recommend innovation and improvement to policy or procedures on issues of high dollar impact for the Organization;

Has the ability to significantly modify the major or most significant policies and processes in the function.

Decisions affect long-term operational results delivered, and typically affect the financial, employee, or public relations aspects of the Organization.

Has responsibility for managing significant financial or external risks that require frequent interaction with executive leadership and/or Organization Trustees.

Makes hiring and firing decisions for the departments or functions. Makes strategic vendor selections and purchasing decisions for the departments or functions.

Problems are resolved through abstract and conceptual analysis and require innovative thinking and problem-solving that impacts two of the three dimensions of management at the Organization level —operations, financial and human capital.

Typically requires a bachelor’s degree in a related discipline and may require an advanced degree.

Has authority/accountability to define the long-term strategy for the function.

Shares direct accountability to develop and implement the three-to-five-year strategies for the Organization as a whole, and for major initiatives that shape the long-term future of the Organization.

Typically, does not perform individual contributor assignments.

Strategic Focus: Position has a predominant impact on the specific function and a significant impact on the entire Organization. Actions can measurably increase or decrease Organization-wide operating results.

Oversees the work of multiple teams of professionals typically through subordinate M3s and M4s Appointed at the discretion of the President of the Organization.

Performance is assessed primarily on long-term strategic results achieved; rather than on individual decisions or short–term operational results.

Decisions significantly affect the success of function goals, greatly impacting the financial stability, employee relations, and public relations of the Organization.

Makes hiring and firing decisions for the function. Plans for succession and overall talent management for the function. Makes vendor selections and purchasing decisions for the function.

Problems are resolved through abstract and conceptual analysis.

Requires an advanced degree in the relevant course of study.