Debian 8.x SSH issue
 

I committed a linux sin and ran an update without paying attention. I can now not get MySQL Workbench or any other database tool to connect to the server and I'm convinced it's SSH-related. I'm getting the following errors when I go to connect. I'm positive something in the upgrade changed how it works. I was on Debian 7.x prior.

Followed by.

The server is still up (Loremaster), and players are on it. I just can't get to the DB.

With the "user root" part is that referring to the MySQL user or SSH user? It's possible SSH has logging in as root disabled by default.

Rerun the mysql command to allow root permission for 127.0.0.1?

You also may want to look at.. logs like it notes? :)

I installed the newest Debian at work yesterday. For me to log in as root via SSH, you had to edit the ini file. You could log in as a different user and then su to root.

http://linuxconfig.org/enable-ssh-ro...n-linux-server

Thanks. I'll check this out.

What am I doing wrong now? I can get to the mysql CLI via the server, but no access via workbench.

http://s18.postimg.org/xi0rxauop/Scr...8_12_06_AM.png

It says through SSH tunnel, is SSH running and can you SSH to localhost?

OS error code 61: No data available

you need to make sure mysql is even running (are you accessing it locally or remotely from this app, need to check what IP is appropriate and the port).. we can't connect to it.

Yes, SSH is running. It's how I normally connect via terminal to my server. That's why it's frustrating to me. My server is a VPS, so I am connecting remotely.

A dumb question, but you're not trying to connect to 127.0.0.1 from your local machine without a tunnel or anything else setup, are you? 127.0.0.1 is localhost (loopback device), so unless you already have a tunnel forwarding port 3306 on your local box to 3306 on the remote, that's not going to work.

No, the image I provided above purposely has my server (SSH) information covered up. The localhost is relative to the SSH host, which is the same server, albeit on port 3306 for MySQL. After provocating's suggestion, I can now get MySQL Workbench to connect to the server via SSH, but now the error pertaining to MySQL is my roadblock.

Edit to add: ls /etc/init.d shows that mysql is running.

Edit #2: nmap shows 3306 open as well on localhost.

Use HeidiSQL from another computer, just for kicks. Also, did you give root access to log in to the server remotely? If you are trying to connect to that server remotely via root, that is a security risk and normally has to be changed.

For now I am, until I can get this resolved. It won't be that way shortly. I appreciate the assistance. I'll try Heidi from my PC.

Wow, works flawlessly with HeidiSQL. No idea why. I guess I'll be using this from here on out.

I really appreciate everyone who chimed. I was pulling my hair out! :D