Arch Linux User Repository

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

diff --git a/PKGBUILD b/PKGBUILD
index 2191850..e1f14ce 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -57,9 +57,9 @@ build() {
     -DINSTALL_SHAREDIR=share/mysql \
     -DROUTER_INSTALL_CONFIGDIR=etc/mysqlrouter \
     -DROUTER_INSTALL_DATADIR=var/lib/mysqlrouter \
     -DROUTER_INSTALL_RUNTIMEDIR=run \
-    -DROUTER_INSTALL_LOGDIR=var/log/mysqlrouter \
+    -DROUTER_INSTALL_LOGDIR=/var/log/mysqlrouter \
     -DWITH_SYSTEM_LIBS=ON \
     -DWITH_FIDO=system \
     -DWITH_SSL=system \
     -DWITH_LIBWRAP=OFF \
@@ -144,8 +144,9 @@ package_mysql-clients(){
 package_mysql(){
   pkgdesc="Fast SQL database server, community edition"
   backup=("etc/mysql/my.cnf"
           "etc/mysqlrouter/mysqlrouter.conf"
+          "etc/logrotate.d/mysqlrouter"
           "etc/conf.d/${pkgname}.conf")
   install="${pkgbase}.install"
   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

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 /.

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
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -6,7 +6,9 @@

 pkgname=('mysql' 'libmysqlclient' 'mysql-clients')
 pkgbase=mysql
-pkgver=8.0.25
+majorver=8.0
+minor=26
+pkgver="$majorver.$minor"
 pkgrel=1
 pkgdesc="Fast SQL database server, community edition"
 arch=('x86_64')
@@ -22,7 +24,7 @@ source=("https://cdn.mysql.com/Downloads/MySQL-8.0/${pkgbase}-boost-${pkgver}.ta
         "mysqld_service.patch"
         "systemd-tmpfiles.patch"
         "systemd-sysusers.conf")
-sha256sums=('93c5f57cbd69573a8d9798725edec52e92830f70c398a1afaaea2227db331728'
+sha256sums=('209442c1001c37bcbc001845e1dc623d654cefb555b47b528742a53bf21c0b4d'
             '6bc24ae510f6b6bbad6b3edda2d0028b29292937b482274a4c2fae335f4de328'
             'e1c23fa0971a13d998f2790379b68c475438d05b6d6f2691b99051dbf497567f'
             '203dcd22fea668477ac7123dbd9909fae72d3d07f8855417a669a9c94db072ae'
@@ -79,7 +81,8 @@ build() {
     -DCMAKE_CXX_LINK_FLAGS="${LDFLAGS}" \
     -DDEFAULT_CHARSET=utf8mb4 \
     -DDEFAULT_COLLATION=utf8mb4_unicode_ci \
-    -DWITH_BOOST="../${pkgname}-${pkgver}/boost"
+    -DWITH_BOOST="../${pkgname}-${pkgver}/boost" \
+    $EXTRA_MYSQL_OPTS
   make
 }

@@ -166,11 +169,10 @@ package_mysql(){
   rm "${pkgdir}/usr/lib/libmysqlclient.a"
   rm "${pkgdir}/usr/lib/libmysqlclient.so"
   rm "${pkgdir}/usr/lib/libmysqlclient.so.21"
-  rm "${pkgdir}/usr/lib/libmysqlclient.so.21.1.25"
+  rm "${pkgdir}/usr/lib/libmysqlclient.so.21.1.$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/authentication_ldap_sasl_client.so"
   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!

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

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

@hxss fixed

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

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...

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

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

Incorporated FrederickZh's fixes, Thank you

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

I added: export CXXFLAGS="${CXXFLAGS} -DU_DEFINE_FALSE_AND_TRUE=1"

before the:

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

and now the compilation finishes

Please add FrederickZh's patch.

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

diff --git a/sql/mysqld.cc b/sql/mysqld.cc
index 51992613..0dc0c7c4 100644
--- a/sql/mysqld.cc
+++ b/sql/mysqld.cc
@@ -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)

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

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

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
owners.

Configuration read from the following files in the given order (enclosed
in parentheses means not available for reading):
  (/usr/bin/.././mysqlrouter.conf)
  (/usr/bin/.././mysqlrouter.ini)
  (/home/frederick/.mysqlrouter.conf)
  (/home/frederick/.mysqlrouter.ini)
Plugins Path:
  /usr/lib/mysqlrouter

Default Log Directory:
  /usr

Default Persistent Data Directory:
  /usr/bin/../var/lib/mysqlrouter

Default Runtime State Directory:
  /usr/bin/../run

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

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

 build() {
   rm -rf build
   mkdir build
@@ -52,8 +52,12 @@ build() {
     -DINSTALL_SUPPORTFILESDIR=share/mysql \
     -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_RUNTIMEDIR=../run \
+    -DROUTER_INSTALL_LOGDIR=../var/log/mysqlrouter \
     -DWITH_SYSTEM_LIBS=ON \
     -DWITH_SSL=system \
     -DWITH_LIBWRAP=OFF \
     -DWITH_LTO=ON \
@@ -135,8 +139,9 @@ package_mysql-clients(){

 package_mysql(){
   pkgdesc="Fast SQL database server, community edition"
   backup=("etc/mysql/my.cnf"
+          "etc/mysqlrouter/mysqlrouter.conf"
           "etc/conf.d/${pkgname}.conf")
   install="${pkgbase}.install"
   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/ld.so.conf.d"
   install -m 644 -D "${srcdir}/mysql-ld.so.conf" "${pkgdir}/etc/ld.so.conf.d/${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
   fi

+  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(){
   fi
   if getent group mysql >/dev/null 2>&1; then
     groupdel mysql
   fi
+  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):
  /etc/mysqlrouter/mysqlrouter.conf
  (/etc/mysqlrouter/mysqlrouter.ini)
  (/home/frederick/.mysqlrouter.conf)
  (/home/frederick/.mysqlrouter.ini)
Plugins Path:
  /usr/lib/mysqlrouter

Default Log Directory:
  /var/log/mysqlrouter

Default Persistent Data Directory:
  /var/lib/mysqlrouter

Default Runtime State Directory:
  /run

PS: this might be useful https://koji.mbox.centos.org/pkgs/packages/mysql/8.0.21/1.module_el8.2.0+493+63b41e36/data/logs/x86_64/build.log

@ruidc mysqlbinlog is included in the mysql package

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

mysqld: error while loading shared libraries: libicuuc.so.67: cannot open shared object file: No such file or directory

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

A new version is available (8.0.22) https://dev.mysql.com/downloads/mysql

@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
/usr/bin/mysql_config_editor
/usr/share/man/man1/mysql_config_editor.1.gz

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!

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?

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

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

@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 = https://cdn.mysql.com/Downloads/MySQL-8.0/mysql-boost-8.0.17.tar.gz
    source = my-default.cnf
    source = mysql-ld.so.conf
    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
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -11,9 +11,9 @@ pkgrel=1
 pkgdesc="Fast SQL database server, community edition"
 arch=('x86_64')
 makedepends=('openssl' 'zlib' 'cmake' 'systemd-tools' 'libaio' 'jemalloc'
              'rpcsvc-proto' 'libtirpc' 'icu' 'libedit' 'libevent' 're2'
-             'rapidjson' 'protobuf')
+             'rapidjson')
 license=('GPL')
 url="https://www.mysql.com/products/community/"
 source=("https://cdn.mysql.com/Downloads/MySQL-8.0/${pkgbase}-boost-${pkgver}.tar.gz"
         "my-default.cnf"
@@ -59,8 +59,9 @@ build() {
     -DWITH_LTO=ON \
     -DWITH_JEMALLOC=ON \
     -DWITH_READLINE=ON \
     -DWITH_SYSTEMD=yes \
+    -DWITH_PROTOBUF=bundled \
     -DWITH_UNIT_TESTS=OFF \
     -DPLUGIN_EXAMPLE=NO \
     -DWITHOUT_EXAMPLE_STORAGE_ENGINE=ON \
     -DPLUGIN_FEDERATED=NO \
@@ -138,9 +139,9 @@ package_mysql(){
   backup=("etc/mysql/my.cnf"
           "etc/conf.d/${pkgname}.conf")
   install="${pkgbase}.install"
   depends=('mysql-clients' 'libsasl' 'zlib' 'jemalloc' 'libaio' 'libtirpc' 'icu'
-           'lz4' 'libevent' 'protobuf' 'systemd-libs')
+           'lz4' 'libevent' 'systemd-libs')
   conflicts=('mariadb')
   provides=("mariadb=${pkgver}" "mysql=${pkgver}")
   optdepends=('perl-dbd-mysql: for mysqlhotcopy, mysql_convert_table_format and mysql_setpermission')
   options=('emptydirs')

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

Using the flag -DWITH_SYSTEM_LIBS=OFF during the compilation helped me to fix the problem https://bugs.mysql.com/bug.php?id=95287 "mysql client ignores ~/.editrc. bind "^W" ed-delete-prev-word doesn't work"

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 (https://pastebin.com/wtVwRgFt) which prevents removing it. Would you mind consider applying it?

BR Rudi

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: https://gist.github.com/Frederick888/dbc2b80f176d79dcfbd7fb4bafac178a

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. innodb_engine.so, are not even built tho (didn't see them in cmake --build . --target help).

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

 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
   do
     make -C "${dir}" DESTDIR="${pkgdir}" install
   done
+  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}/mysql-ld.so.conf" "${pkgdir}/etc/ld.so.conf.d/${pkgname}.conf"

   # provided by libmysqlclient
   rm "${pkgdir}/usr/bin/mysql_config"
+  rm "${pkgdir}/usr/lib/libmysqlclient.a"
   rm "${pkgdir}/usr/lib/libmysqlclient.so"
   rm "${pkgdir}/usr/lib/libmysqlclient.so.21"
   rm "${pkgdir}/usr/lib/libmysqlclient.so.21.1.17"
   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"

@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?

@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

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?

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

@tlo MySQL should now automatically upgrade:

https://mysqlserverteam.com/mysql-8-0-16-mysql_upgrade-is-going-away/

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

@francoism90

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

@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.

$ mysqld --initialize --user=mysql

mysqld: error while loading shared libraries: libicuuc.so.63: cannot open shared object file: No such file or directory

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

@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: https://github.com/francoism90/pkgs/tree/master/mysql

It would be great if you take a look and tell me what you think. :) I did not use mysql-ld.so.conf and mysqld-post.sh, are they still needed?

@Muflone Seems MySQL provide systemd service OOTB: https://github.com/mysql/mysql-server/tree/8.0/scripts/systemd

https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html#option_cmake_with_systemd https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html#option_cmake_with_system_libs

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

Would LTO help to optimize MySQL?

https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html#option_cmake_with_lto

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 https://bugs.mysql.com/bug.php?id=95287#c488633

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

@Khaithang try yay mysql-clients

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

I have submitted a bug report https://bugs.mysql.com/bug.php?id=95287

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

@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.

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

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.

can you please update to support protobuf-3.7 ?

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.

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

@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
  "/tmp/yaourt-tmp-torquerrr/aur-mysql/src/build/runtime_output_directory/mysqld"
  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().
    Aborting...
==> 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.

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

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

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

@tlo certificate renewed. thank you

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

It would appear that your certificate has expired.

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.

https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html

@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.

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

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

@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

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

@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?

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

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.

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

@Muflone Thanks for the update. :)

here's 8.0 :-)

@Muflone Any update on the 8.0 release? :)

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

https://dev.mysql.com/downloads/mysql/ - big jump!

Before upgrading, are manual actions needed?

@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

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

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)

[muflone-mysql]
SigLevel = Required
Server = https://www.muflone.com/repositories/archlinux/$repo/$arch

mysql is included in ArchlinuxCN repository. Please add these

[archlinuxcn] Server = http://repo.archlinuxcn.org/$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.

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

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/mysqltest.cc.o: In function `main':
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/mysqltest.cc:9251: undefined reference to `mysql_options'
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/mysqltest.cc:9248: undefined reference to `mysql_options'
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/mysqltest.cc:9524: undefined reference to `strmake'
/tmp/pamac-build-user1/mysql/src/mysql-5.7.20/client/mysqltest.cc:9519: undefined reference to `strmake'
CMakeFiles/mysqltest_embedded.dir/__/__/client/mysqltest.cc.o:(.data.rel+0x13e0): 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().
    Aborting...

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.

@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

@Muflone It's more because of the mariadb package does this: https://git.archlinux.org/svntogit/packages.git/tree/trunk/mariadb.install?h=packages/mariadb

@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.

Could you add this to .install: mysql_secure_installation

Thanks. :)