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: [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
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 :)
___
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to [EMAIL PROTECTED]