MySQL Forums - Connector/C (libmysqlclient)

How to properly use mysql_config (no replies)

Igor Korot — Sun, 04 Jan 2026 21:18:28 +0000

Hi, ALL,
In my Makefile.am I have the following:

libmysql_lib_la_CXXFLAGS = `mysql_config \
   --cflags` \
   -I../../dbinterface \
   -DUNICODE \
   @DBTOOLKIT@

libmysql_lib_la_LDFLAGS = `mysql_config \
   --libs`

Is _LDFLAGS correct place? Or I should put it in some other variable, namely _LIBS?

Thank you.

MySQL C client library version for 9.x (2 replies)

Sebastien FLAESCH — Thu, 15 Jan 2026 14:37:31 +0000

Hello,

With MySQL 9.3 "Innovation Release", I see that the major version number of the C client library has not changed from MySQL 8.4 (it's still .24):

libmysqlclient.so -> libmysqlclient.so.24
libmysqlclient.so.24 -> libmysqlclient.so.24.1.0
libmysqlclient.so.24.1.0

This is all fine, as long as the .24 version stays the same (assuming that no incompatible API changes are introduced with version 9)

Can MySQL community please make sure this will be the case?

I mean, please do NOT change the API / lib version just before releasing the LTS!

Thanks!
Seb

Errror on failure is empty (no replies)

Igor Korot — Sat, 23 Nov 2024 20:41:35 +0000

Hi, ALL,

Trying the following code:

    m_db = mysql_init( m_db );
    if( !m_db )
    {
    }
    else
    {
        m_db = mysql_real_connect( m_db, m_pimpl->m_myconv.to_bytes( m_pimpl->m_host.c_str() ).c_str(), m_pimpl->m_myconv.to_bytes( m_pimpl->m_user.c_str() ).c_str(), m_pimpl->m_myconv.to_bytes( m_pimpl->m_password.c_str() ).c_str(), m_pimpl->m_myconv.to_bytes( m_pimpl->m_dbName.c_str() ).c_str(), m_port, m_pimpl->m_socket == L"" ? NULL : m_pimpl->m_myconv.to_bytes( m_pimpl->m_socket.c_str() ).c_str(), m_flags );
            if( !m_db )
            {
                auto e = mysql_error( m_db );
            }
    }

When executing I don't have a successful connection, but the "e" does not contain anything.

mySQL 8 is running on Linux machine and I'm trying to connect from Windows.

Is this a bug?

Thank you.

MySQL X DevAPI connectors utf8 issue (no replies)

Jens hansen — Thu, 02 May 2024 20:03:57 +0000

The function 'mysqlx_collection_modify_set' should be capable of updating or creating the key name "_b_ke-y$fkæøåÆåø", but it is not performing any action when attempting to do so. However, it works as expected when the key name is something like "test".

I'm using it in this way:

mysqlx_collection_t *collection_ = mysqlx_get_collection(schema, collection, 0);

mysqlx_stmt_t *stmt2 = mysqlx_collection_modify_new(collection_);

mysqlx_set_modify_set(stmt2, "_b_ke-y$fkæøåÆåø", PARAM_EXPR("{\"username\":\"test\"}"), PARAM_END);

IoT connector (no replies)

Robert Watson — Wed, 01 May 2024 20:32:53 +0000

I'm trying to connect my IoT device (Tibbo) to my local server mysql instance. The device has its own IDE and library set which unfortunately doesn't include a mysqlclient library.
A previous user had put together a primitive mysql_client code in basic,which doesn't work to connect because of password encryption changes. They used a salt followed by sha1/sha1.
Could someone steer me to a codebase that I could use to build a new mysql client in C. I have limited encryption library functions (sha1,AES128,RC4)

MySQL X DevAPI connectors bind dont work with bytes (no replies)

Jens hansen — Sun, 24 Mar 2024 14:34:21 +0000

Hi there!

I have tried both C and Node.js X DevAPI Connector to connect to my Mysql Document Store server. The connection is established, but the server does not seem to understand my search criteria when I use bytes format.

By byte format, I mean that the following C code does not work:

mysqlx_set_find_criteria(query, "field_name = :param");
mysqlx_stmt_bind(query, "param", PARAM_BYTES(bytes, 3), PARAM_END);

but the following works and seems to do exactly the same as the above:

mysqlx_set_find_criteria(query, "field_name = [12, 4, 0]");
mysqlx_stmt_bind(query, "param", PARAM_BYTES(bytes, 3), PARAM_END);

I don't understand what the problem is and why it can't find the document and what is the idea of 'PARAM_BYTES' if you can't compare field value with bytes?

In the Node.js world the following code does not work::

const result = await collection.find("field_name = :param")
.bind('param', Buffer.from([12, 4, 0]))
.execute();

but the following seems to work and do exactly the same as the above:

const result = await collection.find("field_name = [12, 4, 0]")
.bind('param', Buffer.from([12, 4, 0]))
.execute();

I hope someone can help me and confirm the reason why it doesn't work

MySQL 8.3.0 increments libmysqlclient.so lib version from 22 to 23 (1 reply)

Sebastien FLAESCH — Wed, 21 Feb 2024 15:12:39 +0000

Hello,

Just installed MySQL 8.3.0 on my Linux Debian 11, and I can see that the shared lib version number of libmysqlclient.so has been incremented from 22 to 23:

libmysqlclient.so.23

I just want to get a confirmation that this is expected.

I assume it's because the API/ABI of the library has changed and is no longer compatible with libmysqlclient.so.23 - is this the case?

In fact, we deliver our C binary linked with libmysqlclient, which results in a dependency to the shared lib with version number (this is normal on Linux):

$ ldd -r $FGLDIR/dbdrivers/dbmmys_8_2.so
...
libmysqlclient.so.22 => /opt3/dbs/mys/8.2/lib/libmysqlclient.so.22 (0x00007f6bca430000)
...

If we want to support MySQL 8.3.x, we will have to build a specific binary linked with libmysqlclient.so.23

We have our own installer and do not use Linux packaging systems.

Since we want to support various versions of MySQL, we must deliver a binary for each of the existing libmysqlclient.so.xxx versions.
So far we have binaries for:
libmysqlclient.so.20 ( MySQL 5.7 )
libmysqlclient.so.21 ( MySQL 8.0 )
libmysqlclient.so.22 ( MySQL 8.2 )

I would expect NO VERSION NUMBER increment, if the libmysqlclient shared libs of 8.3.x is compatible with 8.2.x

What are the libmysqlclient API changes in 8.3.0 ?

Seb

Running the program on OSX fails (no replies)

Igor Korot — Wed, 11 Oct 2023 02:25:57 +0000

Hi, ALL,

I built libmysqlclient from sources on my Apple laptop. Everything built fine.

Then I built my program that will be using this on the same laptop. The build succeeded. I'm using the Xcode to build my program

In the end of the build it runs following command:

    cp -f ~/dbhandler/dbhandler/mysql-server/BuildOSX/libmysql/libmysqlclient.dylib "$TARGET_BUILD_DIR/$TARGET_NAME.app/Contents/Frameworks/libmysqlclient.dylib"
    
    install_name_tool -id "@rpath/Frameworks/libmysqlclient.dylib" "$TARGET_BUILD_DIR/$TARGET_NAME.app/Contents/Frameworks/libmysqlclient.dylib"
    
    cp ~/dbhandler/dbhandler/Build/Products/Debug/liblibmysql.dylib "$TARGET_BUILD_DIR/$TARGET_NAME.app/Contents/Frameworks/liblibmysql.dylib"
    
    install_name_tool -id '@rpath/Frameworks/liblibmysql.dylib' "$TARGET_BUILD_DIR/$TARGET_NAME.app/Contents/Frameworks/liblibmysql.dylib"
    
    install_name_tool -change "/Users/igorkorot/dbhandler/dbhandler/mysql-server/buildOSX/libmysql/libmysqlclient.21.dylib" @executable_path/../Frameworks/libmysqlclient.dylib "$TARGET_BUILD_DIR/$TARGET_NAME.app/Contents/Frameworks/liblibmysql.dylib"

    install_name_tool -change "/usr/local/lib/liblibmysql.dylib" @executable_path/../Frameworks/liblibmysql.dylib "$TARGET_BUILD_DIR/$TARGET_NAME.app/Contents/Frameworks/liblibdbloader.dylib"

so that the library can be used from inside the Bundle.

When verifying, I have the following:

    Igors-MacBook-Air:Frameworks igorkorot$ otool -L liblibmysql.dylib 
    liblibmysql.dylib:
    	@rpath/Frameworks/liblibmysql.dylib (compatibility version 1.0.0, current version 1.0.0)
    	@executable_path/../Frameworks/libmysqlclient.dylib (compatibility version 21.0.0, current version 21.0.0)
    	/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 400.9.0)
    	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1252.50.4)
    Igors-MacBook-Air:Frameworks igorkorot$ otool -L libmysqlclient.dylib 
    libmysqlclient.dylib:
    	@rpath/Frameworks/libmysqlclient.dylib (compatibility version 21.0.0, current version 21.0.0)
    	/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 400.9.0)
    	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1252.50.4)
    Igors-MacBook-Air:Frameworks igorkorot$ pwd
    /Users/igorkorot/dbhandler/dbhandler/Build/Products/Debug/dbhandler.app/Contents/Frameworks
    Igors-MacBook-Air:Frameworks igorkorot$

As far as I understand the "otool" output - everything is linked to the place inside the Bundle.

However when I tried to run my application (from Terminal with "open dbhandler.app"), I get the following error:

Quote

Failed to load shared library liblibdbloader.dylib
dlopen(liblibdbloader.dylib, 2). Library not loaded: /usr/local/lib/liblibmysql.dylib.
Referenced from
Reason: image not found

The dbloader.dylib library had been re-linked to the libmysql that was copied to the new place (and otool seems to confirm that):

Igors-MacBook-Air:Frameworks igorkorot$ otool -L liblibdbloader.dylib 
liblibdbloader.dylib:
	@rpath/Framework/liblibdbloader.dylib (compatibility version 1.0.0, current version 1.0.0)
	/System/Library/Frameworks/IOKit.framework/Versions/A/IOKit (compatibility version 1.0.0, current version 275.0.0)
	/System/Library/Frameworks/Carbon.framework/Versions/A/Carbon (compatibility version 2.0.0, current version 158.0.0)
	/System/Library/Frameworks/Cocoa.framework/Versions/A/Cocoa (compatibility version 1.0.0, current version 22.0.0)
	/System/Library/Frameworks/AudioToolbox.framework/Versions/A/AudioToolbox (compatibility version 1.0.0, current version 492.0.0)
	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1252.50.4)
	/System/Library/Frameworks/OpenGL.framework/Versions/A/OpenGL (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_osx_cocoau_xrc-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_osx_cocoau_html-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_osx_cocoau_qa-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_osx_cocoau_adv-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_osx_cocoau_core-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_baseu_xml-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_baseu_net-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/libwx_baseu-3.2.dylib (compatibility version 1.0.0, current version 1.0.0)
	/Library/Frameworks/iODBC.framework/Versions/3.52/iODBC (compatibility version 1.0.0, current version 3.52.14)
	@executable_path/../Frameworks/liblibmysql.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/liblibpostgres.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/liblibodbc.dylib (compatibility version 1.0.0, current version 1.0.0)
	@executable_path/../Frameworks/liblibsqlite.dylib (compatibility version 1.0.0, current version 1.0.0)
	/usr/lib/libc++.1.dylib (compatibility version 1.0.0, current version 400.9.0)
Igors-MacBook-Air:Frameworks igorkorot$

So what am I missing? Could someone look at that?

I'm not sure what else do I need to do in order to have successful run...

Thank you in advance.

Connection vb.net 2010 with database (no replies)

Stef Geudens — Fri, 18 Aug 2023 12:09:04 +0000

Hi,
I am using the connector/C in combination in combination with visual basic in visual studio 2010.
The connection with the normal connection string (server,uid,pwd,port,database) wont work and raises this error: 'a Call to SSPI failed, see internal error'.
I tried working around that error with an extra argument in the connectionstring, sslMode=none. When I connect with that string, it raises the next error:'Authentication method 'caching_sha2_password' not supported by any of the available plugins.

Can someone help pls?

NO_DATA is returned while there is a data (no replies)

Igor Korot — Sun, 25 Dec 2022 05:52:59 +0000

Hi, ALL,

Following code returns MYSQL_NO_DATA for the table where there is definitly a foreign key.

Could someone please explain what I am doing wrong?

Thank you.

    std::wstring cat, table = L"owners", schema = L"draft";
    int result = 0;
    std::wstring query2 = L"SELECT kcu.column_name, kcu.ordinal_position, kcu.referenced_table_schema, kcu.referenced_table_name, kcu.referenced_column_name, rc.update_rule, rc.delete_rule, rc.constraint_name FROM information_schema.key_column_usage kcu, information_schema.referential_constraints rc WHERE kcu.constraint_name = rc.constraint_name AND kcu.table_catalog = ? AND kcu.table_schema = ? AND kcu.table_name = ?;";
    char *col_name[256], ref_schema[256], ref_table[256], ref_column[256], constraint_name[256];
    char update_rule[20], delete_rule[20];
    int ordinal;
    std::map > foreign_key;
    unsigned long str_length1, str_length2, str_length3;
    str_length1 = catalog.length() + 2;
    str_length2 = schemaName.length() + 2;
    str_length3 = tableName.length() + 2;
    char *cat = new char[str_length1], *schema = new char[str_length2], *table = new char[str_length3];
    memset( cat, '\0', str_length1);
    memset( schema, '\0', str_length2 );
    memset( table, '\0', str_length3 );
    strcpy( cat, m_pimpl->m_myconv.to_bytes( catalog.c_str() ).c_str() );
    strcpy( schema, m_pimpl->m_myconv.to_bytes( schemaName.c_str() ).c_str() );
    strcpy( table, m_pimpl->m_myconv.to_bytes( tableName.c_str() ).c_str() );
    MYSQL_BIND params[3];
    memset( params, 0, sizeof( params ) );
    auto res1 = mysql_stmt_init( m_db );
    if( !res1 )
    {
        std::wstring err = m_pimpl->m_myconv.from_bytes( mysql_stmt_error( res1 ) );
        errorMsg.push_back( err );
        result = 1;
    }
    else
    {
        if( mysql_stmt_prepare( res1, m_pimpl->m_myconv.to_bytes( query2.c_str() ).c_str(), query2.length() ) )
        {
            std::wstring err = m_pimpl->m_myconv.from_bytes( mysql_stmt_error( res1 ) );
            errorMsg.push_back( err );
            result = 1;
        }
        else
        {
            params[0].buffer_type = MYSQL_TYPE_STRING;
            params[0].buffer = (char *) cat;
            params[0].buffer_length = strlen( cat );
            params[0].is_null = 0;
            params[0].length = &str_length1;
            params[1].buffer_type = MYSQL_TYPE_STRING;
            params[1].buffer = (char *) schema;
            params[1].buffer_length = strlen( schema );
            params[1].is_null = 0;
            params[1].length = &str_length2;
            params[2].buffer_type = MYSQL_TYPE_STRING;
            params[2].buffer = (char *) table;
            params[2].buffer_length = strlen( table );
            params[2].is_null = 0;
            params[2].length = &str_length3;
            strcpy( cat, m_pimpl->m_myconv.to_bytes( catalog.c_str() ).c_str() );
            strcpy( schema, m_pimpl->m_myconv.to_bytes( schemaName.c_str() ).c_str() );
            strcpy( table, m_pimpl->m_myconv.to_bytes( tableName.c_str() ).c_str() );
            if( mysql_stmt_bind_param( res1, params ) )
            {
                std::wstring err = m_pimpl->m_myconv.from_bytes( mysql_stmt_error( res1 ) );
                errorMsg.push_back( err );
                result = 1;
            }
            else
            {
                if( mysql_stmt_execute( res1 ) )
                {
                    std::wstring err = m_pimpl->m_myconv.from_bytes( mysql_stmt_error( res1 ) );
                    errorMsg.push_back( err );
                    result = 1;
                }
                else
                {
                    MYSQL_BIND results1[8];
                    bool is_null[8], error[8];
                    unsigned long length[8];
                    memset( results1, 0, sizeof( results1 ) );
                    results1[0].buffer_type = MYSQL_TYPE_STRING;
                    results1[0].buffer = &col_name;
                    results1[0].buffer_length = 256;
                    results1[0].is_null = &is_null[0];
                    results1[0].length = &length[0];
                    results1[0].error = &error[0];
                    results1[1].buffer_type = MYSQL_TYPE_SHORT;
                    results1[1].buffer = (char *) &ordinal;
                    results1[1].is_null = &is_null[1];
                    results1[1].error = &error[1];
                    results1[1].length = &length[1];
                    results1[2].buffer_type = MYSQL_TYPE_STRING;
                    results1[2].buffer = &ref_schema;
                    results1[2].buffer_length = 256;
                    results1[2].is_null = &is_null[2];
                    results1[2].length = &length[2];
                    results1[2].error = &error[2];
                    results1[3].buffer_type = MYSQL_TYPE_STRING;
                    results1[3].buffer = &ref_table;
                    results1[3].buffer_length = 256;
                    results1[3].error = &error[3];
                    results1[3].length = &length[3];
                    results1[3].error = &error[3];
                    results1[4].buffer_type = MYSQL_TYPE_STRING;
                    results1[4].buffer = &ref_column;
                    results1[4].buffer_length = 256;
                    results1[4].is_null = &is_null[4];
                    results1[4].length = &length[4];
                    results1[4].error = &error[4];
                    results1[5].buffer_type = MYSQL_TYPE_STRING;
                    results1[5].buffer = &update_rule;
                    results1[5].buffer_length = 20;
                    results1[5].length = &length[5];
                    results1[5].is_null = &is_null[5];
                    results1[5].error = &error[5];
                    results1[6].buffer_type = MYSQL_TYPE_STRING;
                    results1[6].buffer_length = 20;
                    results1[6].buffer = &delete_rule;
                    results1[6].length = &length[6];
                    results1[6].is_null = &is_null[6];
                    results1[6].error = &error[6];
                    results1[7].buffer_type = MYSQL_TYPE_STRING;
                    results1[7].buffer = &constraint_name;
                    results1[7].buffer_length = 256;
                    results1[7].is_null = &is_null[7];
                    results1[7].length = &length[7];
                    results1[7].error = &error[7];
                    if( mysql_stmt_bind_result( res1, results1 ) )
                    {
                        std::wstring err = m_pimpl->m_myconv.from_bytes( mysql_stmt_error( res1 ) );
                        errorMsg.push_back( err );
                        result = 1;
                    }
                    else
                    {
                        while( true )
                        {
                            auto dataset = mysql_stmt_fetch( res1 );
                            if( dataset == 1 || dataset == MYSQL_NO_DATA )
                                break;
                            else
                            {
                                auto orig_col = m_pimpl->m_myconv.from_bytes( *col_name );
                                auto refCol = m_pimpl->m_myconv.from_bytes( ref_column );
                                auto refSchema = m_pimpl->m_myconv.from_bytes( ref_schema );
                                auto refTable = m_pimpl->m_myconv.from_bytes( ref_table );
                                std::map >origFields, refFields;
                                origFields[ordinal].push_back( orig_col );
                                refFields[ordinal].push_back( refCol );
//                                foreign_key[ordinal].push_back( new FKField( ordinal, constraint_name, schemaName, tableName, orig_col, refSchema refTable, refCol, origFields[ordinal], refFields[ordinal], 
                            }
                        }
                        if( mysql_stmt_close( res1 ) )
                        {
                            std::wstring err = m_pimpl->m_myconv.from_bytes( mysql_stmt_error( res1 ) );
                            errorMsg.push_back( err );
                            result = 1;
                        }
                    }
                }
            }
        }
    }

Connection error with MySQL 8.0.28 and above onwards (1 reply)

Rajib Saha — Wed, 23 Nov 2022 15:28:44 +0000

Hi,

From our product, we use Mysql as an optional database.

It was working fine till Mysql 8.0.27.

But, from Mysql 8.0.28, we are getting error as “SSL connection error” and error number as 2026.

We are calling MySQL Connector APIs as below.
=========================================
m_pMySQL = mysql_init( m_pMySQL );
mysql_real_connect( m_pMySQL, workingHost, user, password, server, port, NULL, CLIENT_MULTI_STATEMENTS );
=========================================

Error we are getting from the API call mysql_real_connect().

What different, we need to do for Mysql 8.0.28 in this context for successful connection.

Regards
Rajib

[feature] Provide Config Files and Imported Targets for CMake. (1 reply)

Haowei Hsu — Wed, 02 Nov 2022 12:47:08 +0000

It is an upcoming trend to link libraries with an IMPORTED library targets when using CMake.
However, according to my observation, MySQL-Connector/C (libmysqlclient) doesn't prepare a Config Files for find_package().
Therefore, some projects or users may need to design their own Module Files called "FindMySQL.cmake" as an alternative solution.

The followings are the "FindMySQL.cmake" that I found:

- SOCI: https://github.com/SOCI/soci/blob/master/cmake/modules/FindMySQL.cmake
- VTK: https://github.com/Kitware/VTK/blob/master/CMake/FindMySQL.cmake
- Debian: https://sources.debian.org/src/mysql-connector-c%2B%2B/1.1.12-4/FindMySQL.cmake/
- kexi: https://github.com/KDE/kexi/blob/master/cmake/modules/FindMySQL.cmake
- poco: https://github.com/pocoproject/poco/blob/master/cmake/FindMySQL.cmake
- sqlpp11: https://github.com/rbock/sqlpp11/blob/main/cmake/FindMySQL.cmake

However, their IMPORTED library targets differ, and some of them doesn't even define it. For example:

- MySQL::MySQL
- MySQL::client

I hope MySQL can provide an official Config Files, for example "MySQLConfig.cmake",
and then define an official IMPORTED library target for MySQL-Connector/C (libmysqlclient)

BTW, I noticed that there is a comment noted in MySQL-Connector/C++ project.

- Link: https://github.com/mysql/mysql-connector-cpp/blob/8.0.31/jdbc/CMakeLists.txt#L139
- Comment: Arrange for MySQL::client to refer to the static library

Does it mean that MySQL official is preparing to do so and already decided to name its official IMPORTED target name as "MySQL::client"?

How to build mysqlclient.lib 5.7 without MSVCR120 dependency (3 replies)

Adrián G. — Mon, 22 Aug 2022 14:05:18 +0000

In the docs here (https://dev.mysql.com/doc/c-api/5.7/en/c-api-building-clients.html), it's stated that for MySQL Community versions 5.7.18, VS2013 redistributable is needed for applications, which means an extra dependency is generated.

I basically look for an updated MySQL 5.7.30+ client static library that has no MSVCR120.dll dependency (unless it comes with Windows 10 by default, which I'd be fine with, and someone might know).

However, in the docs it's implied that this dependency isn't needed for Commercial MySQL distributions.

Does anyone have an idea on how to compile a MySQL client static library without that dependency on Windows? So far I've been forced to use the outdated 6.1.9 client library (old versioning), which doesn't have that dependency and doesn't even require my wrapping program to match the Runtime Library option from Visual Studio (/MT, /MD), etc. Isn't it just possible to produce an updated static client library with the flexibility that old library versions had?

my_global.h, my_getopt.h, etc missing from MySQL 8 devel (1 reply)

John Wythe — Tue, 19 Jul 2022 07:10:11 +0000

I have a C program that used to compile with MySQL versions 3.23 to 5.5

I am trying compile it with MySQL 8. my_global.h, my_getopt.h and a few other header files are not included in the mysql-devel package.

I can compile fine with mariadb-devel.

What is the best way to get around this problem. Is it okay to compile with mariadb-devel and run with libmysqlclient.so from MySQL 8.

Are there replacement header files for MySQL 8 that provide the functions provided by my_getopt.h and my_global.h?

How to build MySQL 8.0 C API (libmysqlclient) (no replies)

Edwin Desouza — Tue, 12 Jul 2022 15:47:30 +0000

How to build MySQL 8.0 C API (libmysqlclient)
- https://lefred.be/content/how-to-build-mysql-8-0-c-api-libmysqlclient/

Is it ok that high version libmysqlclient.a to connect low version mysql? (2 replies)

hello okay — Thu, 28 Jul 2022 13:55:29 +0000

libmysqlclient.a version is 8.0.25
mysql version is 8.0.18

Not consisent result about mysql_stmt_execute and mysql_stmt_errno. (2 replies)

hello okay — Thu, 28 Jul 2022 14:39:32 +0000

Mysql version: 8.0.18

What's the reason of the result of mysql_stmt_execute not equal zero, but mysql_stmt_errno return zero?

According to doc, https://dev.mysql.com/doc/c-api/8.0/en/mysql-stmt-errno.html,
An error code value. Zero if no error occurred.

If result of mysql_stmt_execute not equal zero, it means fail to call mysql_stmt_execute, but mysql_stmt_errno return zero, this conflicts.

After kill query, mysql_stmt_close() hangs for prepared stmt (4 replies)

Sebastien FLAESCH — Mon, 01 Aug 2022 14:52:58 +0000

Since MySQL 5.7 SQL interruption is broken in our application.

Did you ever CTRL-C a long running query with mysql command line tool? It works, because mysql.cc uses mysql_real_query(), but when using mysql_stmt_prepare() / mysql_bind_param() / mysql_stmt_execute() as our application there is a problem.

Just installed 8.0.29 and the problem gets worse: First it was limited to long running SELECT statements, now (since 8.0.x) UPDATE waiting for a lock is also broken...

Just giving a heads up here because I don't get much help on the reported bug ticket.

All details with sample program here:

https://bugs.mysql.com/bug.php?id=84470

BR
Seb

Is there a way to get the code for the mySQL-Connector-C (3 replies)

Igor Korot — Tue, 12 Jul 2022 15:52:25 +0000

Hi,
Seems there is no possibility to download the code for the latest 8.0 version of the mySQL-Connector-C.

I can copy the code from my Linux box and build it, but I don't want to play with the line ending..

I would greatly appreciate any pointers on how to get the version of the Connector 8.0.25 (same as on my *nix box) for Windows and build it.

As someone else pointed out - it is incompatible with the previous version and so I can't use the same code on both OSes.

Thank you.

C API Connector for WIN32 missing. (1 reply)

Stefan Mühlbacher — Tue, 19 Jul 2022 07:28:15 +0000

Unfortunately in the standard installer there is not included the C API Connector 8.0 for Win32.
Unfortunately the last C API Connector 6.1.11 has got incompatible to 8.0. since one of the last updates.
So is there no possibility to get an up to date C-API connector for Win32 in the future?

The last C API Connector 6.1.11 is no more able to connect to the latest 8.0 version, this happened somewhere between 8.0.22 and 8.0.26.

Error message: 'SSL connection error: unknown error number'

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near (1 reply)

Mike Kala — Sat, 26 Feb 2022 17:18:47 +0000

Hello Team,
I did run my script in MySQL Workbench 8.0.26 to create a very simple procedure using MySQL Common Table Expression (CTE)
in my local database it is working fine.
The issue is when I run the same script in the Hosting server database ( Database client version: libmysql - mysqlnd 7.4.27 ), I am getting the following issue:
This is my script:
CREATE PROCEDURE assets()
BEGIN
WITH cte_assets AS ( SELECT * FROM assets )
SELECT id, assetnum, location FROM cte_assets;
END;
This is the issue :
MySQL said: Documentation
#1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'cte_assets AS ( SELECT * FROM assets )
SELECT id, assetnum, location FROM cte_' at line 3

Can you please help on this issue?
Thank you and have a great day

libcrypto.so.10 linker error (1 reply)

anindya roy — Tue, 19 Jul 2022 07:31:21 +0000

while compiliing my program using mysql community library on centos 7, I got the following error, kindly help.
----------------------------------
/usr/bin/ld: /usr/lib64/libcrypto.so.10 symbol number 2855 references nonexistent SHT_SYMTAB_SHNDX section
/usr/lib64/libcrypto.so.10: error adding symbols: No such file or directory
-------------------------------------

I done following things to remove the error
1. I have downgrade mysql from 8.0.28 to 8.0.26
2. I have checked presence of libcrypto.so.10 in /usr/lib64
3. I have tried to downgrade openssl but not successful

My present version of openssl is openssl-libs-1.0.2k-24.el7_9.x86_64.

Thanks in advance.

Anindya

Does libmysqlclient support openssl1.1? (3 replies)

hello okay — Mon, 05 Jul 2021 12:08:37 +0000

If not, how can i do?

Versioning with Connector/C and MySql (1 reply)

chris j — Tue, 25 May 2021 17:21:17 +0000

I'm working on an application that is using connector-c-6.1.6. The database I'm using is MySql version 5.7.21.

I am debating upgrading to the latest MySql version - MySql Community Server 8.0.24, at the time of writing.

Will I have to upgrade my code to use a more recent version of Connector/C or is the API still compatible? Having trouble finding this information in documentation.

Thanks in advance.

How to distinguish the response of Lost connection to MySQL server? (5 replies)

hello okay — Fri, 07 May 2021 15:13:35 +0000

If mysql connection doesn't interact with mysql long time, then using libmysql api will lead to Lost connection to MySQL server error?
But if i set mysql_options with MYSQL_OPT_READ_TIMEOUT and execute a time consuming query, it will report the same Lost connection to MySQL server error.

Then the question is how to distinguish these different cases?

Using mysql C Api affects memory in my executing program (2 replies)

Francesco Di Fusco — Mon, 19 Apr 2021 07:13:04 +0000

Hello, I wrote a Cgi program in C under Linux to read some data to save to a mysql database. Before inserting data in the proper table I show the read data in a table. I noticed something strange. When I display the read data in the table
without connecting to mysql, using these instructions
/* Connect to database */
if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
fprintf(stderr, "%s\n", mysql_error(conn));
exit(1);
}
the table is diplayed correctly. But if I connect to the database, the connection works correctly, but something strange happens in the table. The last cell displays a dirty value

20 16 0bin" id="82"??l

20 is the number of the row, 16 is nhe number of the column, 0 is its value, but bin" id="82"??l i do not know what it is

How to convert date to string? (3 replies)

James Leo — Fri, 19 Mar 2021 08:54:56 +0000

Hi,
It's my first time to use the connector 8. (I'v installed the x64 MySQL, but there are some lib in 32bit, so I'd build the exe in 32 bit by VS2015. and I can't find the libmysql bin file (32bit) to use. )
In last project (use x64 libmysql) ,it's easy to read and convert the DATE field from table.
Now work with connector, there is something differ from stand MySql 's query.
Refer to the doc, the DATE value will be convert to number, but I don't konw what number it will be.
Is the number like '20200909' or just a timestamp?
I tried the follow function: ( col =3, DATE type )

mysqlx_get_uint(row, 3, &ndate); --> this return the value:
ndate 14757395258967641292 unsigned __int64

Is this the senconds? or ticks? unlike the time function's result:
time_t now;
time(&now); -->now 1615885732 __int64

How to convert the int value to date string?

Thanks

James

MYSQL_FIELD -- How to know which kind of GEOMETRY? (1 reply)

Seth Willits — Thu, 11 Feb 2021 09:29:56 +0000

After having executed a query and getting the fields from the result with `mysql_fetch_fields`, if a particular field is said to be a `MYSQL_TYPE_GEOMETRY`, how do we know what *kind* of geometry it is? If it's POINT type, for instance, there seems to be no way to know this from the query result's MYSQL_FIELD itself?

libmysqlclient on Apple silicon (2 replies)

Firitia V — Fri, 15 Jan 2021 15:14:09 +0000

Could you compile the latest libmysqlclient for Apple silicon and publish it ?

mysql c connector 6.1.11 client to a mysql 8 server connection (1 reply)

reda guernane — Tue, 25 May 2021 17:31:09 +0000

hi

I have a Mysql server 8.0.21 running on ubuntu 20.04. I also have on this latter a win7 32bit VB guest machine connected via a host-only adapter to the host.

On the guest machine I have a basic C program using the c connector 6.1.11 to try to connect to the server running on the host, here's the code:

#include
#include

MYSQL *conn;
unsigned long version = 1;
int main()
{
conn = mysql_init ( NULL );
if(mysql_real_connect ( conn, "169.254.128.100", "myuser",
"mypass", "my_schema", 3306, NULL, 0 )==NULL){
fprintf(stderr, "%s\n", mysql_error(conn));
}
mysql_close ( conn );
return 0;
}

running the program gives me the error:
SSL connection error: unknown error number

I checked that :
1- I can connect fine using the ODBC DSN from the guest
2- the server has no SSL configured by default, the server status command tells me "SSL not in use"
3- i could swear it was working using Qt's QMYSQL plugin (which just wraps the c api) before upgrading my machine from 18.O4 to 20.04, in either case using the 8.0.21 version.

thanks