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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.