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]