Package Details: mysql57 5.7.23-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.23, mysql=5.7.23
Submitter: Muflone
Maintainer: Muflone
Last Packager: Muflone
Votes: 6
Popularity: 0.422064
First Submitted: 2018-04-29 22:03
Last Updated: 2018-08-11 16:40

Required by (179)

Sources (6)

Latest Comments

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!