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