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. Commands end with ; or \g. Your MySQL connection id is 6 to server version: 4.1.14-standard Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> select user(); +--------------------+ | user() | +--------------------+ | scri...@localhost | +--------------------+ 1 row in set (0.00 sec) mysql> select current_user(); +----------------+ | current_user() | +----------------+ | @localhost | +----------------+ 1 row in set (0.01 sec) ... ok - there's the output - and it's like you said; does this pinpoint the issue? I'm not sure what to do with the info. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
