From owner-freebsd-ports Thu Apr 20 2:25:42 2000 Delivered-To: freebsd-ports@freebsd.org Received: from ipt2.iptelecom.net.ua (ipt2.iptelecom.net.ua [212.9.224.2]) by hub.freebsd.org (Postfix) with ESMTP id ADABB37BD6E for ; Thu, 20 Apr 2000 02:25:37 -0700 (PDT) (envelope-from sobomax@altavista.net) Received: from vega.vega.com (dialup6-40.iptelecom.net.ua [212.9.227.104]) by ipt2.iptelecom.net.ua (8.9.3/8.9.3) with ESMTP id MAA27459; Thu, 20 Apr 2000 12:32:22 +0300 (EEST) Received: from altavista.net (big_brother.vega.com [192.168.1.1]) by vega.vega.com (8.9.3/8.9.3) with ESMTP id MAA13911; Thu, 20 Apr 2000 12:24:30 +0300 (EEST) (envelope-from sobomax@altavista.net) Message-ID: <38FECCCD.7D77B827@altavista.net> Date: Thu, 20 Apr 2000 12:24:30 +0300 From: Maxim Sobolev Organization: Vega International Capital X-Mailer: Mozilla 4.72 [en] (WinNT; U) X-Accept-Language: uk,ru,en MIME-Version: 1.0 To: "Matt M." , ports@freebsd.org Subject: Re: mysql3.22.32 port References: <00041918264500.00273@boda.mine.nu> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit Sender: owner-freebsd-ports@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.org "Matt M." wrote: > I installed the port, and it added the user mysql. The shell it configured was > /usr/local/sbin/nologin. I changed this to /usr/local/bin/bash, and changed the > mysql password. When I try to login, it tells me the account is not available. > If I try to connect to mysql as any other user, I get a message stating it > can't connect to mysql on port (whatever it was) /tmp/mysql.id (or something > similar - mysql is now uninstalled because I thought I would try installing it > directly from source). Where is the documentation for this, or what can you > tell me? Try to read mysql info ($ info mysql) carefully, it may help. Especially sections describing security model and how to setup privileges for mysql users' accounts. Following is short list of what you got wrong (guessed from your message): 1. You do not need to change mysql's /etc/passwd account in any way, since it is provided solely for security purposes to avoid running mysql as root. You never will have to login into this account. 2. Real users listed in /etc/passwd have nothing to do with mysql accounts. 3. After installing you should be root to connect to the mysql and connection could be established only from the local machine via domain socket. Therefore preferred way to install/configure mysql should be as follows: 1. Compile and install it; 2. Start mysql daemon (#/usr/local/etc/rc.d/mysql-server.sh start); 3. Read following documentation: mysql security model; how to create mysql users; how to grant privileges to users; 4. Create mysql users and grant required rights to them; 5. Have fun. -Maxim To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-ports" in the body of the message