From owner-freebsd-questions@FreeBSD.ORG Sun Jun 20 18:48:57 2004 Return-Path: Delivered-To: freebsd-questions@freebsd.org Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125]) by hub.freebsd.org (Postfix) with ESMTP id A5D4216A4CE for ; Sun, 20 Jun 2004 18:48:57 +0000 (GMT) Received: from ptb-relay01.plus.net (ptb-relay01.plus.net [212.159.14.212]) by mx1.FreeBSD.org (Postfix) with ESMTP id 4E13443D31 for ; Sun, 20 Jun 2004 18:48:57 +0000 (GMT) (envelope-from gbentley@uk2.net) Received: from [81.174.174.115] (helo=plus) by ptb-relay01.plus.net with smtp (Exim) id 1Bc7N3-0000BP-Q9 for freebsd-questions@freebsd.org; Sun, 20 Jun 2004 18:48:49 +0000 Message-Id: <3.0.6.32.20040620194842.007b72a0@mail.uk2.net> X-Preferences: Plain Text/No HTML X-Mailer: Interstat v2.0.9 Date: Sun, 20 Jun 2004 19:48:42 +0100 To: freebsd-questions@freebsd.org From: Graham Bentley Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Subject: MySQL Advice X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.1 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 20 Jun 2004 18:48:57 -0000 Hi All Can any MySQL gurus out there point me in the direction of enlightenment. Just installed MySQL for a Wiki DB and get the following when trying to add the root password as instructed by the installer. freebsd# /usr/local/bin/mysqld_safe & [1] 684 freebsd# Starting mysqld daemon with databases from /var/db/mysql freebsd# /usr/local/bin/mysqladmin -u root password mypassword freebsd# /usr/local/bin/mysqladmin -u root -h freebsd.mydomain.com password mypassword /usr/local/bin/mysqladmin: connect to server at 'freebsd.mydomain.com' failed error: 'Host 'freebsd.mydomain.com' is not allowed to connect to this MySQL server' freebsd# /usr/local/bin/mysql --password Enter password: ******* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 to server version: 4.1.0-alpha Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> status -------------- /usr/local/bin/mysql Ver 13.5 Distrib 4.1.0-alpha, for portbld-freebsd5.2 (i386) Connection id: 8 Current database: Current user: root@localhos SSL: Not in use Current pager: more Using outfile: '' Server version: 4.1.0-alpha Protocol version: 10 Connection: Localhost via UNIX socket Client characterset: latin1_swedish_ci Server characterset: latin1_swedish_ci UNIX socket: /tmp/mysql.sock Uptime: 13 min 35 sec Threads: 1 Questions: 5 Slow queries: 0 Opens: 7 Flush tables: 1 Open tables: 1 Queries per second avg: 0.006 -------------- I am wondering if this is anything to do with my network setup as I had exactly the same thing on a Linux box a few weeks ago and drove myself mad trying to resolve it. Now its cropped upa gain under 5.2.1 - it cant be a coincidence . . . can it ? I have googled about and tried out most of the recommended solutions to no avail Started with adding mysqld:127.0.0.1 to hosts which didnt work (I couldnt tell you why I should do this being a noob - just following advice to get me up and running:) Thanks in advance for any advice ! Graham ps I installed this with pkg_add -r mysql-server which seemed to go to the 'latest' directory on the end of a long FreeBSD ftp server dir structure. I just know I am going to get flamed for this :)