Bug #62108 | adding @ in username while it should not add | ||
---|---|---|---|
Submitted: | 7 Aug 2011 22:51 | Modified: | 6 Nov 2011 18:24 |
Reporter: | Mahdi Zareie | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | Connector / NET | Severity: | S1 (Critical) |
Version: | 1.0.10.0 | OS: | Windows (nothing) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[7 Aug 2011 22:51]
Mahdi Zareie
[6 Oct 2011 18:23]
Fernando Gonzalez.Sanchez
Hi Mahdi Zareie, Connector actually sends just the user. This behavior is managed by the MySQL server, accessing remotely appends @ipremote to the user, accessing locally appends @localhost. You can check this running a query "select user, current_user();". Same for other clients like JDBC driver for Connector/J. You need to grant separately privileges to local and remote users, for example for user mahdi, you will do grant all privileges on *.* to 'mahdi'@'localhost'; grant all privileges on *.* to 'mahdi'@'%'; (this is just an example, it is not recommeded to grant all privileges). Let me know if this effectively solves your issue.
[7 Nov 2011 0:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".