[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