Can't connect with - MySQL

[Agent Smith]

Gentlemen,

I am experiencing a problem regarding MySQL.

I can not connect with it, with MySQL Workbench, nor with LibreOffice Base.
I 've tried several ways, and not one works.
I can only work with MySQL via phpMyAdmin, which is great, but in my classes, our teacher is basing the studies on MySQL Workbench.

I've installed Unix ODBC, Mysql Connector ODBC and the native LibreOffice plugin to connect with MySQL, but, with no success.

Would you have any tip on this subject ?

Thanks a lot in advance,

Best regards,

[Agent Smith]

Up please...

Help... Anyone...

Thanks in advance!

Best regards,

[muungwana]

I dont know anything about databases but general principles should apply.

You are trying to connect to it, so it must be running as some sort of a service.

What address is it listening on? Are you trying to connect to the same address it is listening on? what error msgs are you getting when its not connecting?

Either you are trying to connect to a wrong address or you are not a member of a group it allows connections on.

[Agent Smith]

Dear Muungwana,

Thanks for your rapid response.

Well, the error messages are as follows: In MySql Workbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306:
  Database driver: Failed to open library 'mysqlcppconn'. Check settings.

In LibreOffice Base: Status SQL: IM002

[unixODBC][Driver Manager]Data source name not found, and no default driver specified

In LibreOffice Base, using internal MySql connector(Oracle): Status SQL: HY000
Código de erro: 2003

Can't connect to MySQL server on 'localhost' (111)

The server is running in the same machine of the clients.

I can only access my databases through  phpMyAdmin...

What can I possibly do to fix this ?

Tyvm

Regards,

[muungwana]

what does this command give you?

netstat -lptxu

login as root and then run this command and give its output

locate mysqlcppconn

[Archie]

There's obviously something wrong. On a fresh install of MySQL Workbench, I also get the same error. Although libmysqlcppconn6 seemed installed at /usr/lib/libmysqlcppconn.so.6, it is not discovered so it might be a problem in a setting/configuration.

In the meantime, here are search results I am going through but have not quite found something useful.

[muungwana]

[root@mtz ink]# find /usr/lib -iname *mysqlcppconn*
/usr/lib/libmysqlcppconn.so.6.1.1.1
/usr/lib/libmysqlcppconn.so.6

maybe its looking for "/usr/lib/libmysqlcppconn.so"?

i cant seem to be able to start this "mysql-workbench" program so i can not test it locally. You can run it under "strace" to know what path it uses to look for the library.

[root@mtz ink]# cat /usr/bin/mysql-workbench
#!/bin/bash
export LD_LIBRARY_PATH="/usr/lib/mysql-workbench:$LD_LIBRARY_PATH"
export MWB_DATA_DIR="/usr/share/mysql-workbench"
export MWB_LIBRARY_DIR="/usr/share/mysql-workbench/libraries"
export MWB_MODULE_DIR="/usr/lib/mysql-workbench/modules"
export MWB_PLUGIN_DIR="/usr/lib/mysql-workbench/plugins"
export DBC_DRIVER_PATH="/usr/lib/mysql-workbench"
/usr/bin/mysql-workbench-bin $*
[root@mtz ink]#

The problem could be in the above output,"libmysqlcppconn.so.6" library is at "/usr/lib" while the script that starts the executables has path that start with "/usr/lib/mysql-workbench/".

A soft link for the library it is looking for from "/usr/lib" to somewhere in "/usr/lib/mysql-workbench" could solve the problem.

[YouCanToo]

I don't even show it as being installed to begin with




UPDATE:   I just installed mysql-workbench and it appears to be working fine for me.



It wanted to add some dependencies during the install, of course I said yes.

[Archie]

YCT, the app can be launched but creating a new connection either as root or as a mysql user gives the error.

muungwana, there's is another file /usr/lib/libmysqlcppconn.so.1.1.1.1 that is the shared object linked to /usr/lib/libmysqlcppconn.so.6. I think the problem is Workbench does not know where to look for the lib. It is probably looking for it at /usr/lib/mysql-workbench which is obviously is not there.

I haven't tried a fix yet but it could be as simple as symlinking /usr/lib/mysqlcppconn.co.6 to /usr/lib/mysql-workbench/ ...

As the pharaoh always say, Later on.

[MBantz]

Just a quick tip,

if running MySql on PCLinuxOS, then accessing MySql via the network is disabled by default in /etc/my.cnf

If this is the case just remark the line about skip-networking

cheers,
MBantz

[Agent Smith]

Dear Mr. Bantz,

A very cool tip, but I keep getting this error: Cannot Connect to Database Server
Your connection attempt failed for user 'root' from your host to server at localhost:NULL:
  Database driver: Failed to open library 'mysqlcppconn'. Check settings.

Our MySql Workbench is outdated, and I already downloaded the latest source to update it.
But, I guess the problem is somewhere else. That mysqlcppconn is also outdated, and my hunch is it is the trouble maker here.
Would anyone have a tip on where I could download the latest mysqlcppconn and try to update the lib ?

Best regards and thanks for all your opinions.

Edit: After making the changes suggested by Mr. Bantz, LibreOffice Base was able to connect with MySql, but only trough the Oracle plugin.
So, my suspicion on mysqlcppconn is increasing.

[MBantz]

Have you tried to connect to the dabase with the real ip number the server has (instead of using localhost (and the :null part seems odd))?

Also, great tips are given here: http://dev.mysql.com/doc/refman/5.5/en/access-denied.html

[Agent Smith]

I've tried with localhost, 127.0.0.1, with the same effect.
I am betting my chips on mysqlcppconn, and right now, I am searching for something about it.

Regards,

[muungwana]

I've tried with localhost, 127.0.0.1, with the same effect.
I am betting my chips on mysqlcppconn, and right now, I am searching for something about it.

Regards,

Information about it is already on this thread,nobody has just followed it up yet.

open "/usr/bin/mysql-workbench" script file and modify the two lines that deals with "MODULE_DIR" and "PLUGIN_DIR" with two below lines and try again.

export MWB_MODULE_DIR="/usr/lib:/usr/lib/mysql-workbench/modules"
export MWB_PLUGIN_DIR="/usr/lib:/usr/lib/mysql-workbench/plugins"

[Agent Smith]

Hi muungwana,

I altered the script that calls Mysql Workbench with your options, but to no effect, the same error happened.

And,  Mysql Workbench still doesn't work on PCLinuxOS... 

I am working in other solution to this problem, since it seems it will not get off ground.

Sincerely,