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

/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

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

Connection id:          8
Current database:
Current user:           [EMAIL PROTECTED]
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
Started with adding mysqld: 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

Thanks in advance for any advice !


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 :)

[EMAIL PROTECTED] mailing list
To unsubscribe, send any mail to "[EMAIL PROTECTED]"

Reply via email to