I installed xampp mysql with username as root and no password. I checked the phpMyAdmin and root user has all privildges. When I try to insert into a table I get the following error message:
Access denied for user 'ODBC'@'localhost' (using password: NO)
The problem is not with my connection because my php pages will display records that are already in the table, I just can't add new ones. The existing ones were inserted using a backup file.
Can someone tell me what is wrong and how to fix it?
Thanks
Dan