Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)

[boris dev]

I dont have root privledges.
I am succesful opening up mysql with following:

>mysql -h neve.sdsu.edu

But I ran into a frustrating snag with the data import command of mysql so as a long shot was hoping you might have experienced same once:

The problem might be, as you can see below, I wasnt sure exactly about syntax of typing in --user and --host options at same time?

I tried different combinations of :

neve:~ bdev$ mysqlimport -u bdev test statuslog.txt
mysqlimport: Error: Access denied for user 'bdev'@'localhost' (using password: NO)

neve:~ bdev$ mysqlimport -h neve.sdsu.edu --user=bdev test statuslog.txt
mysqlimport: Error: Access denied for user ''@'neve.sdsu.edu' (using password: NO), when using table: statuslog

neve:~ bdev$ mysqlimport -h neve.sdsu.edu --u bdev test statuslog.txt
mysqlimport: Error: Access denied for user ''@'neve.sdsu.edu' (using password: NO), when using table: statuslog

--------------------------------
I also tried from MYSQL> prompt:


mysql> LOAD DATA INFILE '~/statuslog.txt'
-> INTO TABLE statuslog;
ERROR 1045 (28000): Access denied for user ''@'neve.sdsu.edu' (using password: NO)