ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2 "No such file or directory") [SOLVED]

bcx

Verified User
Joined
Dec 11, 2015
Messages
97
Dear,

I had to do a re-install of the MYSQL. I ordered a couple of dedicated servers, but they were built with MYSQL 5.7 default instead of MariaDB

1.
I first, went into the CustomBuild 2.0 -> Edit Options -> MySQL Settings ->

Changed:
mariadb = 10.4
mysql_inst to = mariadb

2.
Pressed save.

3.
Went back to the tab "Update Software" inside the CB 2.0

4.
Started the build/update process of MariaDB

However I'm not sure if your CB script is working well, if its a bug, but on all the servers the MYSQL broked.
Resulting in this situation:

A)
https://forum.directadmin.com/threads/mysql-to-mariadb-upgrade-failed-please-help.58825/
Where no solution was provided..



LUCKY I kept searching and found this guide:

First I thought that it didn't work as well, as the my user and pass where not correct when I tried to connect to Mysql.

CREDENTIALS ARE NOT WORKING?!
Did a search on how DA was delivered and found the password script text doc, with all the right credentials.

On DEBIAN 10 you can find it on this path
Code:
/usr/local/directadmin/scripts/setup.txt


WRONG COMMANDO on your Guide!
Now roundcube still provided this error, that it could not connect to MYSQL, even if I copy/paste the commando of this guide:

./build rouncdube


1 hour, 2 hours went by when I finally understand the output that it gave me with that commando. Above commando was written wrong.

Instead of
Code:
./build rouncdube
it should be
Code:
./build roundcube

And tadda, roundcube worked again.



Perhabs this can help others with the same problem, or myself in the future.. who knows :)
 
Back
Top