Open Terminal not working even after exporting DBngin to PATH

[tableplus]

Open Terminal not working even after exporting DBngin to PATH

[huyphams]

Hi @zisiszikos you can connect using the full path comand:
mysql --socket /tmp/mysql_3306.sock -uroot
DBngin supports multiple ports so it will cause conflict of socket if we use the same socket path for all running services.
Also on the new DBngin version, you don't need to export binary, just click the arrow button and it will open terminal.

[hopewise]

I have the same issue:
it asks to add:

# DBngin exports
export PATH=/Users/Shared/DBngin/mysql/5.7.23/bin:$PATH

how ever, its already adde and sourced.

[koriym]

@maskedjellybean

Adding function to ~/.bashrc works.

function mysqls() {
  command mysql --socket /tmp/mysql_$1.sock -uroot
}

mysqls 3036 connects port 3306 DBngin mysql server.

[maskedjellybean]

I'm still experiencing this issue. Running mysql --socket /tmp/mysql_3306.sock -uroot does work, but I would really like to be able to run mysql -uroot. Does DBngin require connecting via socket?

[zisiszikos]

Is this really working?

I follow those steps:

1. Strarting MySQL 5.7.23 : 3306 from DBngin interface
2. Open terminal and run: export PATH=/Users/Shared/DBngin/mysql/5.7.23/bin:$PATH
3. which mysql returns correctly /Users/Shared/DBngin/mysql/5.7.23/bin/mysql
4. running ps -ax | grep mysql | grep -v grep finds the following process:
   /Users/Shared/DBngin/mysql/5.7.23/bin/mysqld --user=_mysql --port=3306 --socket=/tmp/mysql_3306.sock --basedir=/Users/Shared/DBngin/mysql/5.7.23
5. running mysql command I get the following:
   ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
   which is expected because it is trying to find the /tmp/mysql.sock but the service is showing that the socket is /tmp/mysql_3306.sock

Any thoughts about this?

[zisiszikos]

Thanks! It works with the socket parameter.

But there is another thing, that I don't know if it is my terminal problem or DBngin problem actually.
When I click the arrow button to open the terminal, the following command is written at the terminal:

export PATH=export PATH=/Users/Shared/DBngin/mysql/5.7.23/bin:$PATH:$PATH

It works, but as you can see the command is incorrectly written. Just confirm please if this a global problem or it is just my terminal.

And of course it would be very nice if there was an option to choose which terminal is going to open. 😄

Thanks.

[debiprasad]

I'm still experiencing this issue. Running mysql --socket /tmp/mysql_3306.sock -uroot does work, but I would really like to be able to run mysql -uroot. Does DBngin require connecting via socket?

I use oh-my-zsh and I added an alias to make it easy.

[huyphams]

Ah yeah, I've fixed it 😄

[SiddharthPant]

Just stating for everyone's quick reference that to avoid defining aliases you can instead export an environment variable. Just include line export MYSQL_UNIX_PORT=/tmp/mysql_3306.sock at the end of your ~/.zshrc. Now you can connect to mysql using mysql -uroot as usual.
Here are more env vars you can use from mysql docs: https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html

[QinyuHu]

Having the same issue. There are no other instructions on what to do with it.

[kpysanyi]

Yes, is there any solution to fix this issue?
I am also getting Can't connect to local MySQL server through socket '/tmp/mysql.sock' as an error when i try to connect mysql...

[huyphams]

You can connect with port @kpysanyi if you want to connect with socket, you can lookup the correct socket (with port) in /tmp
I've fixed this issue in the upcoming release.

[huyphams]

We can create many MySQL versions in DBngin, so it's not possible to use the same socket path for all versions. The current solution is add the port suffix to the local socket.

[huyphams]

Does DBngin require connecting via socket?

DBngin supports both socket and port, however, mysql -uroot use socket by default that's why you can't connect with the default path.

[izshreyansh]

I have the same issue: it asks to add:

# DBngin exports
export PATH=/Users/Shared/DBngin/mysql/5.7.23/bin:$PATH

how ever, its already adde and sourced.

This worked, Thank you.