Package Details: mysql 9.0.1-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-2.0-only
Conflicts: mariadb
Provides: mariadb, mysql
Submitter: Barthalion
Maintainer: Muflone
Last Packager: Muflone
Votes: 82
Popularity: 0.031334
First Submitted: 2013-04-25 19:13 (UTC)
Last Updated: 2024-08-11 14:51 (UTC)

Required by (207)

Sources (8)

Pinned Comments

Muflone commented on 2023-08-16 17:21 (UTC) (edited on 2023-08-16 20:41 (UTC) by Muflone)

Warning

https://dev.mysql.com/doc/refman/8.1/en/downgrading.html

Downgrade from MySQL 8.1 to MySQL 8.0 or earlier is not supported. The only supported alternative is to restore a backup taken before upgrading. It is therefore imperative that you back up your data before starting the upgrade process.

MySQL 8.0 is available in https://aur.archlinux.org/packages/mysql80

Latest Comments

« First ‹ Previous 1 2 3 4 5 6 7 8 .. 19 Next › Last »

richard-muvirimi commented on 2023-03-16 19:04 (UTC)

The patch package is required as a build dependency, this is the last step and after a lengthy build process, will simply fail with the error Unknown command: patch

D3vil0p3r commented on 2023-01-22 18:18 (UTC)

Hello, dumb question: what is the detailed difference between mysql and mariadb packages?

Muflone commented on 2022-11-06 17:49 (UTC)

both mariadb and percona-server already have a conflict with mysql

stop using AUR helpers until you learn how to use AUR, those conflicts are due to the fact you're installing mysql and mariadb-clients instead of mysql-clients which is provided by this package

fnix commented on 2022-11-05 21:01 (UTC)

Getting the conflict with percona-server as well.

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