Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 5.5.36
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Environment:Linux martin-xps2 3.14.1-1-ARCH #1 SMP PREEMPT Mon Apr 14 20:40:47 CEST 2014 x86_64 GNU/Linux
mysql Ver 15.1 Distrib 5.5.36-MariaDB, for Linux (x86_64) using readline 5.1
Description
[~]% mysql -u root -h 192.168.33.10 -p
Enter password: (I enter the wrong password)
ERROR 1045 (28000): Access denied for user 'root'@'192.168.33.1' (using password: YES)
Exit 1
I enter 192.168.33.10, yet it echoes back 192.168.33.1?
It does seem to connect to the right address, though:
[~]% mysql -u root -h 192.168.33.1 -p Enter password: ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.33.1' (111) Exit 1
It does seem to with the MySQL on the server:
[~]% mysql -u root -h 192.168.33.10 -p Enter password: ERROR 1045 (28000): Access denied for user 'root'@'192.168.33.10' (using password: NO) [~]% mysql --version mysql Ver 14.14 Distrib 5.5.35, for debian-linux-gnu (i686) using readline 6.2
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
> When you are getting "Can't connect to", it's also where the client tried to connect to, the location of the server as you indicated it.
> But when you are getting "Access denied for user@host", it's where the client tried to connect from.
Indeed. This is how MySQL authentication works >_< ... This bug report is phenomenally stupid. I just got confused, which apparently didn't clear up in the course if filing this report.
I owe everyone who wasted their time reading this report a beer.
What is your topology, exactly?
Did you run the client on the same machine both times?
Is the server running on the same machine where you launch the client?
And are you running both MariaDB and MySQL on the same machine in turns?
Please keep in mind that when you provide an address on the command line (-h host), you indicate where to connect to, where the server is running.
When you are getting "Can't connect to", it's also where the client tried to connect to, the location of the server as you indicated it.
But when you are getting "Access denied for user@host", it's where the client tried to connect from.
So, if your server and client are running on different hosts, naturally the messages will contain the different addresses.