# \#mysql **URL:** https://forum.ansible.com/tag/mysql/291.md [Latest](https://forum.ansible.com/latest.md) · [Categories](https://forum.ansible.com/categories.md) · [Tags](https://forum.ansible.com/tags.md) --- ## [\[RESOLVED\] Should ansible.mysql be split into separate MySQL and MariaDB collections?](https://forum.ansible.com/t/resolved-should-ansible-mysql-be-split-into-separate-mysql-and-mariadb-collections/45866)
**Author:** [@Andersson007](https://forum.ansible.com/u/Andersson007)\ **Replies:** 22\ **Last updated:** [October 17, 2026, 4:32pm UTC](https://forum.ansible.com/t/resolved-should-ansible-mysql-be-split-into-separate-mysql-and-mariadb-collections/45866 "2026-10-17T16:32:02Z")
I’m one of long-term maintainers of ansible.mysql (recently renamed from community.mysql — same codebase, same collection). This post is to open a discussion about whether it makes sense to split the collection into two:… --- ## [Ansible.mysql replaces community.mysql](https://forum.ansible.com/t/ansible-mysql-replaces-community-mysql/45798)
**Author:** [@mariolenz](https://forum.ansible.com/u/mariolenz)\ **Replies:** 3\ **Last updated:** [May 14, 2026, 2:18pm UTC](https://forum.ansible.com/t/ansible-mysql-replaces-community-mysql/45798 "2026-05-14T14:18:30Z")
As mentioned in The Bullhorn #227, community.mysql is replaced by ansible.mysql. This means we will add ansible.mysql to the Ansible Commnity Package (already done, just not released yet) and, in the long run, remove com… --- ## [Certification of community.mysql collection on Automation Hub](https://forum.ansible.com/t/certification-of-community-mysql-collection-on-automation-hub/45709)
**Author:** [@Andersson007](https://forum.ansible.com/u/Andersson007)\ **Replies:** 10\ **Last updated:** [May 5, 2026, 1:34pm UTC](https://forum.ansible.com/t/certification-of-community-mysql-collection-on-automation-hub/45709 "2026-05-05T13:34:29Z")
Hello everyone, We are thinking of certifying community.mysql which will result in its availability on Automation Hub. What the certification will bring to the community: Some additional testing and manual checks tha… --- ## [Cannot execute SQL from mysql.mysql\_query](https://forum.ansible.com/t/cannot-execute-sql-from-mysql-mysql-query/44595)
**Author:** [@engstroem](https://forum.ansible.com/u/engstroem)\ **Replies:** 3\ **Last updated:** [October 2, 2025, 5:08pm UTC](https://forum.ansible.com/t/cannot-execute-sql-from-mysql-mysql-query/44595 "2025-10-02T17:08:45Z")
Issue with executing query-file through mysql.mysql\_query I am new within ansible and it modules, so sorry if I’m just using the wrong module. I need to run query (~7000 lines) to set up a database on my database serve… --- ## [Can't set up MySQL on Ubuntu](https://forum.ansible.com/t/cant-set-up-mysql-on-ubuntu/38881)
**Author:** [@HobsonI](https://forum.ansible.com/u/HobsonI)\ **Replies:** 5\ **Last updated:** [December 6, 2024, 11:27am UTC](https://forum.ansible.com/t/cant-set-up-mysql-on-ubuntu/38881 "2024-12-06T11:27:56Z")
Hi All, I am trying to configure a fresh MySQL installation: Server version: 8.0.40-0ubuntu0.20.04.1 (Ubuntu) The script sets up variables, and calls a role that starts with the following name: Start MySQL service s… --- ## [Insert a JSON containing double quoted Strings using SQL statment](https://forum.ansible.com/t/insert-a-json-containing-double-quoted-strings-using-sql-statment/10408)
**Author:** [@botboy](https://forum.ansible.com/u/botboy)\ **Replies:** 4\ **Last updated:** [October 29, 2024, 9:43pm UTC](https://forum.ansible.com/t/insert-a-json-containing-double-quoted-strings-using-sql-statment/10408 "2024-10-29T21:43:32Z")
I am trying to execute an Ansible play to execute a MySQL statement that inserts a JSON object where all the keys and values are Strings. However, with my current code, the resulting JSON does not have double quotes arou… --- ## [\[community.mysql.mysql\_db module\] Permission denied issues](https://forum.ansible.com/t/community-mysql-mysql-db-module-permission-denied-issues/9629)
**Author:** [@Lebowski89](https://forum.ansible.com/u/Lebowski89)\ **Replies:** 2\ **Last updated:** [October 2, 2024, 12:44pm UTC](https://forum.ansible.com/t/community-mysql-mysql-db-module-permission-denied-issues/9629 "2024-10-02T12:44:32Z")
Hello, I am building a role for Ombi (Docker container), in which I want to have the option of deploying Mariadb (also Docker container). Everything works well so far - Mariadb container is deployed and then Ombi is dep… --- ## [I want this playbook to skip systems that erro out due to missing tables](https://forum.ansible.com/t/i-want-this-playbook-to-skip-systems-that-erro-out-due-to-missing-tables/5308)
**Author:** [@RyanAccent](https://forum.ansible.com/u/RyanAccent)\ **Replies:** 2\ **Last updated:** [May 6, 2024, 6:21pm UTC](https://forum.ansible.com/t/i-want-this-playbook-to-skip-systems-that-erro-out-due-to-missing-tables/5308 "2024-05-06T18:21:21Z")
I have aplaybook that is designed to keep 12 month’s worth of SQL Table data and dump the rest. When I run the playbook against multiple systems any system that errors out is not included in subsequent tasks. Everyth… --- ## [Unable to reset mysql root password after fresh install mariadb-server](https://forum.ansible.com/t/unable-to-reset-mysql-root-password-after-fresh-install-mariadb-server/6596)
**Author:** [@abhinanth\_k](https://forum.ansible.com/u/abhinanth_k)\ **Replies:** 18\ **Last updated:** [June 18, 2024, 3:17pm UTC](https://forum.ansible.com/t/unable-to-reset-mysql-root-password-after-fresh-install-mariadb-server/6596 "2024-06-18T15:17:49Z")
Hi I am unable to reset the root password after installing the most recent version of MariaDB Server. I have added the credentials in manage node /root/.my.cnf Kindly help me to resolve this issue. --- ## [Shall community.mysql drop mysqlclient support?](https://forum.ansible.com/t/shall-community-mysql-drop-mysqlclient-support/6509)
**Author:** [@markuman](https://forum.ansible.com/u/markuman)\ **Replies:** 0\ **Last updated:** [June 14, 2024, 11:58am UTC](https://forum.ansible.com/t/shall-community-mysql-drop-mysqlclient-support/6509 "2024-06-14T11:58:54Z")
Currently there is a poll in community.mysql about dropping mysqlclient in the future, so that only PyMySQL will be supported. If someone wants to participate: deprecate mysqlclient and support only PyMySQL · ansible-co… --- ## [Geerlingguy.mysql failing with empty value](https://forum.ansible.com/t/geerlingguy-mysql-failing-with-empty-value/5553)
**Author:** [@Manju](https://forum.ansible.com/u/Manju)\ **Replies:** 6\ **Last updated:** [May 8, 2024, 7:19am UTC](https://forum.ansible.com/t/geerlingguy-mysql-failing-with-empty-value/5553 "2024-05-08T07:19:58Z")
Hi I’m trying to install latest version of mysql using geerlingguy.mysql role on an ubuntu vm(Version 22.04). Would like to install the mysql-server package instead of MariaDB package. The role fails with error below E… --- ## [MySQL Matrix notifications test topic](https://forum.ansible.com/t/mysql-matrix-notifications-test-topic/2257)
**Author:** [@Andersson007](https://forum.ansible.com/u/Andersson007)\ **Replies:** 0\ **Last updated:** [November 9, 2023, 9:42am UTC](https://forum.ansible.com/t/mysql-matrix-notifications-test-topic/2257 "2023-11-09T09:42:05Z")
Hello, testing Matrix bot integration for MySQL matrix room, please ignore.