Package Details: mysql57 5.7.24-1

Git Clone URL: https://aur.archlinux.org/mysql57.git (read-only)
Package Base: mysql57
Description: Fast SQL database server, community edition, v5.7
Upstream URL: https://www.mysql.com/products/community/
Licenses: GPL
Conflicts: mariadb
Provides: mariadb=5.7.24, mysql=5.7.24
Submitter: Muflone
Maintainer: Muflone
Last Packager: Muflone
Votes: 6
Popularity: 0.140110
First Submitted: 2018-04-29 22:03
Last Updated: 2018-10-28 01:28

Required by (169)

Sources (6)

Latest Comments

Torbistes commented on 2018-10-29 08:32

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

@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

@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

@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

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

@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

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!