MySQL database - Error: 1045 (28000): Access denied for user 'barginadmin'@'%' (using password: YES)

Question

Note: i tried every single stackoverflow suggestion at the bottom before I posted.. I also tried creating the user in the database on the mySQL command line then granting all permissions, still no luck.

I have a MySQL database through Azure. I have everything set up with SQL WorkBench and Azure Data Studio. I can do basic commands on the server like SHOW, SELECT, USE, CREATE. However, I do not have access to LOAD DATA INFILE. The error I receive is the following: Error: 1045 (28000): Access denied for user 'barginadmin'@'%' (using password: YES).

I need the LOAD DATA INFILE command so I can load large csv files into the database.

I am the only user on this database as I created it on Azure Portal this morning. I would ASSUME I would have admin rights. I have already tried a heap of things such us granting all the permissions to admin on the server, I have tried flushing the permissions.

Please, knowledgeable people of stackoverflow - help!

Tried to use LOAD DATA INFILE, as well as LOAD DATA LOCAL INFILE, neither I have permission for despite being logged into the server and the only user..