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:
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
