Re: ERROR 1045: Access denied for user: 'root@localhost' (Using password: yes)

[Mohsin Jessa]

I'm back...with the same issue again....
This time I have tried everything from the Administrator, shutting the server service and various combination of connect/use with hostname, localhost, ip addressess you name it.

mysql> LOAD DATA INFILE 'c:\\from_excel.csv' INTO TABLE from_excel FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 LINES
-> (name, @var2, gender, donation, member) set dob=str_to_date(@var2,'%d-%b-%y');
ERROR 1045 (28000): Access denied for user 'mojeeza'@'%' (using password: YES)
mysql>

Even though I am told I don't have access, I can issue a select against the same table and my session does show as being connected to the database from the MySQL Administrator:

mysql> select * from From_Excel;
+-------+------------+--------+----------+--------+
| name | dob | gender | donation | member |
+-------+------------+--------+----------+--------+
| Abbas | 1982-12-10 | M | 300 | Y |
| Name1 | 2000-01-19 | F | 500 | N |
+-------+------------+--------+----------+--------+
2 rows in set (0.00 sec)

mysql>



What is the correct setting on a single machine running XP to avoid this issue...