How to use Sequel Pro or MySQL Tools with Xampp-VM

Problems with the Mac OS X version of XAMPP, questions, comments, and anything related.

How to use Sequel Pro or MySQL Tools with Xampp-VM

Postby CarlosFreire » 09. July 2019 01:39

Hi everyone:
In the non-virtual machine versions of Xampp, it was very easy to connect to the local database with MySQL Tools or Sequel Pro, usually via socket, by the path: /Applications/XAMPP/xamppfiles/var/mysql/mysql.sock

Already in the VM version ... nor by presidential decree.
The /lampp/etc/my.cnf file indicates the same socket connection by the path:
/opt/lampp/var/mysql/mysql.sock

But it does not work.

Can anyone give an indication or do we only have to go back to the non-VM version?
Working only with phpMyAdmin? Speaks seriously...

Last but, another thing:

There's a topic right here in Apache Friends just about this "new" and incensed VM version of Xampp:
https://community.apachefriends.org/f/viewtopic.php?f=29&t=75849&start=45
The problem is that nobody answers there, it's been a while.
Since October 22, 2018, to speak the truth.

Regards, Carlos
CarlosFreire
 
Posts: 4
Joined: 19. March 2019 13:54
Location: Rio de Janeiro, Brasil
XAMPP version: 7.3.6-2
Operating System: MacOs 10.13.6 [High Sierra]

Re: How to use Sequel Pro or MySQL Tools with Xampp-VM

Postby Ratinahirana » 08. May 2020 21:06

Hello,

I have created specially an account to answer you. I struggled a lot a finally I find a solution by connecting via SSH.
You have to use the connection feature SSH via Sequel PRO.

Host MySQL : 127.0.0.1 (local machine for the remote point of view)
User: root
Password: empty (by default there is none)
Base: optional
Port: optional

Host SSH: 192.168.X.X (you remote machine IP)
User SSH: root
Key SSH: ~/.bitnami/stackman/machines/xampp/ssh/id_rsa (You have to click on the little key button to browse to this path. Tick the option to show hidden folder to show see the .bitnami from your ~ user default directory)
Port SSH: optional

Then connect.
Regards.

NB: I used this link to find the solution https://stackoverflow.com/questions/49889465/how-to-ssh-to-xampp-vm-on-mac
Ratinahirana
 
Posts: 1
Joined: 08. May 2020 20:51
XAMPP version: 7.4
Operating System: Mac OS X

Re: How to use Sequel Pro or MySQL Tools with Xampp-VM

Postby unexpectedsense » 01. July 2020 16:34

Ratinahirana Hey! I also have created an account just to thank you for this.
Great! Thank you again, you save me!
unexpectedsense
 
Posts: 1
Joined: 01. July 2020 16:27
XAMPP version: 7.4.7-0
Operating System: MAC CATALINA

Re: How to use Sequel Pro or MySQL Tools with Xampp-VM

Postby ecssiah » 25. February 2021 21:13

I also just creating a new account to thank you, Ratinahirana! This was very helpful.
ecssiah
 
Posts: 1
Joined: 25. February 2021 21:11
XAMPP version: 8.0.2-0-vm
Operating System: Mac OS X Catalina 10.15.7


Return to XAMPP for macOS

Who is online

Users browsing this forum: No registered users and 19 guests