Bug #25661 Connection Dialog: IP is not treated as localhost

• Submitted: 17 Jan 2007 1:49
• Modified: 17 Jan 2007 13:18
• Reporter: Jared S (Silver Quality Contributor)
• Status: Not a Bug
• Category: MySQL Query Browser
• Severity: S3 (Non-critical)
• Version: 1.2.8
• OS: Windows (WinXP)
• CPU Architecture: Any
• Tags: host, query browser, rights

[17 Jan 2007 1:49] Jared S

Description:
Hi,

When I log on as 192.168.0.1 (my IP) I cannot create a stored proc because that host doesn't have rights.  But 192.168.1 is actually (localhost).

How to repeat:
1. Start MySQL query browser
2. Type your ip address as the host
3. Try to add Stored Procedure

RESULT: Fails and falls because you did't log in as 'localhost'

Suggested fix:
Would be nice if MySQL had power to ackowledge particular IP as own address.

[17 Jan 2007 13:18] Valeriy Kravchuk

Why not just to create user or set grants properly? Read http://dev.mysql.com/doc/refman/5.0/en/create-user.html and http://dev.mysql.com/doc/refman/5.0/en/grant.html for the details.

In any case, it is not MySQL Query Browser problem. This is a documented server behaviour (read http://dev.mysql.com/doc/refman/5.0/en/connection-access.html and http://dev.mysql.com/doc/refman/5.0/en/request-access.html). 

"localhost" usually should resolve to 127.0.0.1, by the way.