Hello.
Misterious 'unauthenticated user' problems appears very seldom in
lists and bugs database with different versions. My opinion, that
it is somehow related to the networking. Do you use --skip-name-resolve option?
Have you compiled the MySQL server manually? Send us your config file
and starting command line options. Can you find any clues in the error log?
You may switch to debug version of the server and try to find out something
in a trace file.
Keith Thompson [EMAIL PROTECTED] wrote:
Since upgrading my Solaris9 server to MySQL 4.1.9 (previously 4.1.3),
remote connections to it from my WinXP laptop have become very slow.
Remote connections using the mysql command-line tool (4.1.7 client),
MySQL Query Browser (1.1.5) or JDBC connections with Connector/J
(3.0.16) used to all connect immediately. Now they take anywhere from
10-30 seconds. The Query Browser has also become very frustrating
because every time I execute a query it freezes for 10-30 seconds before
finally executing each query.
I have noticed that on the server during this long wait time, my new
connection appears immediately, but mysqladmin processlist shows the
user to be unauthenticated user until it finally completes the
connection (and updates the user to the correct username). So, I'm not
having network problems getting to the server or anything like that.
Also, the server is not low on memory, low on connections, is not
producing any errors, etc. Via Google I found a few occurrences of
others with unauthenticated user issues, but they all seem to involve
lots of connections in this state. In my case it's only one--the user
very slowly connecting.
This has been happening since a recent server update to 4.1.9 and never
happened previously with 4.1.3. Also, it does not occur when making
remote connections from the same PC to a 4.1.7 server.
Any suggestions?
-keith
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]