mysql

root@kif:/var/db/mysql # uname -a FreeBSD kif 10.3-RELEASE FreeBSD 10.3-RELEASE #0 r297264: Fri Mar 25 02:10:02 UTC 2016 root@releng1.nyi.freebsd.org:/usr/obj/usr/src/sys/GENERIC amd64 Had databases/mysql80-server installed with www/nextcloud running. Wanted to add a www/phpbb3 instance...

FreeBSD 10.3. Installing mysql56, but cannot find .mysql_secret in either /root or /home/USERNAME. Have reinstalled without success. Have searched for file using FIND command. Where is this file?

freebsd-version: 11.1-RELEASE mysql version: 5.6.38 I have a script the requires mysql, cron_create_tables.pl: #!/usr/local/bin/perl -w -- use DBI; use strict; my $dbh = DBI->connect('DBI:mysql:mymud', 'mymud', '') or die "unable to connect to MyMUD database"; ... $ perl...

Installed Powerdns and mysql57-server and client still I am facing this problem #pdns_server --daemon=no --guardian=no --loglevel=9 Aug 19 09:26:46 Reading random entropy from '/dev/urandom' Aug 19 09:26:46 Loading '/usr/local/lib/pdns/libgmysqlbackend.so' Aug 19 09:26:46 Unable to load module...

I'm trying to upgrade databases/mysql55-server from 5.5.55 to 5.5.55_1. This is the errors I am receiving. Is it safe to continue with the upgrade? $ sudo portmaster mysql55-server-5.5.55 ===>>> Currently installed version: mysql55-server-5.5.55 ===>>> Port directory...

Apache 24 install,configuration and start successful. Mysql install is the problem: pkg install mysql57-server mysql57-client Error message: http://http://pkg.freebsd.org/FreeBSD:11:amd64/latest/All/pkg.FreeBSD.org/FreeBSD:11:amd64/quarterly/All/mysql57-server-5.7.17_3.txz: Not Found I...

Apologies if this isn't the right place for this. Am I doing something stupid, or not doing something I should be doing? Because if not, MariaDB still isn't interpreting my.cnf, although it complains if it's not in /usr/local/etc/mysql. The command: 13:59:57 Thu, 16 Feb...

Hi, Yesterday morning around 8 am (GMT+1), I performed what should of been standard MySQL upgrade from MySQL 5.6.34 to MySQL 5.6.35 using portupgrade, but ended up losing InnoDB tables completely and spending whole day getting them restored. I ran mysql_upgrade after database restart and...

Hello! Next problem after upgrade to 11.0-RELEASE. MySQL does not start. No data in logs. Reinstallation didn't help. @db1:~ % sudo service mysql-server status mysql is not running. @db1:~ % sudo service mysql-server start Starting mysql. @db1:~ % sudo service mysql-server status mysql is not...

Hi All, I have a problem starting MySQL, (5.7.13_1). From my err.log Shared object "liblz4.so.1" not found, required by "mysqld" Bit of background, this was an old FreeBSD 9.x server that I updated to 10.2 some time ago. I recently upgraded MySQL, all went fine at the time. Was forced to...

I upgraded my server from MySQL 5.6 to 5.7 via pkg install mysql57-server. After getting the changed configuration issues sorted out so I could run mysql_upgrade -u root -p successfully, it reported that practically all of my existing tables don't exist - because they are stored on disk with...

I used pkg to install MySQL 5.7 by this command: $ sudo pkg install mysql57-server Then I have problems to start MySQL, and the command and output is listed below: $ sudo sysrc mysql_enable=yes mysql_enable: -> yes $ sudo service mysql-server start /usr/local/etc/rc.d/mysql-server: WARNING...

Benchmark to measure the storage performance when I send database query. I install Mysql because it has its own benchmark mysqlslp. I use also sysbench. The problem is how to measuring storage performance when the query is sent, and what is the most important parameters to be put under stress...

How can I backup the databases in MySQL 5.6 if it will not run? It will not create an mysql.sock so I can't do a dump. I have also reinstalled MySQL 5.6 two times without errors and will not create mysql.sock to get the MySQL running to perform the dump / backup. I have the mysql directory...

Hi guys, I am trying to fully port mysqldump-secure over to FreeBSD. It is already at the state that the script itself is 100% fully working (POSIX shell without any bashism: #!/bin/sh). I have one request as well as one error and one problem. 1. The request I would like to get this as a...

I've just installed databases/mysql57-server on a new server, but can't see the example config files in /usr/local/share/mysql or anywhere to copy to run the server. I've used: $ sudo find / -name "mysql*" 2>/dev/null and /usr/local/share/mysql/ has: my-default.cnf mysql-log-rotate...

FreeBSD 10.2-RELEASE Apache24 MySQL 5.5 PHP-5.6 Installed Wordpress 4.3.1_1 from pkg repository, no issues in getting it set up and running. WordPress 4.4 gets released and I upgraded, then my installation couldn't create or write files (via WordPress FTP implementation; couldn't...

I followed this tutorial I found doing a search for FAMP and all is well, except for info.php. https://www.digitalocean.com/community/tutorials/how-to-install-an-apache-mysql-and-php-famp-stack-on-freebsd-10-1 1) www/apache24: "It works!" (sysutils/webmin sees it (after directory path...

Guys, Someone know if the settings from Host are inherited inside of Jail? For example, in the Host I have make an dataset like: zfs create -o compression=off -o exec=off -o recordsize=16k -o setuid=off zroot/var/db/mysql My concern is about the recordsize, since I dont know how to check it...