Can't log in to MySQL - Access denied for user 'foobar'@'localhost' (using password: NO)

Hello,

From shell, I am able to log in to mysql using both root and my custom mysql user (let’s call it ‘foobar’). However, I can’t log in via any external or local-based method such as phpMyAdmin, adminer, HeidiSQL, etc.

I see no errors in access.log nor error.log, but the error in the above programs seems to be of the 1045 type (Access denied for user ‘foobar’@‘localhost’ (using password: NO)). If it makes any difference, I am still using the IP via http, not domain name with https as my server is not yet production ready.

Could someone kindly point me to information on where I could try to figure out why this might be happening please?

Thank you