Libmysql is a client library for connecting C written application to MySql.
Questions tagged [libmysql]
113 questions
83
votes
11 answers
Ruby gem mysql2 install failing
When I try to install the mysql2 gem, it fails with no apparent errors. Does anyone know what to do to work around this so mysql2 installs?
$ sudo gem install mysql2
Building native extensions. This could take a while...
ERROR: Error installing…

Tanner
- 1,214
- 3
- 12
- 16
30
votes
7 answers
mysql2.so: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory
I am trying to run a Rails two app with Ubuntu 10.04 server, sphinx, myql2 version 0.2.7 and percona server 5.5 (Myslql 5.5). mysql2 in irb works ok, I can connect to the db. this rails 2 app is working in another Centos server with MySql 5.1. When…

rtacconi
- 14,317
- 20
- 66
- 84
16
votes
3 answers
Cheapest way to determine if a MySQL connection is still alive
I have a pool of MySQL connections for a web-based data service. When it starts to service a request, it takes a connection from the pool to use. The problem is that if there has been a significant pause since that particular connection has been…

MtnViewMark
- 5,120
- 2
- 20
- 29
13
votes
2 answers
CLSQL and MYSQL on OS X
I'm working on OS X 10.6.4. I've been using clbuild to install supporting libraries for SBCL (including clsql), and I do all my work through Aquamacs. I installed MySQL using the excellent instructions over at Hive Logic. But when I call (require…

Brendan Foote
- 1,378
- 2
- 12
- 22
12
votes
4 answers
"set names" vs mysqli_set_charset — besides affecting mysqli_escape_string, are they identical?
It seems to be common knowledge to use mysql_set_charset / mysqli::set_charset instead of the direct MySQL query set names.
The reason often cited is that set names is insecure because the encoding used for mysql_real_escape_string /…

Pacerier
- 86,231
- 106
- 366
- 634
8
votes
4 answers
What is difference between libmysqlclient.a and libmysqlclient_r.a?
Which should I use to link for mysqlclient library? What is the difference between them? I can't seem to find the answer. Thanks.

Van Nguyen
- 682
- 3
- 11
- 21
7
votes
1 answer
Where's the source of mysqlclient.lib?
I have a C++ application which connects to a MySQL server.
It all works fine.
Currently it uses libmysql.dll.
At build time I link to libmysql.lib.
As far as I understand I can link to mysqlclient.lib instead and get rid of the dependency of…

Poni
- 11,061
- 25
- 80
- 121
6
votes
2 answers
EnvironmentError: mysql_config not found
EnvironmentError: mysql_config not found, while installing MySQL-python
Could someone advice me on what to do? I did the following from my-side:
Error I got while installing with pip:
ubuntu12.04@ubuntu12.04:~$ sudo pip install MySQL-python
…

lafoudre
- 69
- 1
- 1
- 3
5
votes
1 answer
Why Qt Configure can not find correct MySQL installation on target when cross compiling?
I want to build MySQL driver while cross-compiling Qt5 for Arm(Raspberry Pi).
In order to check MySQL client libraries installation on target we run:
pi@raspberrypi:~ $ mysql_config --version
10.1.38
pi@raspberrypi:~ $ mysql_config…

IMAN4K
- 1,265
- 3
- 24
- 42
4
votes
3 answers
MariaDB server times out client connection after 600 seconds
My MariaDB server is timing out my C++ client (using libmariadb) after 600 seconds (10 minutes) of inactivity, and I'm not sure why, because I can't find any configured timeouts that specify that number.
Here's my code, where I execute a simple…

villapx
- 1,743
- 1
- 15
- 31
4
votes
1 answer
mysql_init() always return null
I have this very short program. For some reason mysql_init always returns null for me. According to the documentation, this happens if there isn't enough memory. How can this be? It's just these few lines of code.
#include "mysql.h"
int main()
{
…

marc40000
- 3,167
- 9
- 41
- 63
3
votes
1 answer
How to prematurely finish mysql_use_result() / mysql_fetch_row()?
I am in the process of writing my first C client for MySQL 5.5 and have stumbled across the following page in the documentation. Nearly at the end, it states (bold emphasis mine, italic emphasis not mine):
An advantage of mysql_use_result() is…

Binarus
- 4,005
- 3
- 25
- 41
3
votes
1 answer
Connecting to a remote MySQL server from a Delphi program through SSL
I don't have a good knowledge of SSL principles, but just want the encryption to work for me.
I have a DB and a user with "REQUIRE X509" specified.
The necessary certificates have been created as described in MySQL docs, and work well - i can…

hhyhbpen
- 43
- 3
3
votes
1 answer
How do I build libmySQL?
I aim to integrate libmySQL into my executable instead of using libmySQL.dll.
I use VC++ 2008 @ Windows Vista.
I've downloaded "mysql-connector-c-noinstall-6.0.2-win32-vs2005.zip" from
http://dev.mysql.com/downloads/connector/c/
It contains only…

Poni
- 11,061
- 25
- 80
- 121
3
votes
1 answer
mysqlnd noticeable slower than libmysql using PDO
I'm just switching to mysqlnd to be able to use http://php.net/manual/en/book.mysqlnd-ms.php but I see some serious performance degradation compared to libmysql.
NewRewlic shows more 100ms spend in PHP after switching to mysqlnd…

Tuner
- 69
- 7