I just can't seem to figure this one out.
I want to use the command line to connect to a MySQL database residing on another server. I went ahead and created the username and password for the user. I have also granted all privileges on that user for that database.
When using the command:
mysql -h <hostname> -u <username> -p, I get the following error:
ERROR 1045 (28000): Access denied for user '<username>'@'<local_machine_hostname>' (using password: YES)
The problem is that it keeps appending the current machine's hostname into the username. Obviously, that
user@<local_machine_hostname> is not correct.
It doesn't matter what I type. For instance, if I type:
mysql -h <hostname> -u '<username>'@'<hostname>' -p
It does the same, only in the error output, it says:
Access denied for user '<username>@<hostname>'@'<local_machine_hostname>'
Is there a setting in a configuration file which is allowing this to happen? It's really quite annoying. I need to set up a tikiwiki server, and it cannot connect because during the step where you set up mysql, it keeps appending the local machine's hostname to the mysql login name.