Package Details: mysql 8.0.30-1

Git Clone URL: https://aur.archlinux.org/mysql.git (read-only, click to copy)
Package Base: mysql
Description: Fast SQL database server, community edition
Upstream URL: https://www.mysql.com/products/community/
Licenses: GPL
Conflicts: mariadb
Provides: mariadb, mysql
Submitter: Barthalion
Maintainer: muflone
Last Packager: muflone
Votes: 80
Popularity: 0.077469
First Submitted: 2013-04-25 19:13 (UTC)
Last Updated: 2022-08-18 01:35 (UTC)

Required by (213)

Sources (7)

Latest Comments

1 2 3 4 5 6 .. 17 Next › Last »

diliu commented on 2022-09-01 14:05 (UTC) (edited on 2022-09-01 14:16 (UTC) by diliu)

conflict with its dependency

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)

try drop-in replacement MariaDB instead. ref: https://wiki.archlinux.org/title/MySQL

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

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

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