Bug #42853 Change wording of the 'disallow root access from remote machines' setup option

• Submitted: 14 Feb 2009 4:14
• Modified: 31 Mar 2014 8:29
• Reporter: Roel Van de Paar
• Status: Closed
• Category: MySQL Server: Config Wizard
• Severity: S3 (Non-critical)
• Version: 5.0.72sp1
• OS: Any
• CPU Architecture: Any

[14 Feb 2009 4:14] Roel Van de Paar

Description:
The current enable/disable option in the 'MySQL Server Instance Config Wizard' says 'Enable root access from remote machines' (on the security options screen, below the password). 

The term 'remote' is incorrect, as it is not possible to connect even on the 'local' machine using the external IP, as can be seen from the below.

How to repeat:
o Run 'MySQL Server Instance Config Wizard' and note the current wording in the security options screen, below the password.

o Example:

192.168.0.50 is my IP, mysql is on this machine, and the option 'Enable root access from *remote* machines' is disabled (unticked).

C:\mysql5.1.31\bin>mysql -uroot -p -P5131
Enter password: ******
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.1.31-community MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> exit
Bye

C:\mysql5.1.31\bin>mysql -uroot -p -P5131 -h 192.168.0.50
Enter password: ******
ERROR 1130 (HY000): Host '192.168.0.50' is not allowed to connect to this MySQL
server

C:\mysql5.1.31\bin>ipconfig

Windows IP Configuration

Wireless LAN adapter Wireless Network Connection:

   IPv4 Address. . . . . . . . . . . : 192.168.0.50

Suggested fix:
Change this to ticked by default (reverse option) and maybe use wording like 'Disallow root access from any interface except for localhost' or similar.

[11 Jan 2010 21:55] Roel Van de Paar

See bug #50219

[15 Jan 2010 0:25] Roel Van de Paar

See bug #18555

[31 Mar 2014 8:28] Yngve Svendsen

Posted by developer:
 
Thank you for the bug report. We are closing this report now for two related reasons:

* MySQL Server 5.0 is an obsolete version of MySQL Server
* For recent MySQL Server versions, the config wizard is no longer available, and the MySQL Installer for Windows is the recommended way to install MySQL Server on Windows