From owner-freebsd-questions@FreeBSD.ORG Fri Apr 11 17:01:02 2014 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 9D6B653C for ; Fri, 11 Apr 2014 17:01:02 +0000 (UTC) Received: from mail-oa0-x22e.google.com (mail-oa0-x22e.google.com [IPv6:2607:f8b0:4003:c02::22e]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 66EB31454 for ; Fri, 11 Apr 2014 17:01:02 +0000 (UTC) Received: by mail-oa0-f46.google.com with SMTP id i7so6479587oag.33 for ; Fri, 11 Apr 2014 10:01:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=subject:from:content-type:message-id:date:to :content-transfer-encoding:mime-version; bh=AVYpLHviXVWzveN6P48UxoZtfmsFadSB+EBWNeE3A2s=; b=kf16FwADnT9q9d7xnyUxrUe9G7NMKenwpi/8EZxizjxR2ecT4EV1OCId1S3XvAloCx qhyz6tMZRSfA1/vjxijAHJ3j7StKmDTCgZY7tpmvVGRsJChgcf0YiANRBNHIUkQN67f2 f0ffKyuvM8LfxA1x8Fg57HlgWIYU4wAXTYFjDzToJNADaRDoQJ1pOMXZ92tqYAj7k8jp MQ6wLgFngzax2PzZftDkSD9Jxt7reEdNxkxNu5oTEnGa+U23Facl0nwX3JjQtKmOLFoA Rp3Jus7QnRY4vtfw62sXP1NvbBjN/0lw9ABdQHIegFAn0S3HHrUDI0JaaDGZCI2rRMn5 PwSA== X-Received: by 10.60.93.168 with SMTP id cv8mr20447113oeb.21.1397235661767; Fri, 11 Apr 2014 10:01:01 -0700 (PDT) Received: from [192.168.1.64] (pool-71-170-112-253.dllstx.fios.verizon.net. [71.170.112.253]) by mx.google.com with ESMTPSA id c9sm13164249obq.20.2014.04.11.10.01.01 for (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128); Fri, 11 Apr 2014 10:01:01 -0700 (PDT) Subject: mariadb55-server: mysql_secure_installation script misconfigured From: Matthew Pherigo Content-Type: text/plain; charset=us-ascii X-Mailer: iPad Mail (11D167) Message-Id: <75D65393-DA01-48D2-9FA1-357CC0F768D6@gmail.com> Date: Fri, 11 Apr 2014 12:01:01 -0500 To: freebsd-questions@freebsd.org Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.17 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 11 Apr 2014 17:01:02 -0000 Hey all, Hi all, I must admit that I have very little experience in handling database= s, but the behavior of the program was weird enough that I figured the probl= em wasn't with me. When I run the mysql_secure_installation script, the default values it comes= with make the script nonfunctional. First, it attempts to create and chmod t= wo files: ".my.cfg.$$" (the config file) and ".mysql.$$" (something called "= command"). However, this fails with a "read-only filesystem" error. It seems= to not be specifying any path before the two files, as when I manually spec= ify a path (like /var/db/mysql/my.cfg and /usr/local/mysql). The script also= needs to be called with the option "--basedir=3D/usr/local", which seems un= necessary considering that setting ought to be the default in the first plac= e. Once I make these modifications, the script works just fine. Is it is this actually an issue? Or is this just a gap in my knowledge? Thanks, --Matt=