Package Details: mysql 9.2.0-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.004350
First Submitted: 2013-04-25 19:13 (UTC)
Last Updated: 2025-03-10 23:26 (UTC)

Required by (212)

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 9 .. 20 Next › Last »

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.

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

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