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

Bill Moran wmoran at potentialtech.com
Tue May 18 10:22:01 EDT 2004


Robert L. Jeffries wrote:
> 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.

I've not experienced the problems you describe, but the last time I checked,
WITH_LINUXTHREADS was considered experimental and not recommended for
production use.

I don't want to lead you on a wild goose chase, but 5.2 RC1 is about the
most unreliable thing you could try a threaded app on.  Unless you're
specifically testing the new threading capabilities of FreeBSD 5, you
might be better off using 4.9.  If you _are_ testing out the new thread
capabilities of FreeBSD 5, you should probably update to 5.2.1, or even
-CURRENT before trying any other fixes.

> -----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.


-- 
Bill Moran
Potential Technologies
http://www.potentialtech.com



More information about the wplug-bsd mailing list