# MYSQL failing on couple of servers

**URL:** <https://forum.ansible.com/t/mysql-failing-on-couple-of-servers/35764>\
**Category:** Ansible Project\
**Created:** [September 21, 2021, 3:01pm UTC](https://forum.ansible.com/t/mysql-failing-on-couple-of-servers/35764 "2021-09-21T15:01:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Raj](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Raj](https://forum.ansible.com/u/Raj)\
**Post date:** [September 21, 2021, 3:01pm UTC](https://forum.ansible.com/t/mysql-failing-on-couple-of-servers/35764/1 "2021-09-21T15:01:45Z")

</div>

Hi All,

My playbook is running good on 90 servers getting all information mysql.

Issue is failing on 10 servers below is the error.

Note: Our ansible id doesn’t have root access.

The PyMySQL (Python 2.7 and Python 3.X) or MySQL-python (Python 2.X) module is required

Thanks  
Raja

---

<div class="post-metadata">

**Author:** ![Pushparaj\_Gothandam](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/pushparaj_gothandam/32/5538_2.png) [@Pushparaj\_Gothandam](https://forum.ansible.com/u/Pushparaj_Gothandam)\
**Post date:** [September 21, 2021, 3:10pm UTC](https://forum.ansible.com/t/mysql-failing-on-couple-of-servers/35764/2 "2021-09-21T15:10:38Z")

</div>

This shows you need to install pymysql python package on your remote host.

---

<div class="post-metadata">

**Author:** ![Raj](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Raj](https://forum.ansible.com/u/Raj)\
**Post date:** [September 21, 2021, 3:21pm UTC](https://forum.ansible.com/t/mysql-failing-on-couple-of-servers/35764/3 "2021-09-21T15:21:45Z")

</div>

Thanks Raj…  
Is it ok to install python verison 3. Because it have 2.7.5… i have to request unix team.

Thanks  
Raja

---

<div class="post-metadata">

**Author:** ![steve\_missoh](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@steve\_missoh](https://forum.ansible.com/u/steve_missoh)\
**Post date:** [September 21, 2021, 3:33pm UTC](https://forum.ansible.com/t/mysql-failing-on-couple-of-servers/35764/4 "2021-09-21T15:33:04Z")

</div>

If:

- you do have internet on the nodes
- you already have pip installed  
Then you can install PyMySQL in userspace with your non-root id:  
pip3 install PyMySQL - -user

---

<div class="post-metadata">

**Author:** ![Raj](https://avatars.discourse-cdn.com/v4/letter/r/c0e974/32.png) [@Raj](https://forum.ansible.com/u/Raj)\
**Post date:** [September 21, 2021, 3:56pm UTC](https://forum.ansible.com/t/mysql-failing-on-couple-of-servers/35764/5 "2021-09-21T15:56:39Z")

</div>

Hi,

Don’t have root access perform this task.

Thanks