Package Base Details: mysql

Git Clone URL: (read-only, click to copy)
Submitter: Barthalion
Maintainer: muflone
Last Packager: muflone
Votes: 80
Popularity: 0.21
First Submitted: 2013-04-25 19:13 (UTC)
Last Updated: 2022-06-11 23:23 (UTC)

Latest Comments

FrederickZh commented on 2022-02-21 09:08 (UTC)

@Muflone Could you apply the patch below? Thank you!

diff --git a/PKGBUILD b/PKGBUILD
index 2191850..e1f14ce 100644
@@ -57,9 +57,9 @@ build() {
     -DINSTALL_SHAREDIR=share/mysql \
     -DROUTER_INSTALL_CONFIGDIR=etc/mysqlrouter \
     -DROUTER_INSTALL_DATADIR=var/lib/mysqlrouter \
-    -DROUTER_INSTALL_LOGDIR=var/log/mysqlrouter \
+    -DROUTER_INSTALL_LOGDIR=/var/log/mysqlrouter \
     -DWITH_FIDO=system \
     -DWITH_SSL=system \
@@ -144,8 +144,9 @@ package_mysql-clients(){
   pkgdesc="Fast SQL database server, community edition"
+          "etc/logrotate.d/mysqlrouter"
   depends=('mysql-clients' 'libsasl' 'zlib' 'jemalloc' 'libaio' 'libtirpc' 'icu'
            'lz4' 'libevent' 'systemd-libs' 'zstd' 'bash')
@@ -229,11 +230,12 @@ package_mysql(){
   rmdir "${pkgdir}/usr/usr/lib"
   rmdir "${pkgdir}/usr/usr"
   rmdir "${pkgdir}/usr/var/lib/mysqlrouter"
   rmdir "${pkgdir}/usr/var/lib"
-  rmdir "${pkgdir}/usr/var/log/mysqlrouter"
-  rmdir "${pkgdir}/usr/var/log"
   rmdir "${pkgdir}/usr/var"
+  rmdir "${pkgdir}/var/log/mysqlrouter"
+  rmdir "${pkgdir}/var/log"
+  rmdir "${pkgdir}/var"

   # Arch Linux specific patches:
   #  * enable PrivateTmp for a little bit more security
   #  * force preloading jemalloc for memory management

FrederickZh commented on 2021-12-22 23:45 (UTC)

Got the following error:

systemd[1]: Starting Rotate log files...
logrotate[385400]: mysqlrouter:31 keyword 'var' not properly separated, found 0x2f
logrotate[385400]: error: mysqlrouter:31 unknown option 'var' -- ignoring line
logrotate[385400]: error: mysqlrouter:45 unexpected }
logrotate[385400]: error: found error in file mysqlrouter, skipping
systemd[1]: logrotate.service: Main process exited, code=exited, status=1/FAILURE
systemd[1]: logrotate.service: Failed with result 'exit-code'.
systemd[1]: Failed to start Rotate log files.

I think in /etc/logrotate.d/mysqlrouter, line var/log/mysqlrouter/mysqlrouter.log { needs a leading /.

carlosmuller commented on 2021-08-27 12:36 (UTC)

Hi @Muflone, here is my patch to update to 8.0.26 and add a option to pass more options to the build process like adding debug or other parts

diff --git a/PKGBUILD b/PKGBUILD
index f0955fd..51ca6e3 100644
@@ -6,7 +6,9 @@

 pkgname=('mysql' 'libmysqlclient' 'mysql-clients')
 pkgdesc="Fast SQL database server, community edition"
@@ -22,7 +24,7 @@ source=("${pkgbase}-boost-${pkgver}.ta
@@ -79,7 +81,8 @@ build() {
     -DDEFAULT_CHARSET=utf8mb4 \
     -DDEFAULT_COLLATION=utf8mb4_unicode_ci \
-    -DWITH_BOOST="../${pkgname}-${pkgver}/boost"
+    -DWITH_BOOST="../${pkgname}-${pkgver}/boost" \

@@ -166,11 +169,10 @@ package_mysql(){
   rm "${pkgdir}/usr/lib/libmysqlclient.a"
   rm "${pkgdir}/usr/lib/"
   rm "${pkgdir}/usr/lib/"
-  rm "${pkgdir}/usr/lib/"
+  rm "${pkgdir}/usr/lib/$minor"
   rm "${pkgdir}/usr/lib/libmysqlservices.a"
   rm "${pkgdir}/usr/lib/pkgconfig/mysqlclient.pc"
   rmdir "${pkgdir}/usr/lib/pkgconfig"
-  rm "${pkgdir}/usr/lib/mysql/plugin/"
   rm -r "${pkgdir}/usr/include"
   rm "${pkgdir}/usr/share/mysql/aclocal/mysql.m4"
   rmdir "${pkgdir}/usr/share/mysql/aclocal"

Thanks for the time and effort put in this package!

muflone commented on 2021-05-27 20:05 (UTC)

@fishnet37222 you can test the package by yourself by updating the pkgver in the PKGBUILD and offer your patches to fix the issues

fishnet37222 commented on 2021-05-27 13:31 (UTC)

Will this package be updated to version 8.0.25 any time soon?

muflone commented on 2021-05-02 02:04 (UTC)

@hxss fixed

Moved users management from .install to systemd-sysusers. After package uninstall the existing mysql and mysqlrouter users will not be deleted automatically

hxss commented on 2021-04-21 07:26 (UTC)

Post-transaction hook requires mysqlrouter user that doesn't exists in my system after installing the package.

:: Processing package changes...
(1/3) reinstalling libmysqlclient                                         [#########################################] 100%
(2/3) reinstalling mysql-clients                                          [#########################################] 100%
(3/3) reinstalling mysql                                                  [#########################################] 100%
:: Running post-transaction hooks...
(1/3) Reloading system manager configuration...
(2/3) Creating temporary files...
/usr/lib/tmpfiles.d/mysqlrouter.conf:23: Failed to resolve user 'mysqlrouter': No such process
/usr/lib/tmpfiles.d/mysqlrouter.conf:24: Failed to resolve user 'mysqlrouter': No such process
/usr/lib/tmpfiles.d/mysqlrouter.conf:25: Failed to resolve user 'mysqlrouter': No such process
error: command failed to execute correctly
(3/3) Arming ConditionNeedsUpdate...

AnotherUser commented on 2021-02-10 07:35 (UTC) (edited on 2021-02-10 07:52 (UTC) by AnotherUser)

I tried to install mysql with mariadb-clients as provider for mysql-clients:

:: There are 2 providers available for mysql-clients:
:: Repositoryextra
    1) mariadb-clients :: Repositorycommunity
    2) percona-server-clients 

Enter a number (default=1):

Which leads to:

error: failed to commit transaction (conflicting files)
mysql: /usr/bin/mysql_upgrade exists in filesystem (owned by mariadb-clients)
mysql: /usr/bin/mysqlbinlog exists in filesystem (owned by mariadb-clients)
mysql: /usr/bin/mysqltest exists in filesystem (owned by mariadb-clients)
mysql: /usr/share/man/man1/mysql_upgrade.1.gz exists in filesystem (owned by mariadb-clients)
mysql: /usr/share/man/man1/mysqlbinlog.1.gz exists in filesystem (owned by mariadb-clients)
Errors occurred, no packages were upgraded.

I'm confused

Edit: I just removed the existing mariadb libs (without dependency check):

yay -ddR mariadb-libs

and installed the mysql-clients with libmysqlclient. After that it was possible to install mysql..

Is there a better approach?

postfix needs mariadb-libs

cidao commented on 2021-01-22 03:30 (UTC)

I think there are some incompatibilities between the last Manjaro update and this MySQL package. Do you know when it can be fixed?

muflone commented on 2021-01-10 02:59 (UTC)

Incorporated FrederickZh's fixes, Thank you

cascooscuro commented on 2021-01-03 17:28 (UTC)

I'm also facing the error "TRUE was not declared in this scope" while compiling.


before the:

cmake "../${pkgbase}-${pkgver}"

and now the compilation finishes

petronny commented on 2020-12-27 06:09 (UTC)

Please add FrederickZh's patch.

FrederickZh commented on 2020-12-25 11:46 (UTC)

And for some reason I now need to patch otherwise it won't compile (TRUE was not declared in this scope):

diff --git a/sql/ b/sql/
index 51992613..0dc0c7c4 100644
--- a/sql/
+++ b/sql/
@@ -925,8 +925,9 @@ using std::min;
 using std::vector;

 #define mysqld_charset &my_charset_latin1
 #define mysqld_default_locale_name "en_US"
+#define TRUE (1)

 #include <fpu_control.h>  // IWYU pragma: keep
 #elif defined(__i386__)

This happens under my two Arch systems as well as a clean chroot.

FrederickZh commented on 2020-12-25 11:39 (UTC) (edited on 2020-12-25 11:41 (UTC) by FrederickZh)

I don't use MySQL Router, but an error during post-upgrade caught my eye:

(2/5) Creating temporary files...
/usr/lib/tmpfiles.d/mysqlrouter.conf:23: Path 'run' not absolute.
error: command failed to execute correctly

And after digging deeper, I noticed that the default directories used by MySQL Router are obviously off as well:

$ mysqlrouter --help
MySQL Router  Ver 8.0.22 for Linux on x86_64 (Source distribution)
Copyright (c) 2015, 2020, Oracle and/or its affiliates. All rights reserved.

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

Configuration read from the following files in the given order (enclosed
in parentheses means not available for reading):
Plugins Path:

Default Log Directory:

Default Persistent Data Directory:

Default Runtime State Directory:

Here's a patch I've come up with (without .SRCINFO):

diff --git a/PKGBUILD b/PKGBUILD
index 4d305fe..9d11faa 100644
@@ -25,9 +25,9 @@ sha256sums=('ba765f74367c638d7cd1c546c05c14382fd997669bcd9680278e907f8d7eb484'
-            '7dfc863de8ba62b31e412bdb82a2617c90b9e588db34028ab694813547dab167')
+            '0c047b18b9d40cae66be6d234d655347ee84d36420c8d70dc07334b6c960d9c7')

 build() {
   rm -rf build
   mkdir build
@@ -52,8 +52,12 @@ build() {
     -DINSTALL_MYSQLSHAREDIR=share/mysql \
     -DINSTALL_DOCDIR=share/mysql/docs \
     -DINSTALL_SHAREDIR=share/mysql \
+    -DROUTER_INSTALL_CONFIGDIR=../etc/mysqlrouter \
+    -DROUTER_INSTALL_DATADIR=../var/lib/mysqlrouter \
+    -DROUTER_INSTALL_LOGDIR=../var/log/mysqlrouter \
     -DWITH_SSL=system \
     -DWITH_LTO=ON \
@@ -135,8 +139,9 @@ package_mysql-clients(){

   pkgdesc="Fast SQL database server, community edition"
+          "etc/mysqlrouter/mysqlrouter.conf"
   depends=('mysql-clients' 'libsasl' 'zlib' 'jemalloc' 'libaio' 'libtirpc' 'icu'
            'lz4' 'libevent' 'systemd-libs')
@@ -150,8 +155,9 @@ package_mysql(){

   install -m 644 -D "${srcdir}/my-default.cnf" "${pkgdir}/etc/mysql/my.cnf"
   install -m 755 -d "${pkgdir}/etc/"
   install -m 644 -D "${srcdir}/" "${pkgdir}/etc/${pkgname}.conf"
+  install -m 644 -D "${srcdir}/build/packaging/rpm-common/mysqlrouter.conf" "${pkgdir}/etc/mysqlrouter/mysqlrouter.conf"

   # provided by libmysqlclient
   rm "${pkgdir}/usr/bin/mysql_config"
   rm "${pkgdir}/usr/lib/libmysqlclient.a"
@@ -187,9 +193,9 @@ package_mysql(){
   rm "${pkgdir}/usr/share/man/man1/mysqlslap.1"

   # not needed
   rm -r "${pkgdir}/usr/mysql-test"
-  rmdir "${pkgdir}/usr/run"
+  rmdir "${pkgdir}/run"

   # Move somewhere else
   mv "${pkgdir}/usr/LICENSE.router" "${pkgdir}/usr/share/mysql/docs"
   mv "${pkgdir}/usr/README.router" "${pkgdir}/usr/share/mysql/docs"
@@ -206,11 +212,13 @@ package_mysql(){

   # Cleanup
   rmdir "${pkgdir}/usr/usr/lib"
   rmdir "${pkgdir}/usr/usr"
-  rmdir "${pkgdir}/usr/var/lib/mysqlrouter"
-  rmdir "${pkgdir}/usr/var/lib"
-  rmdir "${pkgdir}/usr/var"
+  rmdir "${pkgdir}/var/lib/mysqlrouter"
+  rmdir "${pkgdir}/var/lib"
+  rmdir "${pkgdir}/var/log/mysqlrouter"
+  rmdir "${pkgdir}/var/log"
+  rmdir "${pkgdir}/var"

   # Arch Linux specific patches:
   #  * enable PrivateTmp for a little bit more security
   #  * force preloading jemalloc for memory management
diff --git a/mysql.install b/mysql.install
index 90583a1..384c764 100644
--- a/mysql.install
+++ b/mysql.install
@@ -6,8 +6,16 @@ post_install(){
     install -dm700 "/var/lib/mysql"
     chown -R mysql:mysql "/var/lib/mysql" &>/dev/null

+  groupadd -g 88 mysqlrouter &>/dev/null
+  useradd -u 88 -g mysqlrouter -d "/var/lib/mysqlrouter" -s /bin/false mysqlrouter &>/dev/null
+  if [[ ! -e "/var/lib/mysqlrouter" ]]; then
+    install -dm700 "/var/lib/mysqlrouter"
+    chown -R mysqlrouter:mysqlrouter "/var/lib/mysqlrouter" &>/dev/null
+  fi
   echo ":: You need to initialize the MySQL data directory prior to starting"
   echo "   the service. This can be done with mysqld --initialize command, e.g.:"
   echo "   mysqld --initialize --user=mysql --basedir=/usr --datadir=/var/lib/mysql"
   echo ":: Additionally you should secure your MySQL installation using"
@@ -20,5 +28,11 @@ post_remove(){
   if getent group mysql >/dev/null 2>&1; then
     groupdel mysql
+  if getent passwd mysqlrouter >/dev/null 2>&1; then
+    userdel mysqlrouter
+  fi
+  if getent group mysqlrouter >/dev/null 2>&1; then
+    groupdel mysqlrouter
+  fi
diff --git a/systemd-sysusers-tmpfiles.patch b/systemd-sysusers-tmpfiles.patch
index 6eccab1..ea21328 100644
--- a/systemd-sysusers-tmpfiles.patch
+++ b/systemd-sysusers-tmpfiles.patch
@@ -7,4 +7,14 @@
 -d /var/run/mysqld 0755 mysql mysql  -
 +d /run/mysqld 0755 mysql mysql  -
 +d /var/lib/mysql 0700 mysql mysql  -

+--- a/usr/lib/tmpfiles.d/mysqlrouter.conf  2020-12-25 21:41:47.218202248 +1100
++++ b/usr/lib/tmpfiles.d/mysqlrouter.conf  2020-12-25 21:42:07.126124043 +1100
+@@ -20,4 +20,6 @@
+ # along with this program; if not, write to the Free Software
+ # Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA
+-d ../run 0755 mysqlrouter mysqlrouter  -
++d /run/mysqlrouter 0755 mysqlrouter mysqlrouter  -
++d /var/lib/mysqlrouter 0700 mysqlrouter mysqlrouter  -
++d /var/log/mysqlrouter 0750 mysqlrouter mysqlrouter  -

tl;dr this patch:

  1. creates mysqlrouter user & group during post-install
  2. fixes the post-upgrade problem above
  3. creates /var/lib/mysqlrouter & /var/log/mysqlrouter via systemd-tmpfiles
  4. copies the default Router configuration to /etc/mysqlrouter/mysqlrouter.conf

Btw now mysqlrouter --help output becomes:

Configuration read from the following files in the given order (enclosed
in parentheses means not available for reading):
Plugins Path:

Default Log Directory:

Default Persistent Data Directory:

Default Runtime State Directory:

PS: this might be useful

muflone commented on 2020-12-24 15:39 (UTC)

@ruidc mysqlbinlog is included in the mysql package

mateodif commented on 2020-12-24 14:08 (UTC)

I'm getting shared libraries errors with latest icu package.

mysqld: error while loading shared libraries: cannot open shared object file: No such file or directory

ruidc commented on 2020-12-23 08:32 (UTC)

can mysqlbinlog be added? the diff provided by FrederickZh over a year ago won't work on recent versions

brektrou commented on 2020-11-17 04:17 (UTC)

A new version is available (8.0.22)

FrederickZh commented on 2020-04-27 19:58 (UTC)

@Muflone I agree with @rtucek that it's probably better to pack mysql_config_editor into mysql-clients. As a matter of fact, it's packed in the official mysql-community-client package for Ubuntu:

$ dpkg-query -L mysql-community-client | rg mysql_config

And btw I noticed mysql-secret-store-login-path from MySQL Shell that I maintain also requires mysql-community-client for secret store support. Considering the functionality it provides I reckon it also makes more sense to put it in the client package. I'd appreciate it if you could move this binary. Thank you!

Zeitgeist-J commented on 2020-03-31 16:28 (UTC)

Package is not including mysqld.sock (/run/mysqld/mysqld.sock) which does not allows to complete the mysql_secure_installation command. Am I doing something wrong or is it a package error?

keoma commented on 2019-10-30 23:22 (UTC)

@FrederickZh it worked. I could update protobuf and install mysql seamlessly. Thank you.

keoma commented on 2019-10-29 23:02 (UTC)

@FrederickZh thank you. I'll try later today.

FrederickZh commented on 2019-10-29 04:16 (UTC)

@keoma Use this for now:

diff --git a/.SRCINFO b/.SRCINFO
index 0d08088..2121f72 100644
--- a/.SRCINFO
+++ b/.SRCINFO
@@ -17,9 +17,8 @@ pkgbase = mysql
    makedepends = libedit
    makedepends = libevent
    makedepends = re2
    makedepends = rapidjson
-   makedepends = protobuf
    source =
    source = my-default.cnf
    source =
    source = mysql.sysconfig
@@ -43,9 +42,8 @@ pkgname = mysql
    depends = libtirpc
    depends = icu
    depends = lz4
    depends = libevent
-   depends = protobuf
    depends = systemd-libs
    optdepends = perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format and mysql_setpermission
    provides = mariadb=8.0.17
    provides = mysql=8.0.17
diff --git a/PKGBUILD b/PKGBUILD
index dff0e9a..853481c 100644
@@ -11,9 +11,9 @@ pkgrel=1
 pkgdesc="Fast SQL database server, community edition"
 makedepends=('openssl' 'zlib' 'cmake' 'systemd-tools' 'libaio' 'jemalloc'
              'rpcsvc-proto' 'libtirpc' 'icu' 'libedit' 'libevent' 're2'
-             'rapidjson' 'protobuf')
+             'rapidjson')
@@ -59,8 +59,9 @@ build() {
     -DWITH_LTO=ON \
     -DWITH_SYSTEMD=yes \
+    -DWITH_PROTOBUF=bundled \
@@ -138,9 +139,9 @@ package_mysql(){
   depends=('mysql-clients' 'libsasl' 'zlib' 'jemalloc' 'libaio' 'libtirpc' 'icu'
-           'lz4' 'libevent' 'protobuf' 'systemd-libs')
+           'lz4' 'libevent' 'systemd-libs')
   provides=("mariadb=${pkgver}" "mysql=${pkgver}")
   optdepends=('perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format and mysql_setpermission')

keoma commented on 2019-10-28 22:37 (UTC)

protobuf 3.10.0-1 breaks mysqld because the file has been removed in this version. I had to downgrade it to 3.7.0-1 to make it work again.

Ildar commented on 2019-10-04 11:48 (UTC)

Using the flag -DWITH_SYSTEM_LIBS=OFF during the compilation helped me to fix the problem "mysql client ignores ~/.editrc. bind "^W" ed-delete-prev-word doesn't work"

rtucek commented on 2019-09-30 12:41 (UTC) (edited on 2019-09-30 12:42 (UTC) by rtucek)

Hi @Muflone,

thank you for maintaining the repo!

What's the intention behind removing mysql_config_editor after the build? It's a very useful CLI utility for storing the credentials. I've prepared a small patch ( which prevents removing it. Would you mind consider applying it?

BR Rudi

FrederickZh commented on 2019-08-18 12:57 (UTC) (edited on 2019-08-18 12:59 (UTC) by FrederickZh)

It seems that there are several missing files in this package compared with the official ones for Ubuntu 18.04 amd64. Here's a summary CSV I put together:

The following patch fixes the missing mysqlx headers and mysqlbinlog. Additionally, I moved mysql_upgrade to a separate block as it was removed cos of a different reason; libmysqlclient.a to libmysqlclient since in Ubuntu it's also in libmysqlclient-dev; and imho I don't think removing the compiled binaries in build() is a good practice as it voids the purpose of makepkg flags such as -R, -C (and AUR helpers like yay actually asks users whether a clean build is needed) hence the mkdir part at the beginning. I'm not quite sure why some plugins, e.g., are not even built tho (didn't see them in cmake --build . --target help).

diff --git a/PKGBUILD b/PKGBUILD
index dff0e9a..d128267 100644
@@ -28,10 +28,9 @@ sha256sums=('d44231316ce30a1d1189125ceed86d3388409778e17d0e3b9a060f532463e29a'

 build() {
-  rm -rf build
-  mkdir build
+  mkdir -p build
   cd build

   cmake "../${pkgbase}-${pkgver}" \
     -DCMAKE_AR=/usr/bin/gcc-ar \
@@ -93,8 +92,11 @@ package_libmysqlclient(){
   for dir in include libmysql libservices
     make -C "${dir}" DESTDIR="${pkgdir}" install
+  install -m 644 -D "${srcdir}/build/plugin/x/generated/mysqlx_ername.h" "${pkgdir}/usr/include/mysqlx_ername.h"
+  install -m 644 -D "${srcdir}/build/plugin/x/generated/mysqlx_error.h" "${pkgdir}/usr/include/mysqlx_error.h"
+  install -m 644 -D "${srcdir}/build/plugin/x/generated/mysqlx_version.h" "${pkgdir}/usr/include/mysqlx_version.h"

   install -m 755 -d "${pkgdir}/usr/bin"
   install -m 755 scripts/mysql_config "${pkgdir}/usr/bin/"
   install -m 755 -d "${pkgdir}/usr/share/man/man1"
@@ -153,8 +155,9 @@ package_mysql(){
   install -m 644 -D "${srcdir}/" "${pkgdir}/etc/${pkgname}.conf"

   # provided by libmysqlclient
   rm "${pkgdir}/usr/bin/mysql_config"
+  rm "${pkgdir}/usr/lib/libmysqlclient.a"
   rm "${pkgdir}/usr/lib/"
   rm "${pkgdir}/usr/lib/"
   rm "${pkgdir}/usr/lib/"
   rm "${pkgdir}/usr/lib/libmysqlservices.a"
@@ -166,23 +169,23 @@ package_mysql(){

   # provided by mysql-clients
   rm "${pkgdir}/usr/bin/mysql"
   rm "${pkgdir}/usr/bin/mysqladmin"
-  rm "${pkgdir}/usr/bin/mysqlbinlog"
   rm "${pkgdir}/usr/bin/mysqlcheck"
   rm "${pkgdir}/usr/bin/mysqldump"
   rm "${pkgdir}/usr/bin/mysqlimport"
   rm "${pkgdir}/usr/bin/mysqlshow"
   rm "${pkgdir}/usr/bin/mysqlslap"
-  rm "${pkgdir}/usr/bin/mysql_upgrade"
   rm "${pkgdir}/usr/share/man/man1/mysql.1"
   rm "${pkgdir}/usr/share/man/man1/mysqladmin.1"
-  rm "${pkgdir}/usr/share/man/man1/mysqlbinlog.1"
   rm "${pkgdir}/usr/share/man/man1/mysqlcheck.1"
   rm "${pkgdir}/usr/share/man/man1/mysqldump.1"
   rm "${pkgdir}/usr/share/man/man1/mysqlimport.1"
   rm "${pkgdir}/usr/share/man/man1/mysqlshow.1"
   rm "${pkgdir}/usr/share/man/man1/mysqlslap.1"
+  # deprecated
+  rm "${pkgdir}/usr/bin/mysql_upgrade"
   rm "${pkgdir}/usr/share/man/man1/mysql_upgrade.1"

   # not needed
   rm -r "${pkgdir}/usr/mysql-test"

FrederickZh commented on 2019-08-13 17:02 (UTC)

@Muflone Fair enough. Actually I didn't even know MySQL Shell existed until several days ago when I was googling about how connection URIs could be used for CLI. Hope it can get more traction in the future.

Btw, when I was scanning the files, I noticed that usr/lib/libmysqlclient.a is packed into mysql instead of libmysqlclient. Sorry if it's a stupid question but shouldn't it be in the latter?

muflone commented on 2019-08-10 16:53 (UTC)

@FrederickZh I don't think it would be useful for mysql package users to download the source code for mysql-shell, build it and don't install it. It would cause a lot of unuseful work for a majority of users

FrederickZh commented on 2019-08-05 07:09 (UTC)

Sorry if this question has already been answered (I went through several pages of comments without finding any similar ones), but is it possible to ship mysql-shell with this package as well?

I just had a glance at the build instruction of mysql-shell and it seems that it requires both the source code of MySQL and the X protocol client library to compile (actually also the build directory of MySQL, but I suspect it's only needed to locate libmysqlclient and libmysqlxclient). In this case is it better to build MySQL Shell along with this package so that it could be easier to manage?

muflone commented on 2019-08-04 22:25 (UTC)

@salifm did you bothered to read the error message? you have no space left in your file system

francoism90 commented on 2019-08-02 08:49 (UTC)

@tlo MySQL should now automatically upgrade:

tlo commented on 2019-06-28 14:05 (UTC) (edited on 2019-06-28 14:13 (UTC) by tlo)

NVM: Upon further investigation I found this is a deprecated command my apologies for the useless comment.

I have just built mysql-8.0.16-1 and after installing I noticed mysql_upgrade was built (src/build/runtime_output_directory/mysql_upgrade) but was not installed to the system it appears to be missing from the pkg not sure if this is a bug or a strange fluke on my machine. In case it matters downloaded with yay -G aur/mysql and built with makepkg -si

muflone commented on 2019-06-23 22:39 (UTC) (edited on 2019-06-23 22:40 (UTC) by muflone)


thank you for your precious work. I've integrated some of your fixes and changes. (now mysql builds fine with ccache)

francoism90 commented on 2019-06-14 12:12 (UTC) (edited on 2019-06-14 12:13 (UTC) by francoism90)

@svenaugustus you need to recompile this package (MySQL) - don't know what lib(s) causing this issue. I recommend to reboot first before doing prior compiling.

zenonix commented on 2019-06-13 13:31 (UTC)

$ mysqld --initialize --user=mysql

mysqld: error while loading shared libraries: cannot open shared object file: No such file or directory

something wrong while libicuuc haved updated to version 64. =。=

francoism90 commented on 2019-05-31 12:04 (UTC)

@Muflone @others I have created MySQL 8.16, did a clean-up, switched to systemd provided by pkg, used some stuff seen in MariaDB pkg and updated the my-default.cnf:

It would be great if you take a look and tell me what you think. :) I did not use and, are they still needed?

francoism90 commented on 2019-05-22 18:45 (UTC) (edited on 2019-05-22 18:52 (UTC) by francoism90)

@Muflone Seems MySQL provide systemd service OOTB:

Is there any reason why not using (a patched) upstream one? :)

Would LTO help to optimize MySQL?

Ildar commented on 2019-05-16 04:32 (UTC)

Could you change the build instructions to compile MySQL with bundled libedit as they do not support any other version of libedit?

It is the problem with not-working CTRL+W hotkey

I tried to downgrade to libedit-20180525_3.1-1 before the compilation, but it didn't help.

@Khaithang try yay mysql-clients

Khaithang commented on 2019-05-15 19:34 (UTC)

Why Yay is not finding this package ? I get only mariadb and percona?

Ildar commented on 2019-05-08 07:54 (UTC)

I have submitted a bug report

mysql client ignores ~/.editrc. bind "^W" ed-delete-prev-word doesn't work

francoism90 commented on 2019-04-05 20:41 (UTC) (edited on 2019-04-05 20:42 (UTC) by francoism90)

@torquerrr @all This possible happens when /tmp is full, I was getting the same error when building this pkg.

Simple build with BUILDDIR=. makepkg -sci or increase /tmp size.

muflone commented on 2019-04-05 11:51 (UTC)

You cannot install only the mysql package without the mysql-clients package. Just install all the three packages from this PKGBUILD

karthiknayak commented on 2019-04-05 07:53 (UTC) (edited on 2019-04-05 08:47 (UTC) by karthiknayak)

The installation fails on the latest version (mariadb=8.0.15, mysql=8.0.15)

error: failed to commit transaction (conflicting files)
mysql: /usr/bin/mysql_upgrade exists in filesystem (owned by mariadb-clients)
mysql: /usr/bin/mysqlbinlog exists in filesystem (owned by mariadb-clients)
mysql: /usr/bin/mysqltest exists in filesystem (owned by mariadb-clients)
mysql: /usr/share/man/man1/mysql_upgrade.1.gz exists in filesystem (owned by mariadb-clients)
mysql: /usr/share/man/man1/mysqlbinlog.1.gz exists in filesystem (owned by mariadb-clients)
Errors occurred, no packages were upgraded.

aminos commented on 2019-03-24 22:01 (UTC)

can you please update to support protobuf-3.7 ?

torquerrr commented on 2019-02-23 08:26 (UTC) (edited on 2019-02-23 08:27 (UTC) by torquerrr)

If anyone gets the same error as I did, do not build with yaourt. I was able to successfully build all three packages by running the makepkg -cs command in the PKGBUILD directory. Thanks @francoism90 for the tip.

francoism90 commented on 2019-02-16 10:00 (UTC)

@torquerrr don't use a helper (yaourt isn't recommended anyway).

torquerrr commented on 2019-02-16 09:09 (UTC) (edited on 2019-02-16 09:27 (UTC) by torquerrr)

@Muflone Hi, I am unable to build the package. I am getting an error:

CMake Error at sql/cmake_install.cmake:47 (file):
  file INSTALL cannot copy file
  to "/tmp/yaourt-tmp-torquerrr/aur-mysql/pkg/mysql/usr/bin/mysqld".
Call Stack (most recent call first):
  cmake_install.cmake:127 (include)

make: *** [Makefile:74: install] Error 1
==> ERROR: A failure occurred in package_mysql().
==> ERROR: Makepkg was unable to build mysql.


I run the build with: yaourt -S aur/mysql Can you provide some help, please?

Edit: probably I need to build it in a clean chroot, I will try and report back.

muflone commented on 2019-02-02 20:18 (UTC)

Package updated to version 8.0.14 and added provides and conflicts for mariadb-libs

The package libmysqlclient though was not renamed to mysql-client as it seems to me pointless to follow the mariadb naming changes.

Since this versions a lot of changes were made in the build process, accordingly to Terje Røsten suggests. Thank you Terje

Jat commented on 2019-01-30 04:32 (UTC)

libmysqlclient should be renamed to mysql-libs. plz add mariadb-libs to conflicts and provides.

cartinez commented on 2019-01-25 08:01 (UTC)

Hi, is it possible since the package is out-of-date, it breaks the dependencies for mysql-python? Pacman says I have to update it (mysql-python) but it tries to get mariadb-libs, which conflicts with this package

muflone commented on 2018-11-24 17:50 (UTC)

@tlo certificate renewed. thank you

tlo commented on 2018-11-24 12:19 (UTC)

FYI: error: failed retrieving file 'muflone-aur.db' from : SSL certificate problem: certificate has expired

It would appear that your certificate has expired.

francoism90 commented on 2018-11-07 11:51 (UTC) (edited on 2018-11-07 11:51 (UTC) by francoism90)

I had to run sudo mysql_upgrade -p -u root to fix the following error: Nov 07 12:47:43 nuc mysqld[31075]: 2018-11-07T11:47:43.042098Z 0 [ERROR] [MY-013142] [Server] Column count of mysql.user is wrong. Expected 50, found 49.

Don't know why mysql_upgrade isn't performed on every upgrade.

pelo commented on 2018-09-19 09:36 (UTC)

@Muflone, you've listed your repo details in one of the your comments. You could find it in page 2 or 3 of the comments. I think you should correct the repo name and pin that comment to the top.

francoism90 commented on 2018-08-27 13:10 (UTC) (edited on 2018-08-27 13:11 (UTC) by francoism90)

@Muflone Not a big issue, as workaround simple uninstall ccache for update/installing and reinstall it afterwards.

Thanks for keeping it up-to-date. :)

muflone commented on 2018-08-26 17:25 (UTC)

@francoism90 I can confirm your issue but I don't know the reason. Unfortunately I had to build it many times before releasing the updated package

francoism90 commented on 2018-08-15 18:22 (UTC)

Is it normal that this doesn't build with ccache? I keep getting bad option given error on make.

muflone commented on 2018-08-15 10:35 (UTC)

@pelo99, you're right, I've dropped the muflone-mysql and moved the packages into muflone-aur repository, but where did you find my repository written?

pelo99 commented on 2018-08-15 09:28 (UTC) (edited on 2018-08-15 09:30 (UTC) by pelo99)

@Muflone, Please change the repo name from 'muflone-mysql' to 'muflone-aur' in your own repository for mysql and pin the link.

jonkristian commented on 2018-06-19 11:37 (UTC) (edited on 2018-06-19 11:39 (UTC) by jonkristian)

Need some help. Accidentally upgraded without paying attention and now I'm in a state where it has upgraded to 8 so all my databases aren't working.

2018-06-19T11:35:14.057797Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.

2018-06-19T11:35:14.057861Z 0 [System] [MY-010116] [Server] /usr/bin/mysqld (mysqld 8.0.11) starting as process 20919

2018-06-19T11:35:14.326982Z 1 [ERROR] [MY-010781] [Server] Found ./mysql/index_stats.frm file in mysql schema. DD will create .ibd file with same name. Please rename table and start upgrade process again.

2018-06-19T11:35:14.327012Z 1 [ERROR] [MY-010336] [Server] Found .frm file with same name as one of the Dictionary Tables.

2018-06-19T11:35:14.327238Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2018-06-19T11:35:14.327269Z 0 [ERROR] [MY-010119] [Server] Aborting

2018-06-19T11:35:15.947137Z 0 [System] [MY-010910] [Server] /usr/bin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server (GPL).

2018-06-19T11:35:15.947185Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.

francoism90 commented on 2018-05-09 09:34 (UTC) (edited on 2018-05-09 09:34 (UTC) by francoism90)

Just a note, but please use with care (e.g. create a backup first)!

After upgrade to MySQL 8.0, I had to execute the following command to solve errors/warning reported by the mysql service:

mysql_upgrade --password='your-root-password' upgrade-system-tables

francoism90 commented on 2018-05-09 07:46 (UTC)

@Muflone Thanks for the update. :)

muflone commented on 2018-05-08 22:31 (UTC)

here's 8.0 :-)

francoism90 commented on 2018-05-08 17:13 (UTC)

@Muflone Any update on the 8.0 release? :)

muflone commented on 2018-04-29 22:06 (UTC)

This is the last update for the 5.7 series. A new package called mysql57 was uploaded to continue releases for the 5.7 series.

From the next update this package will go to version 8.0

francoism90 commented on 2018-04-19 17:06 (UTC) - big jump!

Before upgrading, are manual actions needed?

muflone commented on 2018-03-03 21:47 (UTC)

@rashi and @markoff

Be sure your system is up to date and build the package in a clean chroot.

Currently it builds fine using extra-x86_64-build

markoff commented on 2018-02-28 16:55 (UTC)

@Muflone, are you doing anything to fix the problem rashi had? Because I'm having exactly the same problem.

muflone commented on 2018-02-08 00:03 (UTC) (edited on 2018-02-08 00:05 (UTC) by muflone)

I maintain my own repository for the mysql, mysql55 and mysql56 packages, built in clean chroot and signed with official Arch Linux key (therefore no need to import an extraneous key or keyring)

SigLevel = Required
Server =$repo/$arch

heavysink commented on 2018-02-06 19:47 (UTC) (edited on 2018-02-06 19:49 (UTC) by heavysink)

mysql is included in ArchlinuxCN repository. Please add these

[archlinuxcn] Server =$arch

Once the repo is added, archlinuxcn-keyring package must be installed before mysql so you do not get errors about PGP signatures.

Also if you want to try bleeding edge mariadb-git, you can also find it in the repo.

dansantos commented on 2018-01-20 22:24 (UTC) (edited on 2018-01-20 22:36 (UTC) by dansantos)

You can also download the package with the latest version of MySQL precompiled here: << >> Instructions for installing are in the repository. HAVE FUN!

rashyd commented on 2018-01-08 16:06 (UTC) (edited on 2018-01-08 16:07 (UTC) by rashyd)

I'm trying to install this mysql package (v5.7.20-1) in Antergos linux and kept failed with this error message:

CMakeFiles/mysqltest_embedded.dir/__/__/client/ In function `main':
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/ undefined reference to `mysql_options'
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/ undefined reference to `mysql_options'
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/ undefined reference to `strmake'
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/ undefined reference to `strmake'
CMakeFiles/mysqltest_embedded.dir/__/__/client/ undefined reference to `my_charset_latin1'
collect2: error: ld returned 1 exit status
make[2]: *** [libmysqld/examples/CMakeFiles/mysqltest_embedded.dir/build.make:99: libmysqld/examples/mysqltest_embedded] Error 1
make[1]: *** [CMakeFiles/Makefile2:8309: libmysqld/examples/CMakeFiles/mysqltest_embedded.dir/all] Error 2
make: *** [Makefile:163: all] Error 2
==> ERROR: A failure occurred in build().

I have made sure my system is up-to-date and I don't have mariadb and libmariasbclient installed.

Fed up with many retries which takes a lot of time to compile, I finally gave up and installed mariadb instead.

muflone commented on 2017-12-17 21:07 (UTC)

@francoism90 that's correct! even the mariadb doesn't launch the mysql_secure_installation, only prints a message to ask the user to execute it, only during the first package installation

francoism90 commented on 2017-12-17 20:53 (UTC)

@Muflone It's more because of the mariadb package does this:

muflone commented on 2017-12-16 16:56 (UTC)

@francoism90 it's not duty of the packager to secure the installation or autoconfigure the server. Moreover the mysql_secure_installation requires user intervention which must not to be done from packages install.

francoism90 commented on 2017-12-12 19:48 (UTC) (edited on 2017-12-12 19:49 (UTC) by francoism90)

Could you add this to .install: mysql_secure_installation

Thanks. :)

muflone commented on 2017-10-03 00:18 (UTC)

I think both packages shares a lot of common files. @gino simply uninstall percona-server-clients and every other percona-server package which is a replacement for mysql

ginoboy commented on 2017-10-03 00:13 (UTC)

without AUR helper.. error: could not perform operation (conflicting files) /usr/share/man/man1/mysqlpump.1.gz exists in both percona-server-clients and mysql the problem is with that conflict.. one solution would't be to remove this man file?

muflone commented on 2017-10-01 15:18 (UTC)

I've just rebuilt the package from scratch and installed it using makepkg -i without any issue. I think your issue is with your AUR helper

ginoboy commented on 2017-09-28 00:42 (UTC)

I have the same problem. :(

muflone commented on 2017-09-27 19:15 (UTC)

@shsina What installer do you use to install mysql and its dependencies?

shsina commented on 2017-09-27 16:15 (UTC)

@Muflone I have same problem but I don't have percona-server-clients installed. The problem is that the installer installs percona-server-clients instead of mariadb-clients.

muflone commented on 2017-09-16 18:39 (UTC)

@ricardofunke Is the percona-server-clients (an alternative mysql) which conflicts with mysql. Pleaase remove it before installing mysql. The same could happen for percona-server package

ricardofunke commented on 2017-09-15 15:17 (UTC) (edited on 2017-09-15 15:18 (UTC) by ricardofunke)

Is it conflicting with its own dependency packages? error: could not perform operation (conflicting files) /usr/share/man/man1/mysqlpump.1.gz exists in both percona-server-clients and mysql

muflone commented on 2017-09-09 16:11 (UTC)

@gamezelda and GregoD try to build the package in a clean chroot (extra-x86-build). I've just built the package again from scratch and it still builds fine.

gregodadone commented on 2017-09-07 12:39 (UTC)

Same error as gamezelda

gamezelda commented on 2017-08-22 22:41 (UTC) (edited on 2017-08-22 22:41 (UTC) by gamezelda)

I get a lot of linker errors when building...: [ 85%] Built target GenYaccEmbeddedSource [ 97%] Built target sql_embedded [ 97%] Built target mysqlserver [ 97%] Linking CXX executable mysqltest_embedded CMakeFiles/mysqltest_embedded.dir/__/__/client/ In function `connection_thread': /tmp/yaourt-tmp-zealcharm/aur-mysql/src/mysql-5.7.19/client/ undefined reference to `mysql_thread_init' /tmp/yaourt-tmp-zealcharm/aur-mysql/src/mysql-5.7.19/client/ undefined reference to `mysql_send_query' /tmp/yaourt-tmp-zealcharm/aur-mysql/src/mysql-5.7.19/client/ undefined reference to `mysql_thread_end' /tmp/yaourt-tmp-zealcharm/aur-mysql/src/mysql-5.7.19/client/ undefined reference to `my_thread_exit' etc. etc. etc. I have all my system updated to the latest of testing. Any idea of what could be the cause?

muflone commented on 2017-06-11 11:48 (UTC)

DOobR Please be sure that your system is fully up-to-date. I've just rebuilt the package in a clean chroot (extra-x86-64) without any issue

DOobR commented on 2017-06-11 00:12 (UTC) (edited on 2017-06-11 00:12 (UTC) by DOobR)

% yaourt -Su % % makepkg -s ... /aur-libmysqlclient/src/mysql-5.7.18/vio/viosslfactories.c:124:7: error: dereferencing pointer to incomplete type ‘DH {aka struct dh_st}’ dh->p=BN_bin2bn(dh2048_p,sizeof(dh2048_p),NULL); ^~ ...

sainoba commented on 2017-05-08 00:25 (UTC)

@Muflone Thank you for your fast response. It seems you are right. I was using Manjaro, which doesn't have the most up to date packages. I tried installing mysql in actual Archlinux and I had no problems.

muflone commented on 2017-05-06 22:47 (UTC)

@sainoba please check if you have your system up to date. if the error persists build in a clean root, I've just rebuilt the package without any issue.

sainoba commented on 2017-05-03 16:52 (UTC)

Compilation has failed with the following error message: [ 48%] Building CXX object sql/CMakeFiles/sql.dir/ /home/sainoba/Downloads/mysql/src/mysql-5.7.18/sql/ In function ‘int init_ssl()’: /home/sainoba/Downloads/mysql/src/mysql-5.7.18/sql/ error: ‘OPENSSL_malloc_init’ was not declared in this scope OPENSSL_malloc_init(); ^ make[2]: *** [sql/CMakeFiles/sql.dir/build.make:5055: sql/CMakeFiles/sql.dir/] Error 1 make[1]: *** [CMakeFiles/Makefile2:7806: sql/CMakeFiles/sql.dir/all] Error 2 I tried it using: $ git clone $ cd mysql $ makepkg -cCifs and yaourt. Same result.

Sirced commented on 2017-01-24 23:47 (UTC)

@mrrabinhalder @matoro I was running into the same issue. I fixed it by manually removing my previous maraidb installation before installing. For me it was mariadb-clients, libmariasbclient and mariadb. Possibly they should be conflicting but aren"t. Hope this helps.

mrrabinhalder commented on 2016-12-25 13:21 (UTC)

Compilation has failed with the following error message: [ 53%] Linking CXX executable pfs_connect_attr-t ../libperfschema.a( In function `fct_update_file_derived_flags': /home/rhalder/aur/yaourt-tmp-rhalder/aur-mysql/src/mysql-5.7.16/storage/perfschema/ relocation truncated to fit: R_X86_64_16 against symbol `sanitize_file_class(PFS_file_class*)' defined in .text section in ../libperfschema.a( ../../innobase/libinnobase.a( In function `std::__cxx11::basic_ostringstream<char, std::char_traits<char>, std::allocator<char> >::basic_ostringstream(std::_Ios_Openmode)': /usr/include/c++/6.2.1/sstream:549:(.text+0x73c1): relocation truncated to fit: R_X86_64_16 against symbol `std::basic_ios<char, std::char_traits<char> >::init(std::basic_streambuf<char, std::char_traits<char> >*)@@GLIBCXX_3.4' defined in .plt section in /usr/lib/gcc/x86_64-pc-linux-gnu/6.2.1/../../../../lib/crt1.o collect2: error: ld returned 1 exit status make[2]: *** [storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/build.make:197: storage/perfschema/unittest/pfs_connect_attr-t] Error 1 make[1]: *** [CMakeFiles/Makefile2:1705: storage/perfschema/unittest/CMakeFiles/pfs_connect_attr-t.dir/all] Error 2 make: *** [Makefile:161: all] Error 2 Any help?

matoro commented on 2016-09-14 03:45 (UTC)

Compilation is failing with the following error message: CMakeFiles/mysqltest_embedded.dir/__/__/client/ undefined reference to `my_charset_latin1' collect2: error: ld returned 1 exit status make[2]: *** [libmysqld/examples/CMakeFiles/mysqltest_embedded.dir/build.make:99: libmysqld/examples/mysqltest_embedded] Error 1 make[1]: *** [CMakeFiles/Makefile2:7972: libmysqld/examples/CMakeFiles/mysqltest_embedded.dir/all] Error 2 make: *** [Makefile:161: all] Error 2 List of packages I have installed: It's on a standard x86_64 laptop, kernel version 4.7.2. Any help?

muflone commented on 2016-07-02 16:05 (UTC)

@colshacol the 'provides' option is used to mark the package as a replacement for another package. If some application has mariadb like dependency (any package in the official repository cannot have a dependency on mysql), this package can be a candidate for replacement. Obviously the two packages are different in many ways.

kerberizer commented on 2016-07-01 12:37 (UTC)

I think those AUR helpers should be banned. :) @colshacol, on a more serious note, what's the AUR helper that you used to install this package, indeed? If that sounds like Chinese to you, then just please explain briefly how you installed MySQL.

colshacol commented on 2016-07-01 12:24 (UTC)

@Muflone Forgive my novice, I have never used MySQL nor MariaDB. But, I saw that you said that this has nothing to do with MariaDB, yet it says "provides: mariadb" above, and upon checking mysql --version, I get "Ver 15.1 Distrib 10.1.14-MariaDB, for Linux (x86_64) using readline 5.1". I am not complaining. I do not even know the difference! I am just curious as to why you say it is not related to Maria at all.

ijann commented on 2016-06-28 00:27 (UTC) (edited on 2016-06-28 00:28 (UTC) by ijann)

My apologies, that line of code @kerberizer I fix everything the problem, that rare that pass this, anyway I regret the anger I had with @Muflone, I'm happy :D video remove translate with Bing

muflone commented on 2016-06-27 21:14 (UTC)

I hope it will be cleared that your AUR helper (the program you're using to download the packages) is doing mess. The package mysql is in the AUR while the package mariadb is in the official Arch Linux repository. Your AUR helper is downloading mariadb from the repository instead of the AUR package mysql. Just download the package from the AUR, like kerberizer pointed and be happy with mysql.

ijann commented on 2016-06-27 21:05 (UTC)

ok @kerberizer take what I say and you dare my conclusions. Not understand that this repository will not arrange the pkgbuild and is avoid this mess, Thanks for responding

kerberizer commented on 2016-06-27 20:32 (UTC) (edited on 2016-06-27 20:33 (UTC) by kerberizer)

@ijann, as Scimmia already explained, the problem is with __your__ AUR helper, whatever it is. Please use plain makepkg instead, e.g.: $ git clone $ cd mysql $ makepkg -cCifs Better yet, read about it on the Wiki. There's information in Spanish too... Edit: Unfortunately, the links got broken, so please use copy-paste on them instead.

muflone commented on 2016-06-25 15:21 (UTC)

@ijann your english is awful. there's nothing wrong with this package and it's not related in any way with mariadb. This IS the mysql package from the original source code

Scimmia commented on 2016-06-22 01:36 (UTC)

ijann, that looks like your AUR helper screwing up, nothing more.

ijann commented on 2016-06-21 23:50 (UTC) explain this I see and says MariaDB clearly I saw the pkbuild but nothing like when I install mysql, only when I install mysql56 if you do what is in the pkbuild, but with the version mysql5.6 I pass some pictures of my installation with version 5.6

Scimmia commented on 2016-06-21 23:25 (UTC)

ijann, what the hell are you talking about. Look at the PKGBUILD, look at what it downloads. This has nothing to do with MariaDB.

nebulon commented on 2016-06-17 13:17 (UTC)

Is there any pacman repository available with pre-built packages of mysql? I don't actually have that much free hard disk space available, as the whole package building takes over 4GB!

kerberizer commented on 2016-06-05 01:20 (UTC) (edited on 2016-06-05 01:22 (UTC) by kerberizer)

@fazal, that's because GCC 6 switched the default mode for C++ from -std=gnu++98 to -std=gnu++14.[1] The simple fix is to add "-std=gnu++98" to CMAKE_CXX_FLAGS, e.g. like this (also including the changes to 5.7.13): Edit: Replaced the ugly diff with link to hastebin. ---- 1.

fazal commented on 2016-05-24 09:17 (UTC)

I'm getting this error: ```` /tmp/yaourt-tmp-fazal/aur-mysql/src/mysql-5.7.12/client/ In function ‘int parse_cnf_file(std::istream&, std::map<std::__cxx11::basic_string<char>, std::__cxx11::basic_string<char> >*, const string&)’: /tmp/yaourt-tmp-fazal/aur-mysql/src/mysql-5.7.12/client/ error: no matching function for call to ‘make_pair(std::__cxx11::string&, std::__cxx11::string&)’ options->insert(make_pair<string, string >(option_name, option_value)); ^ In file included from /usr/include/c++/6.1.1/bits/stl_algobase.h:64:0, from /usr/include/c++/6.1.1/bits/char_traits.h:39, from /usr/include/c++/6.1.1/ios:40, from /usr/include/c++/6.1.1/istream:38, from /usr/include/c++/6.1.1/sstream:38, from /tmp/yaourt-tmp-fazal/aur-mysql/src/mysql-5.7.12/client/ /usr/include/c++/6.1.1/bits/stl_pair.h:425:5: note: candidate: template<class _T1, class _T2> constexpr std::pair<typename std::__decay_and_strip<_Tp>::__type, typename std::__decay_and_strip<_T2>::__type> std::make_pair(_T1&&, _T2&&) make_pair(_T1&& __x, _T2&& __y) ^~~~~~~~~ /usr/include/c++/6.1.1/bits/stl_pair.h:425:5: note: template argument deduction/substitution failed: /tmp/yaourt-tmp-fazal/aur-mysql/src/mysql-5.7.12/client/ note: cannot convert ‘option_name’ (type ‘std::__cxx11::string {aka std::__cxx11::basic_string<char>}’) to type ‘std::__cxx11::basic_string<char>&&’ options->insert(make_pair<string, string >(option_name, option_value)); ^ client/CMakeFiles/mysql_install_db.dir/build.make:86: recipe for target 'client/CMakeFiles/mysql_install_db.dir/' failed make[2]: *** [client/CMakeFiles/mysql_install_db.dir/] Error 1 CMakeFiles/Makefile2:6495: recipe for target 'client/CMakeFiles/mysql_install_db.dir/all' failed make[1]: *** [client/CMakeFiles/mysql_install_db.dir/all] Error 2 Makefile:160: recipe for target 'all' failed make: *** [all] Error 2 ````

basil commented on 2016-05-03 14:23 (UTC)

You can also use something like TMPDIR=$HOME/scratch yaourt -S mysql to use a different temporary directory for this install only. In this case you don't actually have to increase your /tmp partition size.

Scindix commented on 2016-05-03 11:54 (UTC) (edited on 2016-05-03 12:55 (UTC) by Scindix)

There must be some kind of error in the build system. No matter how much space I free on my hard drive, I keep getting this error: /usr/bin/ar: libsql_embedded.a: No space left on device libmysqld/CMakeFiles/sql_embedded.dir/build.make:5938: recipe for target 'libmysqld/libsql_embedded.a' failed make[2]: *** [libmysqld/libsql_embedded.a] Error 1 make[2]: *** Deleting file 'libmysqld/libsql_embedded.a' CMakeFiles/Makefile2:7748: recipe for target 'libmysqld/CMakeFiles/sql_embedded.dir/all' failed make[1]: *** [libmysqld/CMakeFiles/sql_embedded.dir/all] Error 2 Makefile:160: recipe for target 'all' failed make: *** [all] Error 2 ==> ERROR: A failure occurred in build(). Aborting... ==> ERROR: Makepkg was unable to build mysql. ==> Restart building libmysqlclient ? [y/N] Note that on root I have 134.92 GB free space now. I don't have external system or home partitions so why am I getting this error? EDIT: Solved the problem myself. Although there was enough space on my hd the compiler exceeded the limit of 4GB on /tmp (set by default to the half of your RAM size). I increased it and it worked. However it would be nice if this would be checked before the compilation process as the usage of /tmp rose to about 7GB. It would have saved me a lot of time.

muflone commented on 2016-03-05 17:18 (UTC)

@graysky the package mysql provides the library, the latest version. If the kodi package needs an older version you should rebuild the kodi package with mysql 5.7 (if supported) or use the mysql 5.6 package.

graysky commented on 2016-03-05 11:19 (UTC) (edited on 2016-03-05 11:20 (UTC) by graysky)

Something is wrong with the libmysqlclient package as it relating to kodi. If I use this AUR package as a substitute for [extra]/mariadb and try to run kodi, I get: /usr/lib/kodi/kodi.bin: error while loading shared libraries: cannot open shared object file: No such file or directory

muflone commented on 2016-02-06 19:54 (UTC)

The boost issue was fixed, thanks to Norvald H. Ryeng of MySQL.

basil commented on 2016-02-04 20:47 (UTC)

This still doesn't work. Any workarounds?

Scindix commented on 2016-01-08 08:44 (UTC) (edited on 2016-01-08 11:36 (UTC) by Scindix)

@tle Having exactly the same problem... I need libmysqlclient to install the root library (by CERN) Is there a fast workaround that I can do to make it work? (Unfortunately I'm not really familiar with cmake, so I couldn't help myself on that one) The only thing that I found is to open /usr/include/boost/version.hpp and change the version during installation. However that doesn't seem right even for a workaround. It compiles, but I'm not sure yet if it really works. It would be really nice if you could submit a patch. Update: okay it fails to compile. /usr/include/boost/geometry/util/has_non_finite_coordinate.hpp:42:12: error: ‘has_coordinate_with_property’ is not a member of ‘boost::geometry::detail’ return detail::has_coordinate_with_property ^ /usr/include/boost/geometry/util/has_non_finite_coordinate.hpp:44:18: error: expected primary-expression before ‘,’ token Point, ^ /usr/include/boost/geometry/util/has_non_finite_coordinate.hpp:45:34: error: expected primary-expression before ‘,’ token detail::is_not_finite, ^ /usr/include/boost/geometry/util/has_non_finite_coordinate.hpp:50:10: error: ‘::apply’ has not been declared >::apply(point); ^ Seems that mysql really need that old version of boost.

tle commented on 2016-01-05 12:10 (UTC)

Hi folks It seems to me MySQL is quite strict on the version of boost. I failed installing with following error: ``` -- Found /usr/include/boost/version.hpp -- BOOST_VERSION_NUMBER is #define BOOST_VERSION 106000 CMake Warning at cmake/boost.cmake:256 (MESSAGE): Boost minor version found is 60 we need 59 Call Stack (most recent call first): CMakeLists.txt:435 (INCLUDE) -- BOOST_INCLUDE_DIR /usr/include -- LOCAL_BOOST_DIR -- LOCAL_BOOST_ZIP -- Could not find (the correct version of) boost. -- MySQL currently requires boost_1_59_0 CMake Error at cmake/boost.cmake:76 (MESSAGE): You can download it with -DDOWNLOAD_BOOST=1 -DWITH_BOOST=<directory> This CMake script will look for boost in <directory>. If it is not there, it will download and unpack it (in that directory) for you. If you are inside a firewall, you may need to use an http proxy: export http_proxy= Call Stack (most recent call first): cmake/boost.cmake:259 (COULD_NOT_FIND_BOOST) CMakeLists.txt:435 (INCLUDE) -- Configuring incomplete, errors occurred! See also "/tmp/yaourt-tmp-tle/aur-mysql/src/build/CMakeFiles/CMakeOutput.log". ``` As you can see above the version that MySQL asked for is minor 59, whilst I have 60. I am more than happy to submit a patch if no one's up for it.

twheel commented on 2015-11-11 11:44 (UTC)

Postfix won't start after the upgrade to mysql-5.7: "postfix: error while loading shared libraries: cannot open shared object file: No such file or directory"

muflone commented on 2015-11-01 23:46 (UTC)

Updated to version 5.7 version 5.6 users could move to the mysql56 package

wolftankk commented on 2015-09-28 16:09 (UTC) cannot open shared object file it need rebuilding ..

Marcel_K commented on 2015-07-30 13:43 (UTC)

I had no problem downloading from that location, although another issue popped up: there is no GPG signature at, only at If you change the first line in the source array and add a validpgpkeys entry like validpgpkeys=('A4A9406876FCBD3C456770C88C718D3B5072E1F5') source=("${pkgbase}-${pkgver}.tar.gz"{,.asc} the tarball is checked for being genuine, too.

lucc commented on 2015-07-30 13:23 (UTC)

Is it possible that the upstream website does not support the https links in the PKGBUILD? I had trouble opening the website or downloading the tarball until I removed the "s".

muflone commented on 2014-12-23 23:04 (UTC)

@nicolascevallos use pactree (and pactree -r) to discover why your installation requires you to install mysql-connector-c. The forum is the best way to try to solve your issues. I cannot help you as the issue doesn't seem related in any way to any of my packages.

nicolascevallos commented on 2014-12-23 17:59 (UTC)

Muflone, thanks for your response. I downloaded the last shared component in a rpm file from and I see that the file of is and it is different from the last version of Connector/C (libmysqlclient) package in As in my last message of mysql-connector-c package, I don't know why mysql-connector-c need an update if it's not installed :( And I don't understand why mysql-connector-c needs libmariadbclient/libmysqlclient. Please, notify me if I can do something to help! :)

muflone commented on 2014-12-23 16:02 (UTC)

Indeed the package mysql is out of date, a new 5.6.22 version was released a couple of days ago [1]. I'll update this package very soon after a short test. However about the conflicting files there's nothing that I can do. The package libmysqlclient provides the libmysqlclient library, and the mysql-connector-c packages provides its copy of libmysqlclient, then the two packages conflicts. I think the mysql-connector-c package shouldn't provide its copy of the libmysqlclient library or if it must have such version, then it should be installed in a dedicated folder. Obviously the same applies also to all the other similar conflicting files. The final option would be that mysql-connector-c applies a conflicts options in the PKGBUILD to avoid conflicting files and then avoiding that both mysql and mysql-connector-c would be installed together. [1]

nicolascevallos commented on 2014-12-22 23:17 (UTC)

The last changes in this package causes an update in mysql-connector-c, even if is not installed. The installation of mysql-connector-c causes an error because any files exists in the file system, such as /usr/bin/perror, /usr/bin/my_config and /usr/lib/libmysqlclient* links. I hack the problem renaming the filenames in conflict and the package mysql-connector-c compiles the, when the package libmysqlclient compiles the !!! This package is out of date?

muflone commented on 2014-11-28 17:43 (UTC)

Package updated to version 5.6.21

muflone commented on 2014-11-17 10:29 (UTC)

@sparse you should download the source again, the checksum is correct to me

sparse commented on 2014-11-17 07:45 (UTC)

Validating source files with sha256sums... mysql-5.6.20.tar.gz ... FAILED ... Passed mysqld-tmpfile.conf ... Passed mysqld.service ... Passed mysql-srv_buf_size.patch ... Passed

muflone commented on 2014-11-12 12:34 (UTC)

Please discuss the whole thing in the ML I'm open to suggest but actually I'm not convinced the issue should be searched in this package, built with the same no-rtti flag as the mariadb-clients

mpz commented on 2014-11-11 18:14 (UTC)

Please remove "-fno-rtti" flag as noted by Marcel_K. It's causing unnecessary problems for people.

Marcel_K commented on 2014-10-10 16:11 (UTC)

Why are you building these packages with -fno-rtti? Only to save a bit of memory? FYI, this causes problems when compiling mysql-connector-c++ [1]: ‘dynamic_cast’ not permitted with -fno-rtti. Removing that flag here solves this issue. BTW, I got a warning "Package contains reference to $srcdir" at the end of package_mysql(). [1]

e8hffff commented on 2014-05-07 01:27 (UTC)

Arr worked out problem. Somehow 'other' read access was off on the 'php.ini'. I got fooled the ini had loaded as some sets were custom ot manually changed in php.

e8hffff commented on 2014-05-07 01:11 (UTC)

Is anyone else got problems with mysql or mysqli working? Checking extensions mysqlnd is loaded so I should have access. The ini has the extensions enabled for mysql and mysqli. In php the commands of these feature sets instantly kills the script without error. I had them working but after an update they stopped. I tried reinstalling all components. Getting no errors to indicate what's wrong. Are these features built at build time?

rustam commented on 2013-12-06 08:57 (UTC)

Updated to v5.6.15.

stevenfrog commented on 2013-11-14 01:06 (UTC)

But now many package depend on mariadb, so I have to keep it. And I just not install libmysqlclient, and it seems work fine.

rustam commented on 2013-11-13 15:19 (UTC)

It is supposed to conflict w/ mariadb and both mysql and mariadb shouldn't be installed at the same time since mariadb is designed as a drop-in replacement for mysql and they have the same paths to binaries, configs, dbs, etc.

stevenfrog commented on 2013-11-13 15:13 (UTC)

"libmysqlclient and libmariadbclient are in conflict" I think we should not make 'libmysqlclient', because it conflict to arch default package.

enteenteente commented on 2013-10-03 12:28 (UTC)

- comment removed, just relaized: "Warning: The group base-devel is assumed already installed when building with makepkg . Members of "base-devel" should not be included in makedepends arrays." sorry!

sitquietly commented on 2013-09-11 21:58 (UTC)

Thanks for keeping mysql available on Arch! The current situation with mariadb is a mess. mariadb won't compile against boost-1.54, but mysql is working fine for me. Now I understand why Beyond Linux From Scratch calls for mysql-5.6.13 along with boost-1.54.

rustam commented on 2013-08-21 14:20 (UTC)

@landif: I've added a patch for this problem.

commented on 2013-08-19 22:10 (UTC)

I keep getting this compilation error in all machine i have tried to build on: [ 40%] Building CXX object storage/innobase/CMakeFiles/innobase.dir/row/ /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ In function ‘dberr_t row_log_table_apply_ops(que_thr_t*, row_merge_dup_t*)’: /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ error: ‘srv_buf_size’ was not declared in this scope ofs, srv_buf_size); ^ /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ In function ‘dberr_t row_log_apply_ops(trx_t*, dict_index_t*, row_merge_dup_t*)’: /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ error: ‘srv_buf_size’ was not declared in this scope ofs, srv_buf_size); ^ /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ In function ‘dberr_t row_log_table_apply_ops(que_thr_t*, row_merge_dup_t*)’: /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ warning: ignoring return value of ‘int ftruncate(int, __off64_t)’, declared with attribute warn_unused_result [-Wunused-result] ftruncate(index->online_log->fd, 0); ^ /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ In function ‘dberr_t row_log_apply_ops(trx_t*, dict_index_t*, row_merge_dup_t*)’: /root/packages/mysql/src/mysql-5.6.13/storage/innobase/row/ warning: ignoring return value of ‘int ftruncate(int, __off64_t)’, declared with attribute warn_unused_result [-Wunused-result] ftruncate(index->online_log->fd, 0); ^ make[2]: *** [storage/innobase/CMakeFiles/innobase.dir/row/] Error 1 make[1]: *** [storage/innobase/CMakeFiles/innobase.dir/all] Error 2 make: *** [all] Error 2 ==> ERROR: A failure occurred in build(). Aborting...

commented on 2013-07-10 23:45 (UTC)

@rustam problem FIXED!

rustam commented on 2013-07-10 11:19 (UTC)

@vfbsilva: I've updated the package so it now cleans out the build directory before building, this should resolve the problem.

commented on 2013-07-10 04:21 (UTC)

I cannot build this package ==> Making package: mysql 5.6.12-2 (Wed Jul 10 01:13:20 BRT 2013) ==> Checking runtime dependencies... ==> Checking buildtime dependencies... ==> Retrieving sources... -> Found mysql-5.6.12.tar.gz -> Found mysql-5.6.12.tar.gz.asc -> Found -> Found mysqld-tmpfile.conf -> Found mysqld.service ==> Validating source files with sha256sums... mysql-5.6.12.tar.gz ... Passed mysql-5.6.12.tar.gz.asc ... Skipped ... Passed mysqld-tmpfile.conf ... Passed mysqld.service ... Passed ==> Verifying source file signatures with gpg... mysql-5.6.12.tar.gz ... FAILED (unknown public key 8C718D3B5072E1F5) ==> WARNING: Warnings have occurred while verifying the signatures. Please make sure you really trust them. ==> Extracting sources... -> Extracting mysql-5.6.12.tar.gz with bsdtar ==> Removing existing pkg/ directory... ==> Starting build()... mkdir: cannot create directory ‘build’: File exists ==> ERROR: A failure occurred in build(). Aborting... The build failed. local database is up to date How should I proceed?

rustam commented on 2013-06-13 09:07 (UTC)

Ah, I see now. On my systems it just throws a warning but doesn't prevent building, and I can see the same in the Arch wiki Not sure why it's the error in your case. The reason for this verification failure is that Oracle's GPG keys are not added to the keyring. So, successful GPG checking would require you to manually init the keyring and import their key, run: gpg --list-keys gpg --recv-keys 8C718D3B5072E1F5 Then try installing aur/mysql again, it should resolve the problem. Probably I will need to drop gpg checking in this AUR package, as it makes no sense for me manually adding the signature, or build another package with their keyring and install it prior to MySQL installation as a dependency.

kralibes commented on 2013-06-13 06:13 (UTC)

With yaourt. Now I see that it's not a checksum error but an error of failing gpg signature - sorry for this. (german) ==> Überprüfe Signaturen der Quell-Dateien mit gpg... mysql-5.6.11.tar.gz ... FEHLGESCHLAGEN ==> FEHLER: Eine oder mehrere PGP-Signaturen konnten nicht überprüft werden. ==> ERROR: Makepkg was unable to build mysql. ==> Restart building mysql ? [y/N] ==> ------------------------------

rustam commented on 2013-06-11 18:38 (UTC)

@kralibes: I see no issues with checksums; double checked it and it's valid and the package builds on my machines. Do you use yaourt or manually downloaded the pkgbuild and building in a directory with makepkg? In the latter case, try removing mysql-5.6.11.tar.gz and re-download it.

kralibes commented on 2013-06-11 18:10 (UTC)

No valid checksum for mysql 5.6.11.

rustam commented on 2013-05-29 10:20 (UTC)

MySQL 5.6.11 is the current stable GA release, so I'm gonna update this package to that version shortly. I've submitted the mysql55 package for those who still need v5.5.

Barthalion commented on 2013-05-16 13:01 (UTC)

If you don't have time to compile new release on your own, I uploaded signed packages here: