techsupport

2468 readers

9 users here now

The Lemmy community will help you with your tech problems and questions about anything here. Do not be shy, we will try to help you.

If something works or if you find a solution to your problem let us know it will be greatly apreciated.

Rules: instance rules + stay on topic

Partnered communities:

You Should Know

Software gore

Recommendations

founded 1 year ago

MODERATORS

GatoB

My i3wm linux session is preventing me to correctly use MySQL, but I don't know how to fix this (self.techsupport)

submitted 8 months ago by Moshpirit to c/techsupport

11 comments fedilink hide all child comments

I am running in the same Linux distro two environments: Plasma (former KDE) and i3wm.

I use the same command on both environments: sudo systemctl start mysql.service && sudo mysql -u root -p -h localhost -P 3306, but while on KDE/Plasma I get no error, on i3wm I get a "the name is not activatable" error, and I don't know how to fix it (here's a screenshot).

Here's an extract from MySQL Workbench:

04:32:53 [ERR][SQL Editor Form]: SQL editor could not be connected: The name is not activatable
04:32:53 [ERR][SQL Editor Form]: Your connection attempt failed for user 'root' to the MySQL server at 127.0.0.1:3306:
  The name is not activatable

Also, I found out firefox doesn't connect to 127.0.0.1:3306 either on i3; on Plasma I get something like ("The connection has been restarted. The connection to the server was reset while the page was loading.").

I find is interesting too, because syncthing can connects through the localhost on i3wm, but mariadbd can't for some reason:

sudo lsof -n | grep TCP | grep LISTEN
[…]
syncthing   841 31843 syncthing          alberto  14u     IPv4              11863       0t0        TCP 127.0.0.1:8384 (LISTEN)
mariadbd   2537                            mysql  32u     IPv4              16382       0t0        TCP *:mysql (LISTEN)

you are viewing a single comment's thread
view the rest of the comments

[–] [email protected] 3 points 8 months ago (1 children)

Odd. On first read, that doesn't seem like something that your desktop manager should impact.

In your situation, I would research whether Plasma is auto starting a necessary/related background service; and then check my i3 configuration for whether I need to add an equivalent.

[–] Moshpirit 2 points 8 months ago

Thanks for replying! I have checked the autostart processes related to network and I got no different result. I will continue to check all of them though.