[ Solved ] Cannot connect to local MySQL server through socket

MySql Workbench Problem:

Test connection failed

Couldn’t load library libmysqlclient_r.so:libmysqlclient_r.so: cannot open shared file: No such file or directory

In both of these problems, the UI is unable to connect to local database server which was running in background. After searching in internet for solution and being to MySql official forum. I found this working solution for both problems stated above and I think it should work for similar kind of problem too.

Solution :

Create Symbolic Link

asee@asee-hp:~$ cd /usr/lib

asee@asee-hp:~$ sudo ln -s libmysqlclient_r.so.15 libmysqlclient_r.so

After invoking those commands, re-start the applications and try creating the database connection, Now you should successfully get into database connection.

Drop comments if you have difficulty in gettting connected.

with best regards,
Asee

Leave a Reply

Your email address will not be published. Required fields are marked *