# Sequel pro + ssh to vagrant

**URL:** https://discourse.roots.io/t/sequel-pro-ssh-to-vagrant/4683
**Category:** trellis
**Created:** 2015-09-05T03:26:34Z
**Posts:** 65
**Showing post:** 63 of 65

## Post 63 by @cimocimocimo — 2017-01-19T19:03:55Z

Ok, sorry for the above comment. I read through everything and found out that this is default MariaDB behaviour and nothing to do with Trellis.

As others have mentioned in other posts this is due to the root login using the auth plugin unix\_socket. You can restore the old root password login behaviour following this post:

> [@Cannot connect to MySQL](https://discourse.roots.io/t/cannot-connect-to-mysql/8318/3):
>
> Hi guys, I have this issue also and I’m trying to track down where it has come from. It appears to be present since the mariaDB source was changed in ansible here: [https://github.com/roots/trellis/commit/f7873ec29f7544b20255e05aaadd18403b98307b](https://github.com/roots/trellis/commit/f7873ec29f7544b20255e05aaadd18403b98307b) It appears there is an issue with the [plugin](https://mariadb.com/kb/en/mariadb/unix_socket-authentication-plugin/) unix\_socket and the vagrant user not being allowed to login as root because unix\_socket requires sudo. That explains why vagrant access for the WP user still functions. But connections to the mysql root user …

I don’t know Ansible well enough to setup to run a script during provisioning but I imagine that it’s possible.

What I ended up doing to get my backup scripts running again quickly was to just add another mysql user with full privileges. I just added this:

```
- name: Add admin user
  mysql_user:
    name: admin
    host: "{{ item }}"
    password: "{{ mysql_root_password }}"
    check_implicit_admin: yes
    priv: '*.*:ALL,GRANT'
    state: present
  with_items:
    - 127.0.0.1
    - ::1
    - localhost
```

to “roles/mariadb/tasks/main.yml”.

Probably not the best idea from a security perspective I but I don’t see it as any worse than before when mysql root password logins were allowed. And since I only allowed local access to the db.

---

_[View the full topic](https://discourse.roots.io/t/sequel-pro-ssh-to-vagrant/4683)._