Re: strange authentication issue

2010-08-01 Thread Claudio Nanni
sorry I went to sleep CEST here, its created by default by MySQL Cheers! Claudio On 8/1/2010 2:15 AM, Corey wrote: On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote: login as root and remove 'empty' user ,issue: delete from mysql.user where user=''; flush privileges; mysql authenti

Re: strange authentication issue

2010-08-01 Thread Claudio Nanni
sorry I went to sleep CEST here, its created by default by MySQL Cheers! Claudio On 8/1/2010 2:15 AM, Corey wrote: On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote: login as root and remove 'empty' user ,issue: delete from mysql.user where user=''; flush privileges; mysql authenti

Re: strange authentication issue

2010-07-31 Thread Corey
On Saturday 31 July 2010 5:11:33 Claudio Nanni wrote: > login as root and remove 'empty' user ,issue: > > delete from mysql.user where user=''; > flush privileges; > > mysql authentication system is logging you on as 'empty' user. > > you will be ok after that ;) > Man, thanks a ton! That wa

Re: strange authentication issue

2010-07-31 Thread Claudio Nanni
login as root and remove 'empty' user ,issue: delete from mysql.user where user=''; flush privileges; mysql authentication system is logging you on as 'empty' user. you will be ok after that ;) Claudio On 8/1/2010 2:02 AM, Corey wrote: On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote:

Re: strange authentication issue

2010-07-31 Thread Corey
On Saturday 31 July 2010 4:58:36 Claudio Nanni wrote: > after login to mysql issue: > > select user(); > and > select current_user(); > and post output > you will see they dont match. > /usr/local/mysql/bin/mysql -h localhost -u scripts -p Enter password: Welcome to the MySQL monitor. Command

Re: strange authentication issue

2010-07-31 Thread Claudio Nanni
after login to mysql issue: select user(); and select current_user(); and post output you will see they dont match. Claudio On 8/1/2010 1:47 AM, Corey wrote: On Saturday 31 July 2010 4:40:14 chaim rieger wrote: Another thing I just noticed In your first example you are using localhost, w

Re: strange authentication issue

2010-07-31 Thread Corey
On Saturday 31 July 2010 4:40:14 chaim rieger wrote: > Another thing I just noticed > > In your first example you are using localhost, which probably means you are > connecting via network > > The second option you don't define a host, which means you're prolly using > socket connection Oh, whoo

Re: strange authentication issue

2010-07-31 Thread chaim rieger
Another thing I just noticed In your first example you are using localhost, which probably means you are connecting via network The second option you don't define a host, which means you're prolly using socket connection -- MySQL General Mailing List For list archives: http://lists.mysql.co

Re: strange authentication issue

2010-07-31 Thread Corey
On Saturday 31 July 2010 4:30:00 chaim rieger wrote: > Just a stab but what's the max connect set to ? > Thanks a ton for the quick response - I'm at wits end, been working on this for hours! max_connections is set to 0. (but it is also set to 0 on another server, which largely follows the same

Re: strange authentication issue

2010-07-31 Thread chaim rieger
Just a stab but what's the max connect set to ? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

strange authentication issue

2010-07-31 Thread Corey
Hello - I'm only moderately familiar with mysql; the following issue has me stumped. I just noticed that some scripts on one of my client's servers suddenly started failing due to being no longer able to log into the mysql db. I have not touched the mysql config on that machine in months. The

Authentication issue

2010-06-09 Thread Johan De Meersman
Hi list, I'm migrating a Java application from it's local MySQL server (5.0) to a remote 5.1 server. I've transferred the data and slaved the new server to keep it in sync, but when I try to switch out the datasource (that is, just change from localhost to the remote server), the application refus