[wplug-bsd] Follow-Up: MySQL Command Center on Windows can't connect to MySQL 4.1 on FreeBSD 5.2-RC1

[Robert L. Jeffries]

Since my original post, I've relearned the valuable lesson of keeping
notes on my procedures and progresses. I thought I forgot to make the
"/etc/my.cnf" executable, but if I did, then that wasn't all I've
missed.
 
Or, did I build it incorrectly? Found a suggestion to specify
"WITH_LINUXTHREADS=TRUE" when doing the build from ports, after I
googled (http://www.google.com <http://www.google.com/> ) "FreeBSD MySQL
problems". (the suggestion was found at
http://forums.devshed.com/archive/t-46716 . Ok, so if that's it then I'd
probably have to "uninstall" MySQL and start over. And of course just
deleting all the files and scripts concerned creates problems. So, it's
off to the drawing board I go, to figure out how to dismantle the
installation, to start over from scratch (which I need to figure out how
to do properly for the future, anyway). This time I'll aim for not
having a lack of notes.
 
-----Original Message-----
From: Robert L. Jeffries [mailto:rl_jeffries at comcast.net] 
Sent: Saturday, May 15, 2004 4:26 PM
To: 'wplug-bsd at wplug.org'
Subject: MySQL Command Center on Windows can't connect to MySQL 4.1 on
FreeBSD 5.2-RC1
 
Hello all,
I'm running FreeBSD 5.2 RC-1. I've installed MySQL 4.1 server and client
via /usr/ports/databases/mysql.../make, and it installed without a
hitch.
The MySQL service is running, and I can connect using the local client,
and I've been doing most of the work of the network via SSH.
I can't connect to the service using mysqlcc. After trying many things,
I've been getting the same to errors separately, from mysqlcc.
ERROR 2005: Unknown MySQL Server Host (11001), and,
ERROR 2013: Lost connection to MySQL server during query.
The latter of these two being more prevalent.
 
I've been doing my configuration/setup using the usual files ( my.cnf,
hosts, hosts.allow, )
Some settings in particular:
In /etc/my.cnf (which is a renamed my-medium.cnf), as per suggestion
that I've found via google, I've set the max_allowed_packet=16M instead
of 1M
I have all the hosts concerned hosts on my LAN listed in hosts, and
hosts.allow.
I've granted myself sufficient privileges in via the mysql-client/SSH
with:
GRANT ALL ON *.* TO 'me'@'localhost' WITH GRANT OPTION;
GRANT ALL ON *.* TO 'me'@'xxx.xxx.xxx' WITH GRANT OPTION;
GRANT ALL ON *.* TO 'me'@'%' WITH GRANT OPTION;
(me=username AND/OR root).
 
I've nmap'd the server IP address and see that the default port of 3306
is there to accept my connection.
 
I've gone through a couple books that I have on MySQL, I've read the
docs - online and local --, I've searched the web and the groups, and
I've come up with more bug declarations then anything else.
 
Any ideas?
 
Thank you, in advance,
Rob Jeffries
 
 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.wplug.org/pipermail/wplug-bsd/attachments/20040517/59d3c0f5/attachment.htm