set name=pkg.fmri value=pkg://localhosts11/sfe/database/mysql-common@8.0.28.0.1,5.11-0.0.175.3.33.0.2.0:20220220T175248Z set name=pkg.description value="MySQL 8.0 community edition *read* https://sfe.opencsw.org/SFEmysql80 for detailed tipps and tricks. . . . . This package is currently in develompent, please expect some edges. . . If you have troubles or want a feature added, get in contact: sfepackages@gmail.com . . or got to IRC libera.chat channel #pkgbuild . . . Note: if mysql-57 is installed before, then you may need to set mediator, to get mysql-sfe version 8.0.28 be the default database. . . . . For /usr/bin/mysql client symlinked to the right version, you set mediator. . . See for available mediators: pkg mediator -a . . . . See the currently active MySQL symlink-target: . . pkg mediator mysql . . . . To set mysql symlinks to this version, run this command . . pfexec pkg set-mediator -I mysql-sfe mysql . . . . To enable the database enable SMF service mysql-80 . . . . svcadm enable -s mysql:version_80 . . This will initialize an *empty* database with a mysql root password (change this!) you can find in the Server logfile here: . . grep password /var/mysql/8.0/data/${HOSTNAME}.err . . . . You *may* add more instances in SMF with separate my.cnf and data . . . . If you *upgrade* your database, beware, pkg uninstall deletes your old Database Directory and moves files to /var/pkg/lost+found/ . . . . To Upgrade from mysql 5.7 to mysql 8.0 you move or copy all raw files from /var/mysql/5.0/data/ over to /var/mysql/8.0/data/ . . Alternatively you start with an empty database and you dump all data from 5.7 and import it into new 8.0 server. . . . . Compile-Options: ... -DBUILD_TYPE=Release" group gid=70 groupname=mysql dir group=sys mode=0755 owner=root path=etc/security/auth_attr.d dir group=sys mode=0755 owner=root path=etc/security/prof_attr.d user ftpuser=false gcos-field="MySQL Reserved UID" group=mysql password=NP uid=70 username=mysql file c677c2214b23dd10e33ac183c87fa0cac7dee743 chash=ee3e1a8c6b15b3fba1e8603bf1bb2e2c0a53f462 group=sys mode=0755 owner=root path=etc/security/prof_attr.d/mysql pkg.csize=86 pkg.size=81 set name=net.sourceforge.pkgbuild,version value=1.3.104 license bc8701644e63e4f14c2104aa27dec2b887e178bf chash=e4d30e7b8ed41d0c640072900090406433e5aa26 license=unknown pkg.csize=116 pkg.size=135 set name=variant.arch value=i386 set name=build.tool value=pkgbuild file 42eb95e3735822ed5fdd928ebc5af98884f963d4 chash=9057b3678c372a420082d951fc3d745252ea8205 group=sys mode=0755 owner=root path=etc/security/auth_attr.d/mysql pkg.csize=104 pkg.size=119 dir group=sys mode=0755 owner=root path=etc/security dir group=sys mode=0755 owner=root path=etc set name=info.source-url value=http://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-boost-8.0.28.tar.gz legacy arch=i386 category=SFE,application desc="MySQL Server Community Edition 8.0 - common files, user, group and roles" hotline="Please contact your local service provider" name="MySQL Server Community Edition 8.0 - common files, user, group and roles" pkg=SFEmysql-common vendor=http://pkgbuild.sf.net/spec-files-extra version=8.0.28,REV=110.0.4.2022.02.20.18.40 set name=pkg.summary value="MySQL Server Community Edition 8.0 - common files, user, group and roles"