| Bug #45047 | Access denied for user | ||
|---|---|---|---|
| Submitted: | 23 May 2009 16:26 | Modified: | 26 May 2009 0:23 |
| Reporter: | Vimalesh S | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: Command-line Clients | Severity: | S2 (Serious) |
| Version: | 5.1.31-enterprise-commercial-pro-log | OS: | Solaris (Solaris 5.10 Generic_138888-05 sun4v sparc ) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | Mutliple Interfaces | ||
[23 May 2009 17:21]
MySQL Verification Team
Thank you for the bug report. Looks like duplicate of this bug: http://bugs.mysql.com/bug.php?id=45017. Please verify. Thanks in advance.
[26 May 2009 0:03]
Vimalesh S
Yes it seems to be similar problem. Is there any mysql 5.1.xx release or patch available to address this issue ?. So that I can make use of that.
[26 May 2009 0:23]
MySQL Verification Team
Thank you for the feedback. The bug: http://bugs.mysql.com/bug.php?id=45017 is in Verified status that means still it wasn't fixed you need to wait until the bug change the status to Closed and see the patch applied or to wait the note which release will introduce the fixes. I am marking this bug as duplicate of bug: http://bugs.mysql.com/bug.php?id=45017. Thanks in advance.
Description: if mysqld server running in a server which has multiple interfaces, then user can't able to login via default interface if created with user@'%' option but user can able to login via other interfaces. Let say say qfe0 and qfe1 which has /ect/host entry as node01 and node.qfe1 repectively. In which node1 (ie. qfe0) said to be default interface and mysqld was running in the default verified by using the ' pfiles <pid if mysqld> ' ps output command line options: 23832 ? S 4:59 /usr/local/mysql/bin/mysqld --basedir=/usr/local/mysql --datadir=/udb/data --user=mysql --log-error=/tmp/data/node01.err --pid-file=/tmp/data/node01.pid --socket=/tmp/mysql.sock --port=3306 How to repeat: root@node01:/> hostname node01 root@node01:/> cat /etc.hosts 127.0.0.1 localhost 192.168.1.1 node01 loghost # hme0 default interface 192.168.10.1 node01.hme1 Login as root and create a new user with '%' to access from any host mysql> CREATE USER 'test'@'%' identified by 'test123'; root@node01:/> /usr/local/mysql/bin/mysql -utest -ptest123 -h'192.168.1.1' ERROR 1045 (28000): Access denied for user 'test'@'node01' (using password: YES) root@node01:/> /usr/local/mysql/bin/mysql -utest -ptest123 -hnode01 ERROR 1045 (28000): Access denied for user 'test'@'node01' (using password: YES) But it is working in same node when tried to login via second interface. root@node01:/> /usr/local/mysql/bin/mysql -utest -ptest123 -h'hnode.qfe1' (or) root@node01:/> /usr/local/mysql/bin/mysql -utest -ptest123 -h'192.168.10.1' Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 70283 Server version: 5.1.31-enterprise-commercial-pro-log MySQL Enterprise Server - Pro Edition (Commercial) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> Suggested fix: