Welcome, Guest. Please login or register.

Author Topic: Could not connect to nedi@localhost with nedi  (Read 2314 times)

ahl

  • Newbie
  • *
  • Posts: 10
    • View Profile
Could not connect to nedi@localhost with nedi
« on: March 10, 2020, 06:41:39 pm »
Dear All;

I am facing a problem of not being able to login and getting the error message on subject
I am getting also ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory") on console.
This happened to me before because of disk space and I had to delete a file after increasing the disk space to get it working again
The problem I am not able to find which file to delete ( I don't remember well but it was either a temporary or log file )  :(

Thanks for your help in advance

Hannu Liljemark

  • Full Member
  • ***
  • Posts: 153
  • Here to help
    • View Profile
Re: Could not connect to nedi@localhost with nedi
« Reply #1 on: March 12, 2020, 09:08:02 am »
Is mysqld running on your system? Try restarting it? If you have one / filesystem I'd use "du -sh /" to look which directory uses most space and work from there, or if /var is seperate filesystem and it's full, "du -sh /var" and then dig down to see what could be deleted.

Look at /var/log/messages, /var/log/syslog, /var/log/daemon or something similar if mysqld refuses to start.

Br,
Hannu

ahl

  • Newbie
  • *
  • Posts: 10
    • View Profile
Re: Could not connect to nedi@localhost with nedi
« Reply #2 on: March 13, 2020, 09:11:26 am »
Thanks for the hint

Finally found the solution after checking mysql error log ..
After increasing the disk size
I had to rename ( or remove ) /var/lib/mysql/tc.log