MySQL Forums - Source, Builds, Binaries

Using JOIN, GROUP BY, and HAVING in MySQL (no replies)

sanwirja sanwirja — Mon, 20 Oct 2025 03:11:09 +0000

Hey everyone 👋
Let’s talk about how to properly use JOIN, GROUP BY, and HAVING in MySQL.
These three can be confusing at first, especially when you start combining multiple tables.

JOIN lets you pull data from related tables.

GROUP BY groups the result based on one or more columns.

HAVING works like WHERE, but it’s used to filter aggregated results (SUM(), COUNT(), etc.).
How do you usually use these in your projects? Any tips to keep queries efficient?

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

Sebastien FLAESCH — Tue, 15 Jul 2025 14:15:28 +0000

Hello,

I have asked an important question in the Connector/C (libmysqlclient) forum, but did not see any reaction for now... so I reference it here:

https://forums.mysql.com/read.php?168,740892,740892

Can someone give an answer please?

Thanks!
Seb

Trying to build from source fails (2 replies)

Chris Quayle — Thu, 22 May 2025 00:04:29 +0000

Hi,

We had an old mysql-57 server running under FreeBSD 12. The data set was
on a different machine, accessed via an nfs ro mount. The machine failed,
with the backups lost. Spun up another Freebsd 12 machine, but the
packages for that version os are no longer available. Tried building
5.7 from port tree, but many of the dependencies are gone, leaving the port
unbuildable.

I have the mysql 80 package installed, but doesn't like the old 5.7
data set, and there seems t0 be no way to convert the old data set to later
format.

Downloaded the source package from mysql, and have all the needed packages
installed. C-make completes ok, and make starts well, but then stops with:

In file included from /usr/local/src/mysql/mysql-5.7.10/sql/rpl_channel_service_interface.cc:21:
In file included from /usr/local/src/mysql/mysql-5.7.10/sql/rpl_mi.h:23:
In file included from /usr/local/src/mysql/mysql-5.7.10/sql/log_event.h:39:
/usr/local/src/mysql/mysql-5.7.10/sql/sql_class.h:2103:8: error: no template named 'auto_ptr' in namespace 'std'
2103 | std::auto_ptr m_transaction;
| ~~~~~^
/usr/local/src/mysql/mysql-5.7.10/sql/sql_class.h:1405:41: error: cannot initialize object parameter of type 'const Query_arena' with an expression of type 'const THD'
1405 | { DBUG_ASSERT(0); return Query_arena::is_stmt_prepare(); }
| ^~~~~~~~~~~~~~~
/usr/local/src/mysql/mysql-5.7.10/sql/sql_class.h:1408:41: error: cannot initialize object parameter of type 'const Query_arena' with an expression of type 'const THD'
1408 | { DBUG_ASSERT(0); return Query_arena::is_stmt_prepare_or_first_sp_execute(); }
| ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/usr/local/src/mysql/mysql-5.7.10/sql/sql_class.h:1411:41: error: cannot initialize object parameter of type 'const Query_arena' with an expression of type 'const THD'
1411 | { DBUG_ASSERT(0); return Query_arena::is_stmt_prepare_or_first_stmt_execute(); }
| ^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
/usr/local/src/mysql/mysql-5.7.10/sql/sql_class.h:1414:41: error: cannot initialize object parameter of type 'const Query_arena' with an expression of type 'const THD'
1414 | { DBUG_ASSERT(0); return Query_arena::is_conventional(); }
| ^~~~~~~~~~~~~~~
/usr/local/src/mysql/mysql-5.7.10/sql/sql_class.h:3943:12: error: cannot initialize object parameter of type 'Query_arena' with an expression of type 'THD'
3943 | *p_db= strmake(m_db.str, m_db.length);
| ^~~~~~~
2 warnings and 6 errors generated.
gmake[2]: *** [sql/CMakeFiles/slave.dir/build.make:331: sql/CMakeFiles/slave.dir/rpl_channel_service_interface.cc.o] Error 1
gmake[2]: Target 'sql/CMakeFiles/slave.dir/build' not remade because of errors.
gmake[1]: *** [CMakeFiles/Makefile2:7247: sql/CMakeFiles/slave.dir/all] Error 2
[ 15%] Building CXX object storage/partition/CMakeFiles/partition.dir/ha_partition.cc.o
^Cgmake[2]: *** [storage/partition/CMakeFiles/partition.dir/build.make:79: storage/partition/CMakeFiles/partition.dir/ha_partition.cc.o] Interrupt
gmake[1]: *** [CMakeFiles/Makefile2:3097: storage/partition/CMakeFiles/partition.dir/all] Interrupt
gmake: *** [Makefile:166: all] Interrupt

Real time embedded systems programmer here, little or no C++, and would not
know where to start looking to fix that. Any suggestions, or ideas, would be
appreciated.

Thanks,

Chris

mysql connector c++ 32 bit (no replies)

Michael Heng — Sun, 02 Mar 2025 16:37:41 +0000

Hello,

I tried multiple versions (9.2.0, 8.1.0 and 8.0.33) of mysql connector c++ compiled from source code on windows 11 x64. But I got problem with compilation with jdbc.

Following cmake command and arguments I use to build

cmake -G "Visual Studio 17" -A Win32 -DCMAKE_INSTALL_PREFIX:PATH=C:\mysql\bin -DWITH_SSL=C:\openssl -DWITH_MYSQL="C:\Program Files\MySQL\MySQL Server 8.0" -DWITH_JDBC=ON -DCMAKE_BUILD_TYPE=Debug

I need to add WITH_MYSQL, I get error during compilation. But now the real conflict ist, that there is no 32 bit of MySQL Server available in MySQL Installer. I tried also to set MySQL source code path according to documentation of mysql connector c++, but DepFindMySQL.cmake, which is located in mysql-connector-c++-9.2.0-src\jdbc\cmake, say WITH_MYSQL would be the path of MysQL installation.

How could I compile connector c++ in 32 bit without 32 bit of MySQL Server?

Build MySql connector C++ from source (1 reply)

Sławomir Piernikowski — Mon, 17 Mar 2025 17:33:58 +0000

Hi
I am trying to build mysql c++ connector from source, version 8.4.0.
I am using CMake GUI to configur the mysql connector C++ , but I have some issues: hereunder I attached what cmake pinted when I tryied to configure the connector:
=== Booststrap ===
-- generator: Visual Studio 17 2022
-- build type: Debug
-- ----
CMake Deprecation Warning at CMakeLists.txt:34 (cmake_minimum_required):
Compatibility with CMake < 3.10 will be removed from a future version of
CMake.

Update the VERSION argument value. Or, use the ... syntax
to tell CMake that the project requires at least but has been updated
to work with policies introduced by or earlier.

-- Selecting Windows SDK version 10.0.22621.0 to target Windows 10.0.26100.

-- Configuring done (0.1s)

-- Generating done (0.0s)

-- Build files have been written to: P:/MYSQL_CONN_DEST/platform-cache

=== Booststrap done ===
Selecting Windows SDK version 10.0.22621.0 to target Windows 10.0.26100.
BIG_ENDIAN: 0
Building version 8.4.0
Building on system: Windows-10.0.26100 (AMD64)
Using cmake generator: Visual Studio 17 2022
Using toolset:
Building 64bit code
Building shared connector library
Looking for SSL library.
Using OpenSSL version: 3.0.16
-- found required X509 extensions
CMake Deprecation Warning at cdk/CMakeLists.txt:31 (CMAKE_MINIMUM_REQUIRED):
Compatibility with CMake < 3.10 will be removed from a future version of
CMake.

Update the VERSION argument value. Or, use the ... syntax
to tell CMake that the project requires at least but has been updated
to work with policies introduced by or earlier.

CMake Deprecation Warning at cdk/CMakeLists.txt:33 (cmake_policy):
Compatibility with CMake < 3.10 will be removed from a future version of
CMake.

Update the VERSION argument value. Or, use the ... syntax
to tell CMake that the project requires at least but has been updated
to work with policies introduced by or earlier.

Configuring CDK as part of MySQL_CONCPP project
Setting up RapidJSON.
Skipping second declaration of config option: THROW_AS_ASSERT (found in: P:/mysql-connector-c++-8.4.0-src/cdk/CMakeLists.txt)
Setting up Protobuf.
== configuring external build of protobuf
-- sources at: P:/mysql-connector-c++-8.4.0-src/cdk/extra/protobuf
-- generator: Visual Studio 17 2022
-- option CMAKE_BUILD_TYPE: Debug
-- option CMAKE_SYSTEM_NAME: Windows
-- option CMAKE_SYSTEM_VERSION: 10.0.26100
-- option CMAKE_SYSTEM_PROCESSOR: AMD64
-- option CMAKE_C_COMPILER: C:/Program Files/Microsoft Visual Studio/2022/Community/VC/Tools/MSVC/14.42.34433/bin/Hostx64/x64/cl.exe
-- option CMAKE_CXX_COMPILER: C:/Program Files/Microsoft Visual Studio/2022/Community/VC/Tools/MSVC/14.42.34433/bin/Hostx64/x64/cl.exe
-- option MSVC: 19.42.34435.0
-- ----
Not searching for unused variables given on the command line.

CMake Error at CMakeLists.txt:60 (cmake_minimum_required):
Compatibility with CMake < 3.5 has been removed from CMake.

Update the VERSION argument value. Or, use the ... syntax
to tell CMake that the project requires at least but has been updated
to work with policies introduced by or earlier.

Or, add -DCMAKE_POLICY_VERSION_MINIMUM=3.5 to try configuring anyway.

-- Configuring incomplete, errors occurred!

CMake Error at cdk/cmake/dependency.cmake:325 (message):
Failed to configure external build of protobuf: 1
Call Stack (most recent call first):
cdk/cmake/dependency.cmake:204 (add_ext_build_targets)
cdk/cmake/DepFindProtobuf.cmake:54 (add_ext)
cdk/cmake/dependency.cmake:47 (include)
cdk/protocol/mysqlx/CMakeLists.txt:29 (find_dependency)

Configuring incomplete, errors occurred!

The problem is here with Protobuf. Cmake foud the Protobuf source here:
sources at: P:/mysql-connector-c++-8.4.0-src/cdk/extra/protobuf
but smoething went wrong.
What is the problem????

Unit Test Bgc_ticket_manager_test.Several_tickets_test failing on aarch64 (no replies)

Conrad burger — Thu, 20 Feb 2025 08:30:37 +0000

Unit test Bgc_ticket_manager_test.Several_tickets_test is failing on aarch64.

When compiling MySQL 8 on aarch64 and running the unit tests one of them fails.
On x86-64 it succeeds. I have tested this on 8.0.36/40/41 and they all fail.

Error:
[----------] 1 test from Bgc_ticket_manager_test
[ RUN ] Bgc_ticket_manager_test.Several_tickets_test

Start 17: rpl_channel_credentials
...

99% tests passed, 1 tests failed out of 89

Total Test time (real) = 1894.03 sec

The following tests FAILED:
16 - merge_large_tests (Timeout)
Errors while running CTest
make: *** [Makefile:91: test] Error 8

To reproduce:
--------------------------
Launch an aarch64 EC2 instance, for example a t4g.

wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.41.tar.gz
tar -xzf mysql-8.0.41.tar.gz

sudo yum install -y cmake.aarch64 gcc-c++.aarch64 gcc.aarch64 openssl-devel.aarch64 ncurses-devel.aarch64 readline-devel.aarch64 libcurl-devel libtirpc-devel rpcgen

(cd ~ && rm -rf build && cmake -S ./mysql-8.0.41 -B ./build -DCMAKE_BUILD_TYPE=RelWithDebInfo -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DDOWNLOAD_BOOST=1 -DWITH_BOOST=.build/boost -DWITH_ROCKSDB=OFF -DWITH_PERCONA_AUDIT_LOG_FILTER=OFF -DWITH_ROUTER=OFF -DWITH_NDB=OFF -DWITH_NDBCLUSTER_STORAGE_ENGINE=OFF -DWITH_LDAP=OFF -DWITH_AUTHENTICATION_LDAP=OFF -DWITH_PERCONA_AUTHENTICATION_LDAP=OFF -DWITH_AUTHENTICATION_KERBEROS=OFF -DWITH_COREDUMPER=OFF && \
cd build && \
make -j$(nproc) &&\
make CTEST_OUTPUT_ON_FAILURE=1 test) 2>&1 | tee mysql-8.0.41.build.$(date '+%Y%m%d%H%M%S')
--------------------------

However, when creating a debug build (-DCMAKE_BUILD_TYPE=Debug) the unit test pass.

Has anyone come across this?

Any help to figure out why this is happening would really be appreciated.

Why does at least the MySQL 8.4 el9.x86_64 RPM package depend on the obsolete net-tools package? (no replies)

Karel Ziegler — Mon, 10 Feb 2025 21:32:24 +0000

Hello,

Why does at least the MySQL 8.4 el9.x86_64 RPM package depend on the obsolete net-tools package (on obsolete tools like arp, ifconfig, route, etc.)?

viz https://github.com/mysql/mysql-server/blob/8.4/packaging/rpm-oel/mysql.spec.in#L281

Thank you in advance and best regards
Karel Ziegler

MySQL: Defining release type (no replies)

Edwin Desouza — Mon, 28 Oct 2024 22:49:20 +0000

Defining release type

The MySQL server source code repository contains a file called MYSQL_VERSION defining the version number of the current release. We have added another field to this file called MYSQL_VERSION_MATURITY. Below is a sample file for an update release of 8.4.1, which is an LTS release:

MYSQL_VERSION_MAJOR=8
MYSQL_VERSION_MINOR=4
MYSQL_VERSION_PATCH=1
MYSQL_VERSION_EXTRA=-u1
MYSQL_VERSION_MATURITY="LTS"

https://blogs.oracle.com/mysql/post/determine-whether-lts-release-or-not

Mysql connector odbc from source (no replies)

Anudari Orgilmaa — Wed, 16 Oct 2024 08:13:11 +0000

Hello, i'm trying to install mysql-connector-odbc from source .but I got following error during make phase. Do you have any ideas?
[ 65%] Linking CXX executable ../bin/myodbc-installer
/usr/bin/ld: CMakeFiles/myodbc-installer.dir/myodbc-installer.cc.o: in function `print_odbc_error(void*, short)':
myodbc-installer.cc:(.text+0x1c9): undefined reference to `SQLGetDiagRec'
/usr/bin/ld: CMakeFiles/myodbc-installer.dir/myodbc-installer.cc.o: in function `list_datasources()':
myodbc-installer.cc:(.text+0x5f50): undefined reference to `SQLAllocHandle'
/usr/bin/ld: myodbc-installer.cc:(.text+0x5fb1): undefined reference to `SQLSetEnvAttr'
/usr/bin/ld: myodbc-installer.cc:(.text+0x5fef): undefined reference to `SQLFreeHandle'
/usr/bin/ld: myodbc-installer.cc:(.text+0x6060): undefined reference to `SQLDataSources'
/usr/bin/ld: myodbc-installer.cc:(.text+0x60b0): undefined reference to `SQLFreeHandle'
/usr/bin/ld: myodbc-installer.cc:(.text+0x60cb): undefined reference to `SQLFreeHandle'
collect2: error: ld returned 1 exit status
make[2]: *** [installer/CMakeFiles/myodbc-installer.dir/build.make:100: bin/myodbc-installer] Error 1
make[1]: *** [CMakeFiles/Makefile2:491: installer/CMakeFiles/myodbc-installer.dir/all] Error 2
make: *** [Makefile:156: all] Error 2

can we create single deb package for mysql8.4 version (no replies)

ramesh ss — Wed, 19 Jun 2024 06:05:11 +0000

r/mysql-common_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-client-plugins_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/libmysqlclient23_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-client_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-client-core_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-client_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/libmysqlclient-dev_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-server_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-server-core_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-server-debug_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-test_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-community-test-debug_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-server_8.3.0-1ubuntu22.04_amd64.deb"
"$package_dir/mysql-testsuite_8.3.0-1ubuntu22.04_amd64.deb"
I installed all these packages for MySQL 8.3. Could someone maybe suggest me with a package that would install MySQL 8.4 all in one?

Disk space requirement when installing from source in a Ubuntu image (no replies)

Mithun Vaidhyanathan — Sun, 19 May 2024 03:44:14 +0000

Hello,

I am trying to install mysql from source. My reference point is https://dev.mysql.com/doc/refman/8.0/en/source-installation.html. I am using a Ubuntu x86_64 image on VirtualBox. I allotted 25GB disk space, the default one.

Linux my-VirtualBox 6.8.0-31-generic #31-Ubuntu SMP PREEMPT_DYNAMIC Sat Apr 20 00:40:06 UTC 2024 x86_64 x86_64 x86_64 GNU/Linux

I ran the cmake command without too many issues - saw some checks as not found, and would progressively try addressing them, but the command itself finished without an error code. The cmake command I ran:

cmake ../ -DBUILD_CONFIG=mysql_release -DCMAKE_INSTALL_PREFIX=/home/me/mysql-installer -DCPACK_MONOLITHIC_INSTALL=1 -DWITH_DEBUG=1 -DWITH_BOOST=/home/me/installers/boost_1_82_0

I then ran the make command, which failed saying that there isn't enough disk space. At the time it failed, the folder I was working on had grown to 12GB. I know one can't say how big an actual DB can grow to, but my question is about the barebones installation from source. How much disk space is required to do so?

Thanks,
Mithun

How do I build from source for plugin development? (3 replies)

Peter Orlowski — Wed, 07 May 2025 18:02:49 +0000

I want to create a server-side authentication plugin for MySQL v8.0, so I am trying to build MySQL from source in order to install the plugin header files.

Here is how I compiled and installed:

sudo apt update
sudo apt install build-essential libncurses-dev libssl-dev zlib1g-dev cmake git libboost-all-dev pkg-config bison
git clone https://github.com/mysql/mysql-server.git
cd mysql-server/sql
bison sql_yacc.yy -o sql_yacc.cc -Hsql_yacc.hh
bison sql_hints.yy -o sql_hints.yy.cc -Hsql_hints.yy.hh
cd ..
mkdir bld
cd bld
cmake ..
make
make install

However, I am not seeing the server-side header files anywhere. I tried searching for them with find:

sudo find /usr/local/mysql -name "plugin*"

There is no plugin.h or plugin_auth.h. How do I properly install them?

Cannot compile gen_lex_token.cc (1 reply)

Peter Orlowski — Fri, 12 Apr 2024 18:17:02 +0000

I am working on compiling MySQL from source so that I can start developing a server-size plugin. This is my first time programming with MySQL so please bear with me. I have been following the documentation: https://dev.mysql.com/doc/refman/8.0/en/source-installation.html

When I run make, it fails on gen_lex_token.cc saying "‘YYUNDEF’ was not declared in this scope" for line 242 and "no matching function for call to ‘range::range()’" for line 250.

How can I resolve this?

Rows scanned per query (1 reply)

loga a — Thu, 22 Feb 2024 14:16:33 +0000

Is there any way to find the rows scanned per query.

NOTE : I Don't want to use EXPLAIN query.

Intention : My Intention is used to calculate the rows scanned per request in our product.

So kindly help to find this!!

5.7.43 on Ubuntu. Start option --log-error works abnormally, causing mysqld start failed (no replies)

S jevon — Mon, 30 Oct 2023 03:14:57 +0000

I don't know why option --log-error works uncorrectly, following cmd shows how i start mysqld and debug

All Started by
jevon@Kubuntu:/mnt/WorkSpace/Source_Code/mysql-server-5.7$ ./Build/sql/mysqld --user=jevon --sql-mode=NO_AUTO_CREATE_USER --port=9200 --socket=/mnt/WorkSpace/Source_Code/mysql-server-5.7/Build/Runtime_Location/server.socket --pid-file=/mnt/WorkSpace/Source_Code/mysql-server-5.7/Build/Runtime_Location/server.pid --basedir=/mnt/WorkSpace/Source_Code/mysql-server-5.7/Build/Runtime_Location --datadir=/mnt/WorkSpace/Source_Code/mysql-server-5.7/Build/Runtime_Location/data --lc-messages-dir=/mnt/WorkSpace/Source_Code/mysql-server-5.7/Build/sql/share
2023-10-30T02:31:07.925426Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-10-30T02:31:07.927278Z 0 [Warning] Insecure configuration for --secure-file-priv: Location is accessible to all OS users. Consider choosing a different directory.
2023-10-30T02:31:07.927311Z 0 [Note] ./Build/sql/mysqld (mysqld 5.7.43-debug) starting as process 78003 ...
2023-10-30T02:31:07.928965Z 0 [ERROR] Could not open file '/var/log/mysql/error.log' for error logging: Permission denied
2023-10-30T02:31:07.928999Z 0 [ERROR] Aborting

2023-10-30T02:31:07.943199Z 0 [Note] Binlog end
2023-10-30T02:31:07.961609Z 0 [Note] ./Build/sql/mysqld: Shutdown complete

This is how i start the second instance mysqld which is Builted when i already have an existing mysqld8.0 running
This Log : [ERROR] Could not open file '/var/log/mysql/error.log' is caused by log-error option i think.
I want to log error message on stderr so i did't create error.log and did't use --log-error

I Checked mysqld.cc:3846（maybe）
bool log_errors_to_file = !opt_help && (log_error_dest != disabled_my_option);

According to the comment above :
/*
Enable old-fashioned error log, except when the user has requested
help information. Since the implementation of plugin server
variables the help output is now written much later.

log_error_dest can be:
disabled_my_option --log-error was not used or --log-error=
"" --log-error without arguments (no '=')
filename --log-error=filename
*/
i didn't used --log-error option, so variable: log_error_dest should be equal to variable: disabled_my_option whick is '0' and cause variable: log_errors_to_file = false.
But i checked variable: log_error_dest is still /var/log/mysql/error.log which is the default value of this option.
And i also tryed "--log-error=", but still /var/log/mysql/error.log
It does't work correctly

However i used --log-error="0", it works well
mysqld started with no problems.Because variable: log_errors_to_file = false and aviod open errorlogs.

So why does " --log-error was not used or --log-error=" doesn't work?
Is there anythis i did wrong or missing some step?
(I use vscode to debug and using args "--log-error=\"0\"",it works well)
Plz give me some advice Thx

MySQL server on iPhone (no replies)

Molly Anderson — Wed, 13 Sep 2023 17:51:09 +0000

I’ve seen mySQL run on just about anything, has anybody developed a package for a non-jailbreak iPhone?

Having one terabyte of memory, it would be nice to be able to do my SQL directly on an iPhone.

Compilation errors on Debian 11 armhf (2 replies)

Sergey Korshak — Thu, 31 Aug 2023 11:49:59 +0000

I'm trying to build ODBC Connector from source from the mysql/mysql-connector-odbc repo on Debian 11.7 on the ARM platfrom (armhf, 32-bit).

Database related packages I've installed to have mysql headers:
default-libmysqlclient-dev libmariadb-dev libmariadb-dev-compat libmariadb3 libmysql++-dev libmysql++3v5 mariadb-common

My cmake options:

cmake -G "Unix Makefiles" -DWITH_UNIXODBC=1 -DDISABLE_GUI=1 -DMYSQL_INCLUDE_DIR=/usr/include/mariadb

After running make I immediately get an error:

In file included from /home/admin123/repos/mysql-connector-odbc/util/stringutil.h:37,
                 from /home/admin123/repos/mysql-connector-odbc/util/stringutil.cc:36:
/home/admin123/repos/mysql-connector-odbc/util/../MYODBC_MYSQL.h:34:17: error: redeclaration of C++ built-in type 'bool' [-fpermissiv]
   34 | #define my_bool bool
      |                 ^~~~
/usr/include/mariadb/mysql.h:39:14: note: in expansion of macro 'my_bool'
   39 | typedef char my_bool;
      |              ^~~~~~~
make[2]: *** [util/CMakeFiles/myodbc-util.dir/build.make:76: util/CMakeFiles/myodbc-util.dir/stringutil.cc.o] Error 1
make[1]: *** [CMakeFiles/Makefile2:277: util/CMakeFiles/myodbc-util.dir/all] Error 2
make: *** [Makefile:156: all] Error 2

How to fix this?

Are you ready for MySQL 10? (no replies)

Edwin Desouza — Fri, 18 Aug 2023 17:05:59 +0000

Are you ready for MySQL 10?
- https://blogs.oracle.com/mysql/post/are-you-ready-for-mysql-10

Build MySQL 8 from the source rpm in OL9, OL8 (no replies)

Edwin Desouza — Thu, 10 Aug 2023 17:12:53 +0000

Build MySQL 8 from the source rpm in OL9
- https://blogs.oracle.com/mysql/post/build-mysql-8-from-the-source-rpm-in-ol9
- https://blogs.oracle.com/mysql/post/build-mysql-8-from-the-source-rpm-in-ol8
- https://blogs.oracle.com/mysql/post/build-mysql-8-from-the-source-rpm-in-ol7

MySQL tarball (no replies)

Edwin Desouza — Wed, 26 Jul 2023 16:27:55 +0000

https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-34.html#mysqld-8-0-34-feature

Packaging:

Beginning with this release, binary archive packages
- previously named using -el7-x86_64.tar and -el7-x86_64.tar.gz
- are now named using -linux-glibc2.17-x86_64.tar and -linux-glibc2.17-x86_64.tar.gz, respectively.

For example,
- if you used mysql-8.0.33-el7-x86_64.tar to install or upgrade to MySQL 8.0.33,
- you should use mysql-8.0.34-linux-glibc2.17-x86_64.tar for installing or upgrading to MySQL 8.0.34.

The naming change reflects the fact that these binaries are intended to be compatible with any Linux system using glibc2.17 or newer; this includes Enterprise Linux 7, EL8, and EL9.

mysql server 8.0.34 - no tarball anymore for LINUX in the download section (2 replies)

Davies Liu — Mon, 24 Jul 2023 08:35:29 +0000

Hello mysql binaries team,

in the past it was possible to download the inaries in tarball format (till version 8.0.33) for RHEL 7 LINUX x86, but since 8.0.34 it is not possible

Can you please a tarball for this, we have got lots of mysql instances using newer tarballs for updates) For enterprise version it is still possible to get the tarball version from oracle.com (!)..

OLD LINK for *33:

https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.33-el7-x86_64.tar.gz

Best regards,
Davies

Segmentation fault 5.7.38 compiled from source OEL 8 (2 replies)

Bobby Durrett — Thu, 22 Jun 2023 19:05:51 +0000

I am trying to compile 5.7.38 from source on Oracle Linux 8. The compile ran fine and the database is running but I get a segmentation fault logging in with the initial password:

[root@localhost mysql]# bin/mysql -vvvv -u root -p"4,R2%YuggA5j"
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.7.38

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Reading history-file /root/.mysql_history
Segmentation fault (core dumped)
[root@localhost mysql]#

Any ideas? Thanks!

Bobby

DATE_ADD + DATE_FORMAT (1 reply)

Alejandro Jose Goncalves Correia — Thu, 15 Jun 2023 10:35:03 +0000

Hello,

I have a code already made in Indusoft that executes a query in a mysql DB, it takes the values from the database and organizes them, finally these values are shown in an indusoft graph.

Every certain time a radiation record is stored in the database, every 6 minutes I think, of 3 radiation sensors with the date of the moment, the query that is done takes all the records of an hour, groups and averages them for that same hour, for example: 10:00, 10:06, 10:12, 10:18, 10:24, 10:30, 10:36, 10:42, 10:48, 10:54; groups them for the hour of 10:00, and then so for each hour. What I want is that instead of taking the records this way it does it from behind, for example: 09:06, 09:12, 09:18, 09:24, 09:30, 09:36, 09:42, 09:48, 09:54, 10:00; it groups them for the 10:00 time, since this is a correct standard.

The original code is as follows:
SELECT DATE_FORMAT(dm.fecha_lectura, '%m/%d/%Y %H:00:00.000') AS FECHA, round((avg(radiacion_1) + avg(radiacion_2) + avg(radiacion_3))/3,0) AS RADIACION FROM avanzalia.datos_meteo dm WHERE dm.nombre_planta = '" & plantaMeteo & "' and DATE_FORMAT(dm.fecha_lectura,'%Y-%m-%d %H:%i:%s.0') >= date_format(NOW() - INTERVAL 1 day,'%Y-%m-%d %07') and DATE_FORMAT(dm.fecha_lectura,'%H') not in (00,01,02,03,04,05,06) group by DATE_FORMAT(dm.fecha_lectura, '%m/%d/%Y %H:00:00.000') ORDER BY dm.fecha_lectura

I tried to modify the code unsuccessfully in this way, I put a DATE_ADD so that it would start taking the records 54 minutes earlier:
SELECT DATE_FORMAT(dm.fecha_lectura(DATE_ADD('%m/%d/%Y %H:00:00.000',INTERVAL -54 MINUTE), '%m/%d/%Y %H:00:00.000') AS FECHA, round((avg(radiacion_1) + avg(radiacion_2) + avg(radiacion_3))/3,0) AS RADIACION FROM avanzalia.datos_meteo dm WHERE dm.nombre_planta = '" & plantaMeteo & "' and DATE_FORMAT(dm.fecha_lectura(DATE_ADD('%m/%d/%Y %H:00:00.000',INTERVAL -54 MINUTE), '%m/%d/%Y %H:00:00.000') >= date_format(NOW() - INTERVAL 1 day,'%Y-%m-%d %07') and DATE_FORMAT(dm.fecha_lectura,'%H') not in (00,01,02,03,04,05,06) group by DATE_FORMAT(dm.fecha_lectura(DATE_ADD('%m/%d/%Y %H:00:00.000',INTERVAL -54 MINUTE), '%m/%d/%Y %H:00:00.000') ORDER BY dm.fecha_lectura

8.0.32: build fails with gcc 13 (no replies)

Tomasz Kloczko — Thu, 16 Mar 2023 02:46:25 +0000

Rebuild MySql.Data.DLL (no replies)

Dennis Wallace — Thu, 09 Mar 2023 18:22:28 +0000

I need to rebuild (to a different name) MySql.Data.DLL so I can use a newer version but still retain the use of existing older version.

I would like to rebuild MySql.Data.DLL Version 8.0.32 to be MySql.Data.8032.DLL but I am having problems reconciling all the errors.

Using Windows 10, VS2022. Is there any documentation on how to do this?

How should I build the official binary universal installer like mysql？ (1 reply)

liaoronghui Liao — Mon, 27 Feb 2023 08:12:10 +0000

How should I build the official mysql like binary universal installer. The binary package I compiled and built in Ubuntu 18.04 is missing various library files when placed in other Linux distributions.

Error in library "libmysqlclient.so" (3 replies)

Renan Renan — Mon, 12 Dec 2022 10:07:56 +0000

Hello.. when including the library "libmysqlclient.so" glibc 2.17 ARM 64bits in my project an error occurs:

dlopen failed: library "libpthread.so.0" not found: needed by

The "libmysqlclient.so" library requires this other library.

How to solve? Where to find?

MySQL v8.0: Unable to run MySQL binary (2 replies)

Strong Valves — Tue, 11 Oct 2022 17:16:57 +0000

At Strong Valves, I just updated our MySQL server from v5.7 to v8.0.21.
The upgrade went well. Because our installation is binary, I need to add fresh v8.0 binaries to /usr/bin. After that, I execute the following command to verify the mysql version and login to mysql. I'm receiving the following error.

mysql —version
mysql: error when loading shared libraries: libcrypto.so.1.1: cannot open shared object file: There is no such file or directory

Note: I may login and view version information. ./mysql —version

CentOS Linux release 7.3.1611 (Core)

libaio-0.3.109-13.el7.x86 64 was installed.

ll /usr/lib64/libssl* /usr/lib64/libssl3.so /usr/lib64/libssl.so -> libssl.so.1.0.2k /usr/lib64/libssl.so.10 -> libssl.so.1.0.2k /usr/lib64/libssl.so.1.0.2k

Could someone kindly tell me what the problem is in my case?

Getting a build failure (no replies)

Igor Korot — Sun, 24 Jul 2022 01:44:39 +0000

Hi,
I am getting a build failure.

Here are 2 log from running CMake thing:

C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin>cmake -DWITHOUT_
SERVER=ON -DWITH_UNIT_TESTS=OFF -DCMAKE_BILD_TYPE=Debug ..
-- Building for: Visual Studio 15 2017
CMake Deprecation Warning at CMakeLists.txt:44 (CMAKE_POLICY):
  The OLD behavior for policy CMP0026 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Deprecation Warning at CMakeLists.txt:45 (CMAKE_POLICY):
  The OLD behavior for policy CMP0045 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Deprecation Warning at CMakeLists.txt:46 (CMAKE_POLICY):
  The OLD behavior for policy CMP0042 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


-- Running cmake version 3.23.1
-- Found Git: C:/Program Files/Git/cmd/git.exe (found version "2.35.0.windows.1"
)
-- Configuring with MAX_INDEXES = 64U
^C
C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin>cmake -DWITHOUT_
SERVER=ON -DWITH_UNIT_TESTS=OFF -DCMAKE_BILD_TYPE=Debug ..
-- Building for: Visual Studio 15 2017
CMake Deprecation Warning at CMakeLists.txt:44 (CMAKE_POLICY):
  The OLD behavior for policy CMP0026 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Deprecation Warning at CMakeLists.txt:45 (CMAKE_POLICY):
  The OLD behavior for policy CMP0045 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


CMake Deprecation Warning at CMakeLists.txt:46 (CMAKE_POLICY):
  The OLD behavior for policy CMP0042 will be removed from a future version
  of CMake.

  The cmake-policies(7) manual explains that the OLD behaviors of all
  policies are deprecated and that a policy should be set to OLD only under
  specific short-term circumstances.  Projects should be ported to the NEW
  behavior and not rely on setting a policy to OLD.


-- Running cmake version 3.23.1
-- Found Git: C:/Program Files/Git/cmd/git.exe (found version "2.35.0.windows.1"
)
-- Configuring with MAX_INDEXES = 64U
-- The C compiler identification is MSVC 19.16.27048.0
-- The CXX compiler identification is MSVC 19.16.27048.0
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working C compiler: C:/Program Files (x86)/Microsoft Visual Studio/
2017/Community/VC/Tools/MSVC/14.16.27023/bin/Hostx86/x86/cl.exe - skipped
-- Detecting C compile features
-- Detecting C compile features - done
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Check for working CXX compiler: C:/Program Files (x86)/Microsoft Visual Studi
o/2017/Community/VC/Tools/MSVC/14.16.27023/bin/Hostx86/x86/cl.exe - skipped
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- CMAKE_GENERATOR: Visual Studio 15 2017
CMake Error at cmake/os/Windows.cmake:49 (MESSAGE):
  32 bit Windows builds are not supported.  Clean the build dir and rebuild
  using -G "Visual Studio 15 2017 Win64"
Call Stack (most recent call first):
  CMakeLists.txt:236 (INCLUDE)


-- Configuring incomplete, errors occurred!
See also "C:/Users/Igor/OneDrive/Documents/dbhandler_app/mysql-server/bin/CMakeF
iles/CMakeOutput.log".

C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin>dir
 Volume in drive C is TI10707700A
 Volume Serial Number is AE57-21A1

 Directory of C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin

07/23/2022  08:06 PM              .
07/23/2022  08:06 PM              ..
07/23/2022  08:06 PM            20,313 CMakeCache.txt
07/23/2022  08:06 PM              CMakeFiles
               1 File(s)         20,313 bytes
               3 Dir(s)  265,665,990,656 bytes free

C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin>del *
C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin\*, Are you sure
(Y/N)? y

C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin>cmake -DWITHOUT_
SERVER=ON -DWITH_UNIT_TESTS=OFF -DCMAKE_BILD_TYPE=Debug -G "Vsual Studio 15 2017
 win64" ..
CMake Error: Could not create named generator Vsual Studio 15 2017 win64

Generators
  Visual Studio 17 2022        = Generates Visual Studio 2022 project files.
                                 Use -A option to specify architecture.
  Visual Studio 16 2019        = Generates Visual Studio 2019 project files.
                                 Use -A option to specify architecture.
* Visual Studio 15 2017 [arch] = Generates Visual Studio 2017 project files.
                                 Optional [arch] can be "Win64" or "ARM".
  Visual Studio 14 2015 [arch] = Generates Visual Studio 2015 project files.
                                 Optional [arch] can be "Win64" or "ARM".
  Visual Studio 12 2013 [arch] = Generates Visual Studio 2013 project files.
                                 Optional [arch] can be "Win64" or "ARM".
  Visual Studio 11 2012 [arch] = Generates Visual Studio 2012 project files.
                                 Optional [arch] can be "Win64" or "ARM".
  Visual Studio 10 2010 [arch] = Deprecated.  Generates Visual Studio 2010
                                 project files.  Optional [arch] can be
                                 "Win64" or "IA64".
  Visual Studio 9 2008 [arch]  = Generates Visual Studio 2008 project files.
                                 Optional [arch] can be "Win64" or "IA64".
  Borland Makefiles            = Generates Borland makefiles.
  NMake Makefiles              = Generates NMake makefiles.
  NMake Makefiles JOM          = Generates JOM makefiles.
  MSYS Makefiles               = Generates MSYS makefiles.
  MinGW Makefiles              = Generates a make file for use with
                                 mingw32-make.
  Green Hills MULTI            = Generates Green Hills MULTI files
                                 (experimental, work-in-progress).
  Unix Makefiles               = Generates standard UNIX makefiles.
  Ninja                        = Generates build.ninja files.
  Ninja Multi-Config           = Generates build-.ninja files.
  Watcom WMake                 = Generates Watcom WMake makefiles.
  CodeBlocks - MinGW Makefiles = Generates CodeBlocks project files.
  CodeBlocks - NMake Makefiles = Generates CodeBlocks project files.
  CodeBlocks - NMake Makefiles JOM
                               = Generates CodeBlocks project files.
  CodeBlocks - Ninja           = Generates CodeBlocks project files.
  CodeBlocks - Unix Makefiles  = Generates CodeBlocks project files.
  CodeLite - MinGW Makefiles   = Generates CodeLite project files.
  CodeLite - NMake Makefiles   = Generates CodeLite project files.
  CodeLite - Ninja             = Generates CodeLite project files.
  CodeLite - Unix Makefiles    = Generates CodeLite project files.
  Eclipse CDT4 - NMake Makefiles
                               = Generates Eclipse CDT 4.0 project files.
  Eclipse CDT4 - MinGW Makefiles
                               = Generates Eclipse CDT 4.0 project files.
  Eclipse CDT4 - Ninja         = Generates Eclipse CDT 4.0 project files.
  Eclipse CDT4 - Unix Makefiles= Generates Eclipse CDT 4.0 project files.
  Kate - MinGW Makefiles       = Generates Kate project files.
  Kate - NMake Makefiles       = Generates Kate project files.
  Kate - Ninja                 = Generates Kate project files.
  Kate - Unix Makefiles        = Generates Kate project files.
  Sublime Text 2 - MinGW Makefiles
                               = Generates Sublime Text 2 project files.
  Sublime Text 2 - NMake Makefiles
                               = Generates Sublime Text 2 project files.
  Sublime Text 2 - Ninja       = Generates Sublime Text 2 project files.
  Sublime Text 2 - Unix Makefiles
                               = Generates Sublime Text 2 project files.


C:\Users\Igor\OneDrive\Documents\dbhandler_app\mysql-server\bin>dir

Could someone please help?

Thank you.

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

Edwin Desouza — Tue, 12 Jul 2022 15:46:21 +0000

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