Date: Sun, 20 Jun 2004 19:48:42 +0100 From: Graham Bentley <gbentley@uk2.net> To: freebsd-questions@freebsd.org Subject: MySQL Advice Message-ID: <3.0.6.32.20040620194842.007b72a0@mail.uk2.net>
next in thread | raw e-mail | index | archive | help
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 :)
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?3.0.6.32.20040620194842.007b72a0>