Login to MySQL as a user

[lutek14]

Hello
I've got XAMPP 7.2.8 in VM version on my Mac HighSierra. I wonder how to login via terminal but as a user?
What I have done:

1. Opened terminal with usage of XAMPP button that commanded this:

ssh -i '/Users/farmaceut/.bitnami/stackman/machines/xampp/ssh/id_rsa' -o StrictHostKeyChecking=no 'root@192.168.64.3'

2. Provided such a commands for DB:

CREATE DATABASE publications;
USE publications;
GRANT ALL ON publications.* TO 'jim'@'localhost' IDENTIFIED BY 'mypasswd';

3. And now I want to log in as a 'jim' instead of 'root'. 2hours searching and don't know how to perform this...

[dopazoma]

I have the same question. I want to run mysql via terminal, I can access the bin directory but cannot run mysql.