mysql/c++ connector error: libmysqlcppconn.so.7: cannot open sahred object file: No such file or directory

mysql/c++ connector error: libmysqlcppconn.so.7: cannot open sahred object
file: No such file or directory

I know there is a lot about this on the internet and I have tried most of
it without luck. Most solutions says that en environment variable is
missing aka (LD_LIBRARY_PATH) which i pointed it to the file in user and
root but it still does not pick it up. I am not sure what exactly is
looking for the library or how to fix this??
Any ideas?
EDIT ldd output:
linux-vdso.so.1 => (0x00007fffb97ff000)
libmysqlcppconn.so.7 => not found
libstdc++.so.6 => /usr/lib/x86_64-linux-gnu/libstdc++.so.6
(0x00007f002fdb3000)
libgcc_s.so.1 => /lib/x86_64-linux-gnu/libgcc_s.so.1 (0x00007f002fb9c000)
libc.so.6 => /lib/x86_64-linux-gnu/libc.so.6 (0x00007f002f7dd000)
libpthread.so.0 => /lib/x86_64-linux-gnu/libpthread.so.0 (0x00007f002f5c0000)
libm.so.6 => /lib/x86_64-linux-gnu/libm.so.6 (0x00007f002f2c3000)
/lib64/ld-linux-x86-64.so.2 (0x00007f00300c7000)