• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

mysql

  1. fullauto2012

    mysql56 and phpbb3/nextcloud

    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...
  2. Solved .mysql_secret not found for mysql56

    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?
  3. MySQL - login issue

    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...
  4. Unable to load modules gmysql for powerdns

    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...
  5. Solved MySQL 5.5 Upgrade Issue

    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...
  6. Itproman

    Solved Apache24 Mysql PHP install problem

    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...
  7. MMacD

    MariaDB still not reading my.cnf?

    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...
  8. formaltux

    Failed upgrade mysql 5.6.34 to 5.6.35 (portupgrade)

    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...
  9. IPTRACE

    10.3->11.0 (mysql does not start)

    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...
  10. Problem starting MySQL

    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...
  11. FKEinternet

    Data no longer accessible after upgrade from MySQL 5.6 to 5.7

    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...
  12. Neveroldmilk

    Have problems to start MySQL 5.7

    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...
  13. ZFS Benchmark for measuring storage performance

    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...
  14. ERROR 2002 (HY00): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

    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...
  15. cytopia

    Porting mysqldump-secure (port maintainer?)

    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...
  16. nonTechnical

    MySQL installed - but without config example files - why?

    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...
  17. FAMP Installation for Wordpress 4.4

    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...
  18. Itproman

    Solved FAMP -Info.php not decoding

    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...
  19. ZFS settings are inherited inside of Jail?

    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...