mysql

  1. S

    Solved Can't connect to mysql database after upgrading to mariadb 10.4.13_3

    After upgrading to mariadb 10.4.13_3 I'm unable to connect to mysql server via the normal port method. I can connect from the command line and via socket though. Anyone have any idea why that might be? I've read UPDATING and all the stuff about the new config file locations, etc. and everything...
  2. F

    Update mysql/eject mysql from kde plasma

    Once I install kde plasma on my desktop, it uses mysql57. However I want to upgrade it to mysql 80 and "eject" the dependency it from kde plasma. IF I do pkg remove -f mysql57 the system works fine as it is not used much, however when I try to install mysql80 it tries to "update" my packages and...
  3. tony33

    mysql broken after upgrading freebsd

    So, I upgraded freebsd from 11.1 to 12.1 after this I updated ports and upgraded softwares like mysql, php etc. So, most software work even though there's warnings because configs are using outdated stuff. However, most software still runs and works. Mysql is the only thing that's broken. It...
  4. TW1920

    MariaDB won't start automatically

    Hello, I have problems with MariaDB. Installation works well, MariaDB is running fine, too. But it won't start after boot automatically and service command do not work. root@thesaurus:/home/XXX # /usr/local/etc/rc.d/mysql-server status mysql is running as pid 1417. root@thesaurus:/home/XXX #...
  5. W

    Solved Dovecot password missmatch after lastest update 01/2020

    After enable all log and debug, have found where the problem occour on auth-worker which is getting plain password and not hashing it: ... SHA512-CRYPT(plainpasswordhere) != 'HASH value from mysql' Then occours password missmatch error. Someone have same issue? PS.: Happen on last update of...
  6. D

    FreeBSD doesn't starting after restart

    I have Hyper-V with Freebsd 12 on vitrual machine. I intalled web server (apache, php, mysql) on freebsd. After hard restarting my hyper-v server (press power button on server) FreeBSD doesn't work, mysql doesn't mount database. I have more troubles with database files. But, if i stoping all...
  7. ykla

    failed on start mysql80-server on FreeBSD12.0

    Hi! I installed mysql80-server today, but I cant not start it. root@VM_0_11_freebsd:/usr/ports/database s/mysql80-server # p root@VM_0_11_freebsd:/usr/ports/databases/mysql80-server # pwd_mkdb -p /e tc/master.passwd root@VM_0_11_freebsd:/usr/ports/databases/mysql80-server # sysrc mysql_en...
  8. goshanecr

    database/mysql57-client Linking fails on 11.2 i386

    Good day! I have a server uname -a FreeBSD db_mysql 11.2-STABLE FreeBSD 11.2-STABLE #0 r338358: Thu Aug 30 01:29:38 +05 2018 user@BSD-TENNIS:/usr/obj/usr/src/sys/BSDSERV i386 And on that server works several jails. One named db_mysql has mysql57-{server,client}. pkg info | grep mysql...
  9. T

    Cannot login to Maia mailguard

    Hi, I'm running maia mailguard 1.0.3 (A Virus and Spam Management Solution for Email ) and have set 2 primary account as administrator, and I’ve tried switch account as primary from account1 to account2. After that I cannot login with new primary account with error : Login for user...
  10. Maelstorm

    PHP can't connect to MySQL

    I am running FreeBSD 11.1, PHP 7.2, Apache 2.4, and some version of MySQL. The problem is that when I try to access the test page from the web, I get an error that says "Failed to connect to database: could not find driver." I made sure that pdo_mysql was installed, and it shows up on the list...
  11. vince66

    Solved Set/Reset MySQL Password after the installation.

    How to set MySQL Password after MySQL server after the installation ? I've just read the threads in forums ... but typing: mysql -u root -p I receive the message of Access denied. Wait for kindly tips. Thanks in advance
  12. L

    MariaDB socket in jail not created at host boot

    There's a jail for MariaDB mysql Ver 15.1 Distrib 10.2.15-MariaDB, for FreeBSD11.1 (amd64) using readline 5.1. A socket should be created in /var/run/mysql [client] port = 3306 socket = /var/run/mysql/mysql.sock [mysqld] port = 3306 socket =...
  13. 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...
  14. G

    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?
  15. M

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

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

    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...
  18. 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...
  19. 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...
  20. 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...
Top