AUR (en) - mysql57

Git Clone URL:	https://aur.archlinux.org/mysql57.git (read-only, click to copy)
Package Base:	mysql57
Description:	Fast SQL database server, community edition, v5.7
Upstream URL:	https://www.mysql.com/products/community/
Licenses:	GPL
Conflicts:	mariadb-clients
Provides:	mariadb-clients, mysql-clients
Submitter:	Muflone
Maintainer:	Muflone
Last Packager:	Muflone
Votes:	12
Popularity:	0.114112
First Submitted:	2018-04-29 22:03 (UTC)
Last Updated:	2022-01-29 16:14 (UTC)

Latest Comments

Synthead commented on 2022-05-17 17:31 (UTC)

You know, after many years of using this package, it would be kinda nice if we stuffed everything in /opt. This is somewhat of a big change, cause people would need to add /opt/mysql/usr/include or something to build against it, but at least then it could live alongside mariadb without having package conflicts.

What do you think?

Muflone commented on 2021-05-30 15:23 (UTC)

@aix27249 I won't to do that. mysql doesn't provide anything related to mariadb. Even if they have something in common they are not the same software and there's no reason to fake mysql will provide mariadb libraries

aix27249 commented on 2021-05-13 10:26 (UTC)

Some packages now depends on mariadb-libs, which provides libmariadbclient, and conflicts with libmysqlclient57. To fix this, please add mariadb-libs to provides() section of libmysqlclient57:

diff --git a/PKGBUILD b/PKGBUILD
index 5781cb7..3da1629 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -81,7 +81,7 @@ package_libmysqlclient57(){
   pkgdesc="MySQL client libraries, v5.7"
   depends=('libsasl' 'zlib')
   conflicts=('libmariadbclient')
-  provides=("libmariadbclient=${pkgver}" "libmysqlclient=${pkgver}")
+  provides=("libmariadbclient=${pkgver}" "libmysqlclient=${pkgver}" "mariadb-libs=${pkgver}")

   cd build
   for dir in include libmysql libmysqld libservices

Torbistes commented on 2018-10-29 08:32 (UTC)

Problems with Wordpress 4.9.8 in a simply install in https://minitatuajes.com/ I try to install this package and get similar error by user @mrcl

internal compiler error: Segmentation fault (longlong)max_of_int_range(optp->var_type & GET_TYPE_MASK);

stri commented on 2018-09-28 22:58 (UTC)

@razvanz To be able to test build + installation on Arch, without having to deinstall mariadb. Let me know if there is a better way. Thanks, S

razvanz commented on 2018-09-26 14:53 (UTC) (edited on 2018-09-26 14:56 (UTC) by razvanz)

@stri Why not run it as an isolated container using the docker hub image?

docker run -d -p 0.0.0.0:3306:3306 --name mysql mysql

The benefit of running it in a container is being able to run multiple instances at the same time. Check the image documentation on how to configure other options (like persisting the storage): https://hub.docker.com/_/mysql/

stri commented on 2018-08-04 05:25 (UTC) (edited on 2018-08-05 21:29 (UTC) by stri)

@mrcl: I built it today and it seems to work.

I got it to work in a docker container. I suspect its insecure what I'm doing, but it's sufficient for local testing. The Dockerfile is

FROM archlinux/base

ADD . /

RUN pacman --noconfirm -Syu base-devel wget tar \
    && ./install_mysql57.sh \
    && rm -r /home/build/mysql57

VOLUME /var/lib/mysql
EXPOSE 3306

This is install_mysql57.sh:

#!/bin/bash -e

# http://allanmcrae.com/2015/01/replacing-makepkg-asroot/

mkdir /home/build ||:
chgrp nobody /home/build
chmod g+ws /home/build
setfacl -m u::rwx,g::rwx /home/build
setfacl -d --set u::rwx,g::rwx,o::- /home/build

echo "nobody ALL=(ALL) NOPASSWD: ALL" >> /etc/sudoers

cd /home/build
sudo -u nobody wget https://aur.archlinux.org/cgit/aur.git/snapshot/mysql57.tar.gz
sudo -u nobody tar -xzf mysql57.tar.gz
cd mysql57
sudo -u nobody makepkg --noconfirm -s
pacman --noconfirm -U libmysqlclient57-*.pkg.tar.xz
pacman --noconfirm -U mysql-clients57-*.pkg.tar.xz
pacman --noconfirm -U mysql57-*.pkg.tar.xz

Build it with "docker build -t IMAGE ." and run it:

docker run -p 3306:3306 -dt IMAGE

Configure Mysql if you don't care about security:

docker exec -d $CONTAINER_ID /bin/bash -c "echo log-bin=mysql-bin >> /etc/mysql/my.cnf; echo server-id=1  >> /etc/mysql/my.cnf; rm -r /var/lib/mysql/*; mysqld --initialize-insecure --console; /usr/bin/mysqld --user=root --secure-file-priv='' --pid-file=/run/mysqld/mysqld.pid"

I'm an eternal programming newbie, please let me know if there are issues with this.

Note the above is for connecting from within another container. If you want to connect from the host:

docker run -dt --network host IMAGE

To log in:

mysql -h 0.0.0.0 -P 3306 -u root

mrcl commented on 2018-07-31 05:08 (UTC) (edited on 2018-07-31 05:13 (UTC) by mrcl)

Trying to install this package and I am getting this error. Could anyone help me with this problem?

Scanning dependencies of target mysys_ssl

[  9%] Building CXX object mysys_ssl/CMakeFiles/mysys_ssl.dir/crypt_genhash_impl.cc.o
[  9%] Building CXX object mysys_ssl/CMakeFiles/mysys_ssl.dir/mf_tempdir.cc.o
[  9%] Building CXX object mysys_ssl/CMakeFiles/mysys_ssl.dir/my_default.cc.o
[  9%] Building CXX object mysys_ssl/CMakeFiles/mysys_ssl.dir/my_getopt.cc.o
/home/user/.local/src/aur/mysql57/src/mysql-5.7.22/mysys_ssl/my_getopt.cc: In function ‘longlong getopt_ll_limit_value(longlong, const my_option*, my_bool*)’:
/home/user/.local/src/aur/mysql57/src/mysql-5.7.22/mysys_ssl/my_getopt.cc:1084:62: internal compiler error: Segmentation fault
     (longlong)max_of_int_range(optp->var_type & GET_TYPE_MASK);
                                                              ^
Please submit a full bug report,
with preprocessed source if appropriate.
See <<https://bugs.archlinux.org/>> for instructions.
make[2]: *** [mysys_ssl/CMakeFiles/mysys_ssl.dir/build.make:102: mysys_ssl/CMakeFiles/mysys_ssl.dir/my_getopt.cc.o] Error 1
make[1]: *** [CMakeFiles/Makefile2:1036: mysys_ssl/CMakeFiles/mysys_ssl.dir/all] Error 2
make: *** [Makefile:163: all] Error 2
==> ERROR: A failure occurred in build().
Aborting...

Muflone commented on 2018-06-02 19:26 (UTC)

@stri it's not possible to install this package along with mariadb as they both use common commands and files, and therefore are conflicting packages

stri commented on 2018-05-22 03:27 (UTC)

Thanks for this package! Is it possible to install it alongside mariadb? I'm running KDE on my desktop which depends on mariadb. If not, is the best option to run it from a docker container? Thanks for your help!

Arch Linux User Repository

Search Criteria

Package Details: mysql-clients57 5.7.37-1

Package Actions

Dependencies (13)

Required by (61)

Sources (7)