# SQL migration playbooks questions

**URL:** <https://forum.ansible.com/t/sql-migration-playbooks-questions/5805>\
**Category:** Get Help\
**Tags:** playbook\
**Created:** [May 14, 2024, 2:08pm UTC](https://forum.ansible.com/t/sql-migration-playbooks-questions/5805 "2024-05-14T14:08:34Z")\
**Posts on this page:** 1\
**Showing post:** 57

<div class="post-metadata">

**Author:** ![chris](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/chris/32/293_2.png) [@chris](https://forum.ansible.com/u/chris)\
**Post date:** [June 25, 2024, 2:33pm UTC](https://forum.ansible.com/t/sql-migration-playbooks-questions/5805/57 "2024-06-25T14:33:40Z")

</div>

> [@gothsome](#):
>
> i get the error that the credentiels in /root/.my.cnf is not correct to connect to ‘root’@‘localhost’ ,but when i enter locally “mysql” it uses the file to automatically login as root

I would expect that a socket connection is used by `root` when connecting to `localhost`, not the details from `/root/.my.cnf`?

Another user was having problems like this the other day, perhaps there might be some [suggestions in this thread that help you](http://forum.ansible.com/t/unable-to-reset-mysql-root-password-after-fresh-install-mariadb-server/6596/6)?

---

_[View the full topic](https://forum.ansible.com/t/sql-migration-playbooks-questions/5805)._