SSH into Vagrant Box DB

I have installed the ERPNext Vagrant box on my OSX laptop and it all runs perfectly.
Unfortunately I am having issues trying to connect to the Vagrant Mysql/MariaDb using Sequel Pro.
I have attached an image of the Sequel Pro settings available and am hoping someone can tell me what I am doing wrong.
Best Regards,
Rick

Hi.

I think you need to give (to mysql) permissions (enable remote access) to access mysql from macosx.
See this page:
mysql remote access

Thanks Luis that worked perfectly.
For anyone else using OSX who gets stuck, Here is how to view your Vagrant ERPNext DB using Sequel Pro.
vagrant up
vagrant ssh
vagrant@vagrant-ubuntu-trusty-64:~$ mysql -u root -p
Enter password: erpnext

MariaDB [(none)]> GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘password’ WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]> exit
Bye

vagrant@vagrant-ubuntu-trusty-64:~$

Below is a screen grab of what your connection settings should look like.

1 Like