[ 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,

Samundra Shrestha

I work as fullstack developer. Having spent more than 5 years in the web development technologies, I aspire to create an environment where we can share, learn and grow together.

Leave a Reply

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